3 Replies Latest reply: Feb 22, 2012 5:15 PM by Rakesh Mehta RSS

    AD Group information from Server ?

    Dinesh Kumar

      Hi all,

      Is it possible to determine which and all AD groups are associated with any QV application on server? Can we somehow pull this information into cloud?

      Thanks for your time.

       

      Regards,

      Sharma

        • Re: AD Group information from Server ?
          Rakesh Mehta

          You can do it in a VB Script. Something like below:

           

          strFolderName = "C:\QlikView\QlikViewApp.qvw"

          SE_DACL_PRESENT = &h4

          Set objWMIService = GetObject("winmgmts:")

          Set objFolderSecuritySettings = _

          objWMIService.Get("Win32_LogicalFileSecuritySetting='" & strFolderName & "'")

          intRetVal = objFolderSecuritySettings.GetSecurityDescriptor(objSD)

          intControlFlags = objSD.ControlFlags

          If intControlFlags AND SE_DACL_PRESENT Then

             arrACEs = objSD.DACL

             For Each objACE in arrACEs

                WScript.Echo objACE.Trustee.Domain & "\" & objACE.Trustee.Name

             Next

          Else

             WScript.Echo "Error reading security info"

          End If

           

          put above code in a .vbs file, change the file path and name in the first line and run it in the server. It will give you popup of all AD Groups assigned to the app.

           

          You can turn this code into one which reads all the folders, and sub-folders, and appends information to a file. Then, you can read that file anywhere you want. You can also run this as a macro in your application, just enable the system access on the macro editor in QV.

           

          Hope this helps you.