NetWorker: GSTCLREPORT Creates Report With Headers But No Data, Report is Empty
Summary: NetWorker, NMC Reports, gstclreport, empty, blank
Symptoms
- You are using the
gstclreportcommand-line utility to create NetWorker Management Console (NMC) reports. - The reports are successfully created but contain no data aside from the headers and options selected:
E:\Program Files\EMC NetWorker\Management\GST\bin>gstclreport -r "Save Set Details" -u Administrator -P "Pa$$w0rd01" -f "testreport" -x html -v table
java version "1.8.0_211"
Java(TM) SE Runtime Environment (build 1.8.0_211-b12)
Java HotSpot(TM) 64-Bit Server VM (build 25.211-b12, mixed mode)
- Generated report "Save Set Details" as file testreport.html:
Cause
Some reports appear with the same name under different folders. For example, the "Save Set Details" report appears under both:
Reports -> Policy Statistics -> Save Set Details.
Reports -> Legacy Reports -> NetWorker Backup Statistics -> Save Set Details.
This same report appears other times under the "Legacy Reports" folders. The Legacy Report is being loaded by default as indicated by the name "NetWorker Backup Statistics." We should see "Policy Statistics: Save Set Details"
The Legacy reports do not work in the NMC or with gstclreport post NetWorker 9.x.
Resolution
When running reports, specify the path to the report; in this example it would be:
-r "/Reports/Policy Statistics/Save Set Details"
E:\Program Files\EMC NetWorker\Management\GST\bin>gstclreport -r "/Reports/Policy Statistics/Save Set Details" -u Administrator -P "Pa$$w0rd01" -f "testreport" -x html -v table
java version "1.8.0_211"
Java(TM) SE Runtime Environment (build 1.8.0_211-b12)
Java HotSpot(TM) 64-Bit Server VM (build 25.211-b12, mixed mode)
Generated report "Save Set Details" as file testreport.html.

Additional Information
The "Legacy Reports" feature is still included as it is possible to set a "Legacy Reports Retention" period. If this period has passed since an upgrade to NetWorker 9.x (or later) was performed, it is not possible to use these reports.
Usage: gstclreport [-h] -r reportname -u username
[-P password] [-a chartselector] [-c charttype]
[-f filename] [-n fontfamily] [-o orientation]
[-v viewtype] [-x exporttype] [-C "Action Type" argument]
[-C "Client Name" argument] [-C "Policy Name" argument]
[-C "Save Set Name" argument] [-C "Server Name" argument]
[-C Workflow argument] [-C "Workflow Start Time" argument]
Where:
-h Print this help message
-r reportname The name of the report to run, or full path name like "/Reports/Users/User List"
-u username Log into GST server with given name
-P password Log into GST server with given password
-a chartselector The set of Y axis to display in a chart
-c charttype The chart type [bar | pie | plot | "stacking bar"]
-f filename The name of the export file
-n fontfamily A font family to override the default(COURIERNEW). Please note if invalid
-o orientation The orientation [portrait | landscape]
-v viewtype The view type [table | chart]
-x exporttype The type of export [ pdf | postscript | html | csv | print]
-C "Action Type" argument Where argument is a comma separated list of Action Types
-C "Client Name" argument Where argument is a comma separated list of Client Names
-C "Policy Name" argument Where argument is a comma separated list of Policy Names
-C "Save Set Name" argument Where argument is a comma separated list of Save Set Names
-C "Server Name" argument Where argument is a comma separated list of Server Names
-C Workflow argument Where argument is a comma separated list of Workflows
-C "Workflow Start Time" argument Where argument is a From and To date. Date & Time format is MM/DD/YY & hh:mm:ss