Generating user and group list from Analytics Repository using VB Script

Default analytics repository based authentication get a little tedious to generate the list of users and associated groups via the manual process. To simply this, a VB Script can be written and used to generate the list of users and associated groups. This script uses the UDML export of the repository to generate the list in text file.
 
This text file is a delimited format file, which can be imported to Microsoft Excel for further analysis. This can also be used to maintain the user/group security setup.
 
Benefits:
  • For user access issues, this output file can be used for determining the security privileges.
  • Reduces manual intervention.