Performance Analytics - Indicator

rjp
Tera Expert

Hi folks,

I just created an indicator that counts the number of Windows servers, it uses the cmdb_ci_win_server table.  Its scheduled to run daily.  My question is...can this indicator return historical data, ie data for the previous 6 months prior to the creation of the indicator?  Let me know if you think this is possible..thanks in advance.

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @rjp , 

 

You can run a historical job that fetches data for the last 6 month if you're utilizing a data specific filter e.g.: Created on or similar. You can't fetch previous states or other fields as this is not stored in the table e.g.: if state changed from deployed to decommissioned 4 months ago. 

 

I hope my answer made sense, otherwise, please elaborate what you would like to collect in the indicator.  

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

Hi @rjp , 

 

You can run a historical job that fetches data for the last 6 month if you're utilizing a data specific filter e.g.: Created on or similar. You can't fetch previous states or other fields as this is not stored in the table e.g.: if state changed from deployed to decommissioned 4 months ago. 

 

I hope my answer made sense, otherwise, please elaborate what you would like to collect in the indicator.  

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

rjp
Tera Expert

Thanks for the info, very helpful!