The CreatorCon Call for Content is officially open! Get started here.

Create report from list view

_Alex
Tera Contributor

‎03-13-2024 07:34 PM

I would like to create a dashboard of all change in the schedule state, and I am assuming I need to create a report first and then add to my dashboard. I have a few fields i like to show up on the report pulled from the change form. 

  • Number
  • State
  • Priority 

And fields on the security incident tab on related list 

Hostname

Environment

Affected User

Severity 

Issue is how do I create this report as I am not sure where to even being. 

 

Thank you all.

0 Helpfuls
  • 1,234 Views
5 REPLIES 5

shikhatyagi
Kilo Sage

‎03-13-2024 10:48 PM

Hi @_Alex 

 

You are trying to pull report from two different tables- Change request and sec Incidents.

You need to first create Database view to join two tables- Change request and sec Incidents and then create report.

 

ServiceNow documentation for DB view creation: https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/use/reporting/task/t_Cr...

 

 

ServiceNow documentation for report creation : https://docs.servicenow.com/bundle/washingtondc-now-intelligence/page/use/reporting/task/t_CreateYou...

 

Please mark reply as Helpful/Correct, if it solved your query. 

 

Thanks,

Shikha Tyagi

 

 

0 Helpfuls