6 Replies Latest reply on Oct 21, 2016 8:11 AM by Jeff Strauss

    Query Active Directory for User Attributes

    Vijay Kumar

      Hi I have a report using a different BI tool to query Active Directory for pulling user attributes like user's domain, phone number, email address, City, Country, etc.,

       

      I am using the below script in the other BI tool.

       

      In that tool it will ask the Server name where I will give LDAP://abcd.corp and the provider is QLE Provider for Directory Services.

       

      SCRIPT:

       

      LETLET arg=chr(01);

       

      DO

      LOAD

      displayName as [Full Name],

      givenName as [First Name],

      sn as [Last Name],

      sAMAccountName as [User ID],

      physicalDeliveryOfficeName as Office,

      distinguishedName,

      mail as [E-Mail],

      l as City,

      st as State,

      co as Country,

      c as [Country Code],

      company as Company,

      whenCreated,

      'APAC' as [Region];

      SQL select displayName,

      givenName,

      sn,

      sAMAccountName,

      physicalDeliveryOfficeName,

      distinguishedName,

      whenCreated,

      mail,

      l,

      st,

      co,

      c,

      company

       

      FROM 'LDAP://ABCD.corp' WHERE objectCategory='person' AND objectClass = 'User' and name >'$(arg)' order by name;

       

       

      Is there a way that we can acheive this in Tableau???