Workaround:
Use nvreport to create the report needed and redirect the output to CSV file so you can use it with your scripts.
Here is the main command to get the 'Expired Offline Media' report in csv, notice the comma separated values.
nvreport -class "Media" -include "%Reuse = TRUE AND %libraryid != status:Normal" -format "%label::25,%mediagroup::20,%barcode::15,%reuse::15,%lastwritedate,%offsitelocation,%libraryid" -sort "%label+ "
For better formatting use the ::number after the column headers to make the view better, feel free to change to suit your requirements.
You should get a nicely formatted output in command line:
Example:
NetVault 11.10 Server "eu9095" - Report "CLI Report"
Component 'Media' at 11:52:24, 01 Nov 2016
Label Group Barcode ReUse Date written Location Library Id
eu9095 12 Oct 09:12-1 ,None ,70F7U001 ,Yes ,12 Oct 2016 ,None ,----------
To redirect to file simply add this bit at the end of the above command:
> c:\expiredofflinemedia.csv
This will create the expiredofflinemedia.csv file under C:\.
Now opening this file in a text editor maintains the formatting for the column headers, but if you intend to use it with MS Excel, you will notice the column headers are not in line with the output.
To fix this simply add these comma separated values at the beginning of the format clause:
Label,Group,Barcode,ReUse,Date written,Location,Library Id%\n
Here is the final and complete command to create the Expired Offline Media report in csv format:
nvreport -class "Media" -include "%Reuse = TRUE AND %libraryid != status:Normal" -format "Label,Group,Barcode,ReUse,Date written,Location,Library Id%\n%label::25,%mediagroup::20,%barcode::15,%reuse::15,%lastwritedate,%offsitelocation,%libraryid" -sort "%label+ " > c:\expiredofflinemedia.csv
Status:
Bug 31809 will be fixed in a future version of NVBU.
