creating spreadsheets for security audit
Problem Description :
security audit .... follow the steps below to create the spreadsheets of the forms each users has access to. this is used by the directors to audit the security
Resolution :
1. Create a csv file that has all users and all forms. called bigfile_user
2. remove the header rows
3.create a csv file of distinct users bigfile.csv
4. for /f %i in <bigfile_user.csv> do ssed -e "/%i/!d" bigfile.csv > %i.csv
Revision Date : 9/10/2013