Need to stored user count for longer timeframe

[noor_afrians]

Hi,

i am trying see user count in range 6 month.

currently i am using this query to show the total user. but this is only last 35 day due retention period.

SELECT Count(DISTINCT(userid)) FROM usersession where userId IS NOT NULL

in my mind it is need to create user session custom metric, but i cannot find the proper way to setup like USQL above.

is there someone facing same problem with me and have solution ?

thanks

[Yosi_Neuman]

Hi @noor_afrians 

For this you can cerate a small automation code that will run User sessions API with your select and push back the information to dynatrace as a metric with Metrics API - POST ingest data points 

If you need minutes interval then create an AG extension that will run the code every minute ,if its for longer intervals use some scheduler to run it every no and than.

HTH

Yos