report out of metrics

shid077 · ‎11-11-2024

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

Dr Atul G- LNG · ‎11-11-2024

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]

****************************************************************************************************************

Mark Manders · ‎11-18-2024

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