report out of metrics

shid077
Tera Contributor

‎11-11-2024 02:36 AM

How to make report out of metrics for 3 months for a particular location on alm_asset table.

0 Helpfuls
  • 216 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

‎11-11-2024 02:45 AM

Hi @shid077 

 

If you need any field from alm_asset table, in that case first create a DB view with metric and asset table. and then you cna use that DVB view in reporting ( table). In report you need to use the created / updated( as per need) 3 month ago. You will get the report. 

 

https://docs.servicenow.com/bundle/xanadu-now-intelligence/page/use/reporting/task/create-report-wit...

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

Mark Manders
Mega Patron

‎11-18-2024 12:38 AM

Just like with PA: any data will only get stored after you create the metric/indicator. You won't be able to report on historical data until you are storing it. If you already have the metric (which I don't think you do, looking at your other questions), you can use Atul's solution. Otherwise: create the metric and start reporting on it as of now. 

 

As said in answers to other questions: you can't report on data you don't have.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
0 Helpfuls