Novell Home

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

Novell Cool Solutions: Cool Tool

Digg This - Slashdot This

In Brief

List all groups on a server with its members in a CSV file and a TSV file.

Vitals

Product Categories:
  • NetWare
  • Open Enterprise Server
  • Functional Categories:
  • Linux
  • Workgroup
  • Updated:5 Jun 2006
    File Size:2KB
    License:Free
    Download:/coolsolutions/tools/downloads/group.zip
    Publisher:Ryan Nicolson

    Disclaimer

    Please read the note from our friends in legal before using this file.


    Details

    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.

    Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

    © 2014 Novell