In addition to the custom reporting features found in the License Statistics web application, License Statistics includes a command-line utility, xfcustomreport, that lets you generate custom reports as CSV files and HTML pages. This utility works for both Windows and Linux.
With this utility, you can generate exactly the reports you want to see by querying the License Statistics database(s) for the desired information. When running the custom report utility, you specify:
- The report type (usage, user, host, or user/host group)
- A report description
- A report name
- Database(s) to query
- Column(s) to include in the query
- Whether to output graphs (optional)
- Whether to include borrow information in reports (optional)
- Delimiter for CSV output (optional)
- Features to include in the query (optional)
- Users to include in the query (optional)
- Groups to include in the query (optional)
- How often to generate reports (optional)
- Start/end periods for report generation (optional)
Also see Generating custom SQL reports for information about entering SQL queries in the License Statistics web application to produce custom reports. See The License Statistics database for detailed information about the License Statistics database.
Note: Although the master database used by the License Statistics web application is a MySQL database, both the custom report utility and xfeditdb utilize a SQLite database.