I have been given a task from the finance department to help them to chargeback for SASAPP users and write a PowerShell script to automate and alleviate the need for someone to do manual reporting each month.
So here’s the challenge:
Write a PowerShell script that will produce a csv file that contains unique SASAPP Users, the columns in the csv should be username, firstname, lastname, departmentnumber.
The csv should be timestamped somehow with when it was created so that Finance can do an audit at a later date.
People are granted access to SASAPP using two Security Groups, RDS_SAS and RDS_SAS2 so if they are in one of those Security Groups, Finance will charge them.
The departmentNumber AD User attribute actually contains a cost centre code that Finance will use for the chargeback.
Can someone help me to write this powershell script and test?
Your feedback is really appreciated