1 Reply Latest reply: Apr 4, 2017 3:42 PM by Tyler Waterfall RSS

    Issues integrating AD Users into QlikView Governance Dashboard

    Satish Bathini

      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.