cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Need to stored user count for longer timeframe

noor_afrians
Observer

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

1 REPLY 1

Yosi_Neuman
DynaMight Guru
DynaMight Guru

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 

dynatrace certificated professional - dynatrace master partner - Matrix Soft Ware Division - Israel

Featured Posts