4 Replies Latest reply: Mar 28, 2014 6:16 AM by Michael Robertshaw RSS

    How can I see the names of the users?

    zhen pan

      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?


        • Re: How can I see the names of the users?

          Maybe try the function OSUser()  


          • Re: How can I see the names of the users?
            Sunil Chauhan

            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

            • Re: How can I see the names of the users?

              There are two system function in Qlik.




              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




              hope this helps



              • Re: How can I see the names of the users?
                Michael Robertshaw

                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