How can I see the names of the users?

[alexpanjhc]

I am trying to pull a list of names from the assigned cals list

.

Here is the situation with our AD system. We are a big firm, so we do not use the firstname.lastname protocols.

We use a random number combined with first initial and last initial.

So we we see the list of license cal, we only see something like ab12345

Is there a way that we configure them in a way that we can see the actual names?

How do we do that?

thanks!

[#2]

Maybe try the function OSUser()  

[SunilChauhan]

I thing there should be some mapping between AD system i.e ab12345  and user Full name.

You should contact your It Team. they will provide you  AD Name with Full name.

Other wise i dont thing there is function available. Beacuse we are aslo using same convention. wher OSuser () function also fail to retrieve full names

ex: Domain\somecharecter of Name

hope this helps

[#4]

There are two system function in Qlik.

OsUser()

Returns a string containing the name of the current user as returned by the
operating system.

QVuser( )

Returns a string containing the name of the current QlikView user as entered
in a section access.

Test it in a text object

ex:

=OsUser()

hope this helps

MC

[MichaelRobertshaw · Accepted solution]

After authenticating into AccessPoint, the portal attempts to lookup the displayName property of the authenticated user via the configured Directory Service Provider on the DSC, You can associate your Domain with the default AD provider, or with the label of the Configurable LDAP provider. The Configurable LDAP provider allows you to map the displayName property to any attribute in the directory.

OSuser() will supply the authenticated username, which may be the NTNAME in Section Access. It won't provide the displayName.

QVuser() displays the value of USERID from Section Access. Use of USERID and PASSWORD in Section Access is discouraged.

I believe you need to do two things to get full visibility of your CAL assignments. First is to enable an XML representation of the CalData.pgo files under the QlikView Server. Do this by adding PgoAsXmlAlso=1 to the [Settings 7] section of C:\ProgramData\QlikTech\QlikViewServer\Settings.ini then restart your QlikView Server. See also Extracting PGO Data and Analysing License Allocation

Then you want to match the Domain\UserID from the PGO files to data in your Active Directory. There are several ways of reading AD from within QlikView. You can use the Microsoft logparser utility to extract to CSV, or use the AD OLEDB driver directly within QlikView Script, or use a Custom Datasource Connector. Rob Wunderlich supplies an example in the Cookbook downloadable from Downloads - Rob Wunderlich Qlikview Consulting