We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Track License Usage Over Time — Vertica Forum

Track License Usage Over Time

Jim_KnicelyJim_Knicely - Select Field - Administrator
edited July 2019 in Tips from the Team

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!

Sign In or Register to comment.