Novell Home

Create Trustee Audit Report

Novell Cool Solutions: Cool Tool

Digg This - Slashdot This

In Brief

Creates a trustee audit report that includes Trustees assigned to a folder and their rights, and if any trustees are groups it will list the groups and their members.

Vitals

Product Categories:
  • NetWare
  • Open Enterprise Server
  • Functional Categories:
  • Auditing
  • Trustee
  • Workgroup
  • Updated:28 Jul 2006
    File Size:3KB
    License:Free
    Download:/coolsolutions/tools/downloads/finalreport.zip
    Publisher:Ryan Nicolson

    Disclaimer

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


    Details

    Findgroup.pl will take the lists created with trustee.pl and group.pl and combine them to show the listing of groups, what rights they have and a list of the same groups with it's members. This report is in HTML format and shows the date created at the bottom of the report.

    The report requires a list of folders and it's trustees and thier rights in csv format that would look like this:

    Folder,Rights,Trustee
    ,Rights,Trustee
    Folder,Rights,Trustee

    This file is created by the trustee.pl script found at http://www.novell.com/coolsolutions/tools/17152.html.

    You also require a list of groups and members created by the group.pl script found at http://www.novell.com/coolsolutions/tools/17193.html.

    or one you create yourself called groups.csv in the format of:

    group,member,member,member

    The resulting output will be a HTML document with two tables, one will look like the following

    --------------------------------------
    
    |Group Name    |Member,Member,Member  |
    
    --------------------------------------
    
    |Group Name    |Member,Memebr,Member  |
    
    --------------------------------------
    
    |Group Name    |Member,Memebr,Member  |
    
    --------------------------------------

    and the second table will show

    --------------------------------------
    
    |Folder Name   |Rights  |Trustee      |
    
    --------------------------------------
    
    |              |Rights  |Trustee      |
    
    --------------------------------------
    
    |Folder Name   |Rights  |Trustee      |
    
    --------------------------------------
    
    |Folder Name   |Rights  |Trustee      |
    
    --------------------------------------

    and this is followed by a line showing the date the report was created on.

    This report can be done for an entire volume or just portions of it. I use it for doing an audit of each directory in the root of the volume so the report is not as large as if it were for the entire volume. To do that take the data from the trustee report and copy each directory from "volume_name.report.csv" to a seperate csv file named "directory_name.csv" and run the script on that file.

    To Run the script in Linux:

    • At the command prompt navigate to the folder the script is in
    • Type "chmod +x findgroup.pl"
    • Make sure your groups.csv file is in the same directory as the script
    • Type "./findgroup.pl"
    • It will ask for the volume_name.report.csv file "/path/to/volume_name.report.csv"
    • Open volume_name.report.csv.html

    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
    • Make sure your groups.csv file is in the same directory as the script
    • perl group.pl"
    • It will ask for the volume_name.report.csv file "/path/to/volume_name.report.csv"
    • Open volume_name.report.csv.html

    Update July 10, 2006

    • Changed script name from findgroup.pl to finalreport.pl
    • Updated to remove .report.csv from final reports file name and now be foldername.currentdate.html
    • Updated to have script run on all csv files in directory instead of having to type in each report you want created.

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

    © 2014 Novell