06-13-2018 07:09 AM
I have downloaded the most recent Database Reporting Guide (although the date says 2004). I see in the appendix for Securitylog that License Overage is actionnum 1, subaction 8. But when I query my data for actionnum 1, I don't get any license overages (we have had some), and I see subaction values that aren't listed in the MRG. We don't own Report Services, but are pretty good with SQL queries. What is the best way for me to monitor our license useage (and overages)?
Thanks. Patty
06-13-2018 07:44 AM
Patty,
One query that shows average and maximum use of each license type from the license usage and product SQL database tables for a time period (we use a calendar month):
select datepart(year,LU1.logdate) as 'Year', datepart(month,LU1.logdate) as 'Month',
PS1.productname as 'Product License', LU1.producttype as 'Product ID',
avg(LU1.usagecount) as 'Avg License Use', max(LU1.usagecount) as 'Max License Use', PS1.numcopieslic as 'Owned Licenses'
from hsi.licusage LU1
join hsi.productsold PS1 on LU1.producttype = PS1.producttype
group by datepart(year,LU1.logdate), datepart(month,LU1.logdate), PS1.productname, LU1.producttype, PS1.numcopieslic
order by datepart(year,LU1.logdate), datepart(month,LU1.logdate), PS1.productname, LU1.producttype, PS1.numcopieslic
Note, the Owned Licenses is a current count of licenses owned, and may be misleading as displayed here for prior time periods. We store historical counts of licenses owned in a spreadsheet to reference as needed.
06-13-2018 08:42 AM
06-13-2018 09:05 AM
06-13-2018 09:48 AM
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.