Tool

Ryan Nicolson's picture
tool
Reads:

6146

Score:
1
1
2
 
Comments:

0

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

Author Info

5 June 2006 - 10:45am
Submitted by: Ryan Nicolson

license: 
Free

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.

AttachmentSize
group.zip2.31 KB




User Comments

© 2013 Novell