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