I'd like to make a report of all volumes (oly the masters not the slaves) of our XIVs for accounting. The following data should be in there:
volume_id, volume_name, size (GB), assigned to host
All should be in a CSV file.
How can I create such a report?
TMasteen 01000039F5336 Posts
Re: XIV accounting reports2012-03-22T15:10:42ZThis is the accepted answer. This is the accepted answer.Janko,
There is a XIV Capacity Report "tool",
Description: This Script creates an XLS or CSV file that contains 4 very useful tabs: Systems, Pools, Hosts, Volumes. You can use this to report on your storage, find un-mapped or un-mirrored volumes, check your consumption, etc.
You can find it here
Re: XIV accounting reports2012-03-23T09:18:36ZThis is the accepted answer. This is the accepted answer.
- keyboarder2k 060001QWDA
CHofmeister 060001SMKS16 Posts
Re: XIV accounting reports2012-03-23T15:19:01ZThis is the accepted answer. This is the accepted answer.Janko
On the system that you are running the utility as a scheduled task, does it have excell installed on it? I had a similar issue where the utility would run on my laptop, but when I scheduled it on a server it would not work. Turned out that the utility uses some commands that require excell to be installed. I never tried it with Open Office, so I can not say if that would count.
When the script runs it pulls the data and saves them as .xml files, then it converts those files to the nice .xls spreadsheet. If you look in the created folder while the script is still running you should see some .xml files momentarily. If so then the script is running. It's just failing at the spreadsheet creation partion.
Re: XIV accounting reports2012-03-26T05:58:11ZThis is the accepted answer. This is the accepted answer.
- CHofmeister 060001SMKS
yes, Excel 2003 is installed too. I switched the settings now to Excel-ouput to see what happens then. I see these .xml files while the script runs, but when it should create the spreadsheets, I get this (german) error message on the commandline:
"xiv_capacity_report_from_files.vbs(0, 1) Microsoft Office Excel: Die SaveAs-Methode des Workbook-Objektes konnte nicht ausgeführt werden."
The OS I would like the script to run is "Windows Server 2003 R2 32-Bit".