Adjust Statistics Detail Retention

ekarella

Our engineers would like to see the Active User Count for our ASAs charted in Perfstack or on a report. When we query Orion.asa.RemoteAccessDetail for ActiveUsers, it appears we can only see data from the past 7 days. I believe this is due to a statistics detail retention setting under our Database settings. Almost all of our settings for this are default (7 days). My question is, which statistic retention do I need to adjust for our query in the future?

ekarella

Here is the SWQL query we are using:

SELECT n.ActiveUsers, n.ObservationTimestamp FROM Orion.asa.RemoteAccessDetail n JOIN orion.nodes a on a.nodeid=n.NodeID and a.Caption like '%<ASA_NAME>%' WHERE n.ObservationTimestamp > ADDDAY(-30,GETUTCDATE())

I believe the data that is queried here is suppoed to roll up into Hourly Statistic Retention which is set to (30) days but I'm not sure how to accurately query the rolled-up data. I would prefer to do that instead of adjusting the statistic retention if possible, so that we can protect our database from growing too large.