A week after we began to charge departments for large quotas the IT coordinator requested a report of all their users quotas.
In this case i chose to use an CSV-file so i easy can feed the CSV with other users if a get further requests in the future.
The CSV looks like this:
förvaltning,mapp,mail
KSF,D:\Forvaltningar\KSF,user1@huddinge.se
KUF,D:\Forvaltningar\KUF,user2@huddinge.se
SAF,D:\Forvaltningar\SAF,user3@huddinge.se;user6@huddinge.se
MSB,D:\Forvaltningar\MSB,user4@huddinge.se
BUF,D:\Forvaltningar\BUF,user5@huddinge.se
The New-FsrmScheduledTask schedules a task 15:00 the fourteenth every month.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
#------------------------------------------------------------- #NAME: qouta_report.ps1 #AUTHOR: Viktor Lindström # #COMMENTS: Send an email with quota report. #------------------------------------------------------------- C:\Test\data.csv $förvaltning = $import.förvaltning $mapp = $import.mapp $mail = $import.mail $task = New-FsrmScheduledTask -Time "15:00" -Monthly 14 foreach ($item in $import) { New-FsrmStorageReport -Name $item.förvaltning -Namespace @($item.mapp) -ReportType @("QuotaUsage") -MailTo $item.mail -ReportFormat @("CSV","DHTML") -schedule $task } |