This page refers to functionality that has been removed from License Statistics. 

You can use the xfeditdb utility to merge two or more License Statistics databases.

Merges are additive, so identical records for features at each tracking interval are added together. For example, if at a recorded interval AutoCAD's license usage is 3 in Database A and 2 in Database B, the records in Databases A and B will be added together in the resulting database, so the merged data will show 5 AutoCAD licenses used at that interval.

Merged databases can be used to run queries on the data, using the SQL Console in the License Statistics web application. You can also use custom reporting to produce graphs of the combined data. See Examples for examples of using custom reporting in conjunction with merged databases.

To merge License Statistics databases, use the command xfeditdb, followed by the output database name and the input database names. The command syntax is as follows.

xfeditdb --merge output.db input1.db input2.db ...

For example:
xfeditdb --merge adskflex_autocad_07-08.db adskflex_autocad_07.db adskflex_autocad_08.db

After typing the xfeditdb --merge command, the merge runs and its completion is reported in the command window.

Database merging may require up to several hundred megabytes of RAM, but takes only a few minutes or less to run, depending on the size of the database. There is no limit on the number of databases you can merge.

  • No labels