Body
ReportExec
Campus Police use ReportExec. Occasionally they need a new file of employees and students. They will reach out and ask for the file. Follow the instructions below to produce the file.
- Log into SQL Management Studio.
- Run the script located \\ccccommstorage2\comm_it\Infotech\ReportExec called ReportExec.sql.
- Change the year and term in the first where clause as necessary.
- Run the script.
- Copy the results and paste them into an Excel spreadsheet.
- Run a replace to replace NULL with blank spaces.
- Save the spreadsheet and sent it to whomever in Campus Police requested the file.
Note: this process needs to be regularly scheduled and placed in a location that Campus Police can access when they need it.