I am looking for a way to automate our tickets per endpoint calculation but I am having some trouble. I currently have all the data I need from the ticketing side (Connectwise) however I cant seem to figure out how to get a count of kaseya agents we have on a given day.

For example I can create a sql query  for how many tickets we get on a given day for the past 30 days. However I can't seam to figure how to track how many Kaseya agents we have on a given day for the past 30 days. 

I am curious to know if anyone else is doing this or even if there is a better way of pulling this information.

Thanks,

Justin