Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
HugoBoyle
Contributor II
Contributor II

Include Canonical Name from Active Directly in Data Load from AD

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

 

Labels (1)
1 Reply
HugoBoyle
Contributor II
Contributor II
Author

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.