Qlik Community

QlikView Governance

Discussion Board for collaboration on QlikView Governance.

Not applicable

Issues integrating AD Users into QlikView Governance Dashboard

Hi All,

I have a requirement to integrate AD Users into Governance Dashboard(GD). The Authenticated User in GD shows User details as following

E.g. Authenticated User -





mycompanyext\Donna-Trower etc..

Need to show Full Name of the users. I couldn't find a field in which it shows full name in GD.

So I had fetch the following fields from AD Users (name, sAMaccountName) -

E.g.  sAMaccountName, name

         Jpaul, John Paul

          Allen.cole, Allen Cole

I brought in the AD Users into GD script. Created a new field "NewAuthenticated User " to capture only left part of the text eliminating anything before back slash (mycompany\JPaul - 'JPaul) and mentioned where ever Authenticated User was in the script(scipt tabs - Audit, session etc..)

Right([Authenticated user],len([Authenticated user])-Index([Authenticated user],'\')) as NewAuthenticated_User

But by using the above, I was able to fetch and map only few users not all. Can someone guide me, is there a way this can achieved.




1 Reply

Re: Issues integrating AD Users into QlikView Governance Dashboard

Consider using subfield([Authenticated User],'\',-1) to get just the "name" of the user.

Community Browser