I was looking at the discussion from E10 table to replace E9 LicUser trying to figure out how to accomplish the following:
We would like to closely monitor our DefaultUser & DataCollection sessions so that we can better understand how our licensing needs are changing. We want to take a snapshop of the # of each License type each hour.
If I could do a BAQ for it, I was thinking I would use a Windows Scheduled DMT Powershell script, to call the BAQ & export the results to a csv file, and then import that data into UD100. The DMT Powershell bit I’ve done before… provided I can get a BAQ to dump the data I can then schedule the Powershell script every hour and effectively end up with an hourly session log in the UD100 table.
In the referenced discussion, it says that in E9 this data was in LicUser table and in 10.1 this was moved to the Ice.SessionState table, however I am on 10.0, what table is the data in 10.0.?
If anyone has other ideas on how I can get an hourly snapshot of the license count of these two types of licenses…?