bsharath
asked on
Shared folder Audit with a script. Record the Shared folder size in an csv or excel.
Hi,
Shared folder Audit with a script. Record the Shared folder size in an csv or excel.
Attached is a sample sheet.
I want a script that i can schedule when run checks all shared folders and records the size in the colum.
So i know which folder when has taken up space. To monitor the shares this would be an excellent help...
Any excel, Batch or vbs script has can do this.
Regards
Sharath
Sample.xls
Shared folder Audit with a script. Record the Shared folder size in an csv or excel.
Attached is a sample sheet.
I want a script that i can schedule when run checks all shared folders and records the size in the colum.
So i know which folder when has taken up space. To monitor the shares this would be an excellent help...
Any excel, Batch or vbs script has can do this.
Regards
Sharath
Sample.xls
ASKER
Thanks mathew
But the size appears as this for a 2.37 MB i get this (2.488644 MB) Can this be changed.
When i run the 2nd time i get the old data erased and new data is inserted.
As this is going to have a log file.
Can this create new files every time i run the script with the date and time. So later i can move all to an excel to compare.
It would be good if the script can find the shares automatically....
But the size appears as this for a 2.37 MB i get this (2.488644 MB) Can this be changed.
When i run the 2nd time i get the old data erased and new data is inserted.
As this is going to have a log file.
Can this create new files every time i run the script with the date and time. So later i can move all to an excel to compare.
It would be good if the script can find the shares automatically....
ASKER
Thanks mathew
But the size appears as this for a 2.37 MB i get this (2.488644 MB) Can this be changed.
When i run the 2nd time i get the old data erased and new data is inserted.
As this is going to have a log file.
Can this create new files every time i run the script with the date and time. So later i can move all to an excel to compare.
It would be good if the script can find the shares automatically....
But the size appears as this for a 2.37 MB i get this (2.488644 MB) Can this be changed.
When i run the 2nd time i get the old data erased and new data is inserted.
As this is going to have a log file.
Can this create new files every time i run the script with the date and time. So later i can move all to an excel to compare.
It would be good if the script can find the shares automatically....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Matthew works great...
Good :)
Thank you for the script post this would be very helpful. I am however getting a script error of object not found line 18 ch17 after the script has written just 3 entries. Is it the log file not being found or the pc share?
You need to enter the shares to be monitored on each line in a text file. Specify the path to this file in the Const rootFolders entry. The logging path is then the Const logFile entry.
Matthew
Open in new window