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?
This topic has been locked.
6 replies Latest Post - 2012-06-18T15:45:30Z by GilSharon
Pinned topic XIV accounting reports
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-18T15:45:30Z at 2012-06-18T15:45:30Z by GilSharon
TMasteen 01000039F5279 PostsACCEPTED ANSWER
Re: XIV accounting reports2012-03-22T15:10:42Z in response to keyboarder2kJanko,
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:36Z in response to keyboarder2kHum ... When I run it manually it works great (I'm using OpenOffice with csv-Option). But when I try to run it as a scheduled task it doesn't generate any files. The task and also the batch starts, as it creates the folder, but there are no files in.
CHofmeister 060001SMKS10 PostsACCEPTED ANSWER
Re: XIV accounting reports2012-03-23T15:19:01Z in response to keyboarder2kJanko
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:11Z in response to CHofmeisterHi
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".