The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Reporting: Is there a list of tables most commonly used in reports for INC, CHG, REQ, and what they include?

Tracy Pfahl
Kilo Explorer

For reporting on Incident, Change and Request, there are a group of standard tables we use repeatedly (listed below).  Does anyone know of a summary of these common tables that describes when to use one over the other based on the data you are targeting?  
Thanks, 
Tracy

  1. sys_user
  2. sys_user_has_role
  3. sys_user_grmember
  4. task
  5. task_sla
  6. change_request
  7. cmdb_ci_computer
  8. cmdb_ci_outage
  9. cmdb_ci
  10. sn_customerservice_case
  11. incident
  12. incident_sla
  13. kb_knowledge
  14. kb_use
  15. sc_req_item
  16. sc_request
  17. sc_task

 

2 REPLIES 2

Ammar Aldieri
Kilo Contributor

You can just use the task table and use the task type filter to choose type of task.

For example:

Task Table chosen

Filter chosen is  task type= incident/incident task/Catalog task

Adam Stout
ServiceNow Employee
ServiceNow Employee

If you are trying to get started, I always recommend starting with the Out of the Box content.  That should get you off and running an get you understanding how they all fit in.