The following example shows querying the "test.db" database to produce a report of maximum used hours and maximum used licenses, excluding the feature 46300ACD_2005_0F. You would type a command similar to the following to produce this report.
| No Format |
|---|
C:\xflicstat>xfcustomreport -usagereport -description "my report" -reportname "Reportname" -database "c:\test\custom_licstat_reports\test.db" -includecolumn max_used_hours,max_used_licenses -featurefilter 46300ACD_2005_0F |
The generated HTML report looks like the following. The queried database had only two features, so excluding the feature 46300ACD_2005_0F resulted in only one feature included in the report.
The CSV file, when opened in Microsoft Excel, looks like the following example.
Examples of using custom reporting for merged databases
One highly useful application of custom reporting is using it in conjunction with merged databases (see section 8.3, Working with License Statistics database data using xfeditdb for information about merging databases). For example:
...