Creating a CSV style report from command line (4047562)

NetVault Backup provides a Command Line (CLI) tool for creating and running reports, [nvhome]/util/nvreport.

CLI reports will produce either plain text or HTML output configured by an output type flag. CSV output is not a valid output flag for CLI reports, but it is possible to massage CLI reports to output in CSV style.

The following example will create a report showing a few of the NetVault Backup server's licensed capabilities.

^{/usr/netvault/util/nvreport -class "License Capabilities" -format "Description,Licensed,Used%\nNumber of clients,%CLIENTS::5,%CLIENTSUSED::5%\nNumber of SmartClients,%SMARTCLIENTS::5,%SMARTCLIENTSUSED::5%\nNumber of tape drives,%TAPEDRIVES::5,%TAPEDRIVESUSED::5%\n" > /var/tmp/output.csv}

In this example the following block of the command:
^{Description,Licensed,Used%\nNumber of clients,%CLIENTS::5}

Can be understood to mean:
Description,Licensed,Used = plain text for column headers, separated by comma
%\n = newline
Number of clients = plain text
%CLIENTS = Number of clients allowed real name
::5 = show 5 characters of the output

The /var/tmp/output.csv produced file will contain text similar to the following, and can be opened by spreadsheet software as a CSV file:

^{NetVault 8.5.3 Server "BACKUPSRV" - Report "CLI Report"}

^{Description,Licensed,Used
Number of client,5,3
Number of SmartClients,0,0
Number of tape drives,4,4}

To find the available classes to report on, run:
^{/usr/netvault/util/nvreport -help class}

To find the values available in a class, run:
^{/usr/netvault/util/nvreport -help -fields "Class Name"}

(The first column is the realname required for a cli report.)