Excel Imports

cyberfox
Tera Contributor

Hi, 

 

I'm still new to ServiceNow, I'm trying to create visual metrics for information on an excel sheet that is about vulnerabilities, how long they have been vulnerability, projected patch date, and mitigations. The goal is to create metrics for how long it has been vulnerable and the project patch date. 

 

Can I upload this excel sheet to ServiceNow and create metrics for it? 

5 REPLIES 5

BrianProvencher
Giga Guru

You would need to import the excel sheet, run it through a transform map into a new table in ServiceNow, and then you could report on the metrics in that table.

 

 

Thank you! I will try that! 

Zach N
Tera Guru

Hello!

 

Do you have Vulnerability Response setup and configured in your platform? Or are you just trying to use ServiceNow's reporting capabilities?

ServiceNow can only build reports off of information in its own tables, so if you aren't using something like Vulnerability Response, you'll likely need to create a custom table to import this data into.

 

Hope that helps! Let me know if you have any other questions.

cyberfox
Tera Contributor

Thank you! I don't know much about ServiceNow yet, I'm still going through the Associate PM training, so I haven't gotten to that topic. I will definitely look into the Vulnerability Response function!

 

My goal is just to show metrics of how long the vulnerabilities have not been compliant for and to to possibly show when the projected date on when they should be compliant by. This is something my boss has assigned me. Thanks again!