Which table in ServiceNow stores PA Indicator scores?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2023 09:53 AM
Hello Experts,
We are planning to build a historical report of Vulnerable Items for a client, but we don't have the historical data in the instance to build that historical report. We don't want to bring the historical data from scanner into the ServiceNow, instead we want to import the scores of historical data into ServiceNow.
The table highlighted in the below snapshot is from 'pa_scoresheet' page and 'Indicator Score#' row contains an indicator score of indicator for different dates. Instead of bringing the historical data from scanner, we want to populate 'Indicator Score#' row for different historical periods so that we can plot a trend chart for historical period.
I tried to search a table that stores these scores in the instance but I could not find one. We have the scores data from client and we would like to populate that data into the scores table. Please help me here if you have come across something similar scenario anytime.
Please let me know if there is a better way to implement this in ServiceNow
#Performance Analytics, #Reporting, #Dashboard, #PA, #Analytics, #Vulnerability Response, #Vulnerability, #Vulnerability Management
Thanks,
Abhinandan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2023 11:26 PM
Hi @Abhinandan Pati ,
In general you don't do what you would like to do. Either you import the scanner data, and based on this you can create you report, or you choose another report visualization tool instead of ServiceNow, as data is not available in ServiceNow.
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2023 03:00 AM
Hi @Abhinandan Pati - how many scores? If not too many, there's always an option to enter them manually to the existing indicator or create a manual one
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
These 2 tables stores the scores for each indicators and breakdown individually.
pa_scores_l1 & pa_scores_l2
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards