Create Trustee Audit Report

0 Likes

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 /node/1081.



You also require a list of groups and members created by the group.pl script found at /node/1087.



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.

Labels:

Collateral
Comment List
Anonymous
Related Discussions
Recommended