Convert list of group names and its members to CSV and TSV file for reporting

0 Likes

This file will take a text file that has been copied from running the nlist command from Novell, "nlist Groups /D /C > groups.txt". This command is run from a DOS prompt. This will ask for the file name you
saved the text to and output it to a file in the same directory called groups.csv and a file called groups.tsv. Once they have been created you can sort, etc the data using Excel or Calc from OpenOffice.org. The groups.tsv file makes it easier to copy the groups into a work document if needed for a report.


From a DOS promt run "nlist Groups /D /C > groups.txt" without the quotes. This will create a file called groups.txt.


To Run the script in Linux:



  • At the command prompt navigate to the folder the script is in


  • Type "chmod x trustee.pl"


  • Type "./group.pl"


  • It will ask for the groups.txt file "/path/to/groups.txt


  • Open and work with "volume_name".csv or volume_name.report.csv



To run the script in Windows

  • Ensure you have the Perl interpreter installed on your system


  • At the command prompt navigate to the folder the script is in


  • perl group.pl"


  • It will ask for the groups.txt file "/path/to/groups.txt


  • Open and work with groups.csv or groups.tsv



Update Fixed bug where if a group had Application Associations or had something in the "Other Name" Field in ConsoleOne it would offset the group
members to the "Other Name" or "Application Association" name instead of
the group name and would leave the "Group Name" with no members.

Labels:

Collateral
Comment List
Related
Recommended