Track License Usage Over Time

Jim_Knicely · June 2019

The LICENSE_AUDITS system table lists the results of Vertica's license automatic compliance audits. You can query it to track your Vertica license usage over time!

Example:

dbadmin=> SELECT * FROM (
dbadmin(> SELECT TRUNC(audit_start_timestamp)::DATE the_date, usage_percent * 100 usage_percent 
dbadmin(>   FROM license_audits
dbadmin(>  WHERE audited_data = 'Total'
dbadmin(>  LIMIT 1 OVER (PARTITION BY TRUNC(audit_start_timestamp) ORDER BY audit_start_timestamp DESC)
dbadmin(> ) foo
dbadmin-> ORDER BY 1 DESC
dbadmin-> LIMIT 7;
  the_date  |    usage_percent
------------+---------------------- 
2019-06-26  | 85.04858490293070432
2019-06-25  | 85.94124716031121234
2019-06-24  | 84.73165229437051977
2019-06-23  | 82.52812722831650034
2019-06-22  | 81.48804673106092692
2019-06-21  | 83.15786945786393982
2019-06-20  | 83.07077737097440010
(7 rows)

Looks like I’m going to need add some new Vertica license soon!

Helpful Links:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/LICENSE_AUDITS.htm
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Licensing/CalculatingTheDatabaseSize.htm

Have fun!