Novell Home

Script to convert Volume Trustee Report to CSV

Novell Cool Solutions: Cool Tool

Digg This - Slashdot This

In Brief

Perl script that will convert the text output from the Remote Manager Volume Trustee Report to a CSV file for volume or directory trustee audit.

Vitals

Functional Categories:
  • Workgroup
  • Updated:5 Jun 2006
    File Size:4KB
    License:Free
    Download:/coolsolutions/tools/downloads/trustee.zip
    Publisher:Ryan Nicolson

    Disclaimer

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


    Details

    This Script is used to take the output from the Novell Remote Manager, Volume Trustee Report and make it into a CSV file which can be manipulated by a spreadsheet program. It also creates a CSV file that has been sorted and can be used to past into a Word document and will fit everything across the page as opposed to being cut off on the right.

    Near the bottom of the scripts code there are a few lines that allow you to enter your Novell tree and object info to have them removed from the output. This will just make the columns a little smaller when you go to work with the data later.

    • To run the Volume Trustee Report login to the Novell Remote Manager by opening a web browser and typing in https://IPADDRESS:8009
    • After logging in click on the "i" with a circle around it next to the volume you wish to get the report on.
    • Under the Volume Options Heading click on "Volume Trustee Report." If it asks to create a new report or display the last report, click on create a new one.
    • Make sure you wait until the report has been completed as it does take some time depending on the size of the volume.
    • After running the Volume Trustee Report, right click on the information and do select all.
    • Copy the information into a text file and ensure there are no lines above the first directory listed in the report.
    • Save the text file to the same location as the script. Run the script and it will ask for the location of the file you want it to convert. If you did not save it to the same directory as the script ensure you give it the full path to the file.
    • The script will then output two files named volume_name.csv and volume_name.report.csv to the same directory the script was run from.
    • Open either file in Excel from Microsoft office, Calc from OppenOffice.org or whatever your favorite csv editor happens to be. One is a straight csv file and the other is in more of a report format.
    To Run the script in Linux:
    • At the command prompt navigate to the folder the script is in
    • Type "chmod +x trustee.pl"
    • Type "./trusteereport.pl"
    • It will ask for the file to convert type "/path/to/file.txt
    • It will ask for the name of the volume you are working with, type it in.
    • 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 trusteereport.pl"
    • It will ask for the file to convert type "/path/to/file.txt
    • It will ask for the name of the volume you are working with, type it in.
    • Open and work with "volume_name".csv or volume_name.report.csv

    Update Changed script to ask if you want entire volume in one report or if you want the report split up into one file for each directory at the root of the volume.

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

    © 2014 Novell