Include Canonical Name from Active Directly in Data Load from AD

HugoBoyle — Fri, 05 Jan 2024 11:51:41 GMT

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,

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

Re: Include Canonical Name from Active Directly in Data Load from AD

HugoBoyle — Fri, 05 Jan 2024 12:22:53 GMT

The field I am looking for can be found in AD under the Object Tab.

I have tried adding field ' canonicalName' to my data load but it is coming across as blanks.