what is the fact table for service request table for indicator source we need to select.

Geetha7
Kilo Explorer

what is the fact table for service request table for indicator source we need to select.

1 ACCEPTED SOLUTION

Replicate the daily and historical jobs for Incident, name them as SC Task Jobs and attach your SC Task indicators to them.

View solution in original post

9 REPLIES 9

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

facts table would be sc_request

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Slawek_Radziewi
Kilo Sage

What do you want to report? 

We use mostly sc_req_item table.

hm69
Giga Contributor

Yes, I would agree with the statements listed above, 

sc_request,

sc_req_item, and I would include 

sc_task if you need the task. 

 

Regards, Hugo

Geetha7
Kilo Explorer

Hi All,

In the indicator source and indicator i have selected as sc_task table as facts table.. but what type of job i need to run to get the data?

Like for incident and problem i have selected the respective facts table and ran the incident daily and historic jobs. I am getting the data correctly.