Horizon View Application USage over last 30 days

[GarTomlon]

Looking for some direction in generating a usage report for my RDSH Applications in Horizon View (7.13).  Looking to create this using powercli (with hv.helper module I assume).  I have looked at the get-hvapllication and I can get the name, but not necessarily seeing any usage information in the command.  Curious if I would need to poll the get-hvevents command?  Any help will be appreciated.  Desired output would be this output over the course of 30 days:
Application Name
Num of Connections

[Mickeybyte]

@GarTomlon 

You will need to check the events to get that information.

I would suggest you check the DB directly using a SQL query as this will be much more performant than using the get-hvevents powershell commands. 

[RetouwNL]

I agree with polling the sql db directly, using the soap api's (powercli) is very slow and generates an bad load on your connection servers. If you really can't use sql directly I'd advise to use the rest api's see https://www.retouw.nl/2023/05/21/getting-horizon-events-using-the-rest-api/