I have an app that downloads info from Active Directory (user id, groups, depatements etc.) into a Qliksense Enterprise app.
I have been asked today if I can include the 'Canonical Name of Object' from Active Directory into my app.
I had a look at some of the forums/help but I cannot see anywhere that this downloads this value to Qliksense.
My data load is as follows...
LOAD *
WHERE Not(userAccountControl bitand 2); // Exclude inactive accounts
SQL SELECT
co,
department,
division,
employeeType,
givenName,
l,
userPrincipalName,
mail,
manager,
mobile,
pager,
sn,
sAMAccountName,
telephoneNumber,
title,
userAccountControl,
displayName,
streetAddress,
postalcode,
st,
accountExpires,
physicalDeliveryOfficeName,
LastLogon
FROM 'LDAP://valeofoods.local'
WHERE objectCategory = 'person' AND memberOf = '*'; // The * wildcard returns all records in Persons's objectCategory
