topic Active Directory data in QVW in QlikView

Active Directory data in QVW

Anonymous — Wed, 28 Apr 2010 09:00:34 GMT

Hi all,

I'm looking for a way of retrieving the Active Directory data and show this data in a QVW ...

Anyone got suggestions how to get the AD data??

thx

Anita

Active Directory data in QVW

Wed, 28 Apr 2010 09:12:01 GMT

Hi Anita

Take a look at the attached, this does some weird stuff with OUs specifically for us (to get hold of current work stream) but the general concept of loading from AD is there, just strip out all the stuff you won't be needing.

Note: This is normally called just a .QVS file, I had to rename it to upload it to the forum.

Regards,

Active Directory data in QVW

Anonymous — Wed, 28 Apr 2010 09:18:11 GMT

Nigel,

The sample is clear ... but I'm not really sure what to fill in in the datasource ... should I fill in the domain name??

thx

Anita

Re. :Active Directory data in QVW

Wed, 28 Apr 2010 09:31:44 GMT

hello,

what do you think about exporting ad object to an csv file and then load it to qv ? you can use the commande csvde -f filename.csv it will export all ad object to the specified file .

Re. :Active Directory data in QVW

Wed, 28 Apr 2010 09:35:59 GMT

Hi Anita

In the first part, change CollerCapital.Com to your domain name for AD.

In the part where it assigns a value to RootDSE, do the same thing but separate the two parts as is done in the sample.

Most of the bits where it uses the LET statement are very specific to my requirements to obtain a work stream name, which then tells me which server I need to connect to for the data, so you can pretty much remove all of that stuff (better to comment it then test first though):

Re. :Active Directory data in QVW

Anonymous — Wed, 28 Apr 2010 09:37:44 GMT

Doesn't work for me ... 'Invalid Credentials' ... seems that I'm not allowed to do so ...

Re. :Re: Re. :Active Directory data in QVW

Wed, 28 Apr 2010 09:47:36 GMT

yes you must have admin permissions

Re. :Re: Re. :Active Directory data in QVW

Anonymous — Wed, 28 Apr 2010 09:49:38 GMT

I'm not the superadmin but an admin on the system ...

But can't I just get the information in the way nigel suggested then??

Re. :Re: Re. :Re: Re. :Active Directory data in QVW

Wed, 28 Apr 2010 10:13:02 GMT

i SUGGEST YOUR RESPONSE BY MISTAKE how can i disable this

Active Directory data in QVW

Mon, 10 May 2010 09:45:25 GMT

Hi all,

Thank's for the nice solution.

I have a small problem: error when using the "GroupMembers" function.

Any solution?

Thank's again,

Amnon

Active Directory data in QVW

Mon, 10 May 2010 10:23:44 GMT

Amnon

Have you copied the GroupMembers function from my sample into your application? This is a function in the macro code so you can just go in there and copy it, then paste it into your own app.

Cheers,

Active Directory data in QVW

Wed, 12 May 2010 07:33:26 GMT

Hi Nigel,

1. I did not copied the function. Where i can find it?

2. I have tried to load the QVS file with "include" command, but, i can not see anything happened.

3. what is the way to load QVS file?

4. The only way to edit the QVS file is with an external editor?

Thank's again,

Amnon

Active Directory data in QVW

Wed, 12 May 2010 08:47:56 GMT

Amnon

If you open my sample application then hit CTRL-M you will go to the Macro Scripts page, here you'll see the GroupMembers function which should be copied into your application. Actually I noticed that I included only a QVS file, so I've included the function code here so you can copy/paste it into your own app:

REM *************************************************
REM Get members of an Active Directory Group.
REM Returns a string of distinguishedNames seperated by ";".
REM Parameter is the distinguishedName of a Group.
REM This function requires System Access!
REM *************************************************
Function GroupMembers(DN)
 Set objItem = GetObject("LDAP://" & DN)
 strmember = objItem.GetEx("member")
 ret = ""
 For Each Item in strmember
 ret = ret & Item & ";"
 Next
 GroupMembers = Left(ret, Len(ret)-1) ' Drop trailing semicolon
End Function

You don't need to use QVS files at all, you can simply copy the text from my QVS.TXT file and then paste this into your load script, but if you want to use it as a QVS then you should add something like the following to your load script:

$(Include = \QLIKVIEW\QVS\LDAPDataLoad.QVS)

If you use QVS files then yes, the only way to edit those is with an external editor, the only reason I know of to make use of QVS files is if you have aspects of load scripts that are duplicated across many QVW files, then they can be managed in a central location.

Active Directory data in QVW

Wed, 12 May 2010 09:34:01 GMT

Hi Nigel,

Thank you again. It was very helpful.

I will be very grateful if you will send me the link to your sample applications.

Amnon

Active Directory data in QVW

jaymerry — Mon, 17 Oct 2011 14:33:52 GMT

Hello,

Thank your for these script.

Unfortunately, I don't have any data for the GroupUser field, even with GroupMembers function. So, my tables are not linked..

Have you got any idea ?

Thanks for your help,

Regards,

Jaymerry

Re: Active Directory data in QVW

Fri, 27 Jul 2012 20:12:41 GMT

Same issue as Jaymerry. Any guidance?

Cheers,

Sue

Re: Active Directory data in QVW

rwunderlich — Fri, 27 Jul 2012 21:19:45 GMT

Attached is an updated example that doesn't require the macro to get the group members. The improvement was provided by Bram in this thread

http://community.qlik.com/message/239460#239460

Re: Active Directory data in QVW

hirenp0904 — Thu, 18 Apr 2013 00:18:40 GMT

Hi Rob,

Can you tell me how to modify the connect string with credentials of service account to connect to AD instead of logged in user?

Re: Active Directory data in QVW

qlikviewforum — Mon, 22 Jul 2013 16:37:49 GMT

Hi,

The QVW which tries to load the data from LDAP loads only the partial data frequently. We are unable to find the root cause of the issue as the QVW doesn't fails but it loads only the partial data.Can someone please help us to identify the root cause of the issue. It has been happening from quite a long time but we didn't succeed in finding the root cause of the issue. Hope someone can help us for the same.

Regards,

qvforum

Re: Active Directory data in QVW

christerlindber — Mon, 28 Apr 2014 09:55:43 GMT

Hi!

When I added:

FROM 'LDAP://$(RootDse)'

WHERE

objectCategory='user' and

name > '$(arg)'

order by name asc ;

...I got the full list. It was an issue before I added "order by name asc ;" in the end.

Regards

Christer