Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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 -

custom\aduser1

custom\aduser2

mycompany\JPaul

mycompany\Allen.cole

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.


Regards,

Satish.



        




1 Reply
Employee
Employee

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