Service Catalog important tables for REQ, RITM, SCTask, Catagory, Item...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-12-2019 02:05 AM
Hello All,
I am working on service catalog,
Now i have submitted the request " Ordered it ",
REQ0010013 > RITM0010013 > SCTASK0010038 && SCTASK0010037 "This request got generated"....
What i want to know is : what all database table should i use to get informations for all this :: REQ, RITM, SCTask
REQ0010013 > RITM0010013 > SCTASK0010038 && SCTASK0010037
&& Also the table which keeps information about catalog item, catalog catagory.
For Example:
Request [sc_request] : what this table contains & what is this about
Requested item [sc_req_item] : what this table contains & what is this about
Catalog task [sc_task] :what this table contains & what is this about
PLease help guys, Thank you in advance.....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-12-2019 02:09 AM
Request [sc_request] : Request table contain REQ0010013 information
Requested item [sc_req_item] : it is requested item table contain ritm information
Catalog task [sc_task] :this catalog task which contains task information
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-12-2019 03:02 AM
Hello Manish, Thank you replying.... But is there any more tables other then this 3 which i am missing to get all info like REQ, RITM, SCTask, Catagory, Item..?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-12-2019 02:20 AM
Hi,
Request [sc_request] :
what this table contains & what is this about : It generate all information of requested item per item or per item
Requested item [sc_req_item] :
what this table contains & what is this about : This table contains Logs of requested item whichever you ordered.
Catalog task [sc_task] :
TASK is one of the core tables in ServiceNow. Fields inside this table can be used by any tables which extends task. CATALOG TASK extends tables Task and is generated from a workflow activity
If my reply helps you at all, I’d really appreciate it if you click the Helpful button and if my reply is the answer you were looking for, it would be awesome if you could click both the Helpful and Accepted Solution buttons.
Regards,
Pratiksha
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-12-2019 03:03 AM
Hello Pratiksha, Thank you replying.... But is there any more tables other then this 3 which i am missing to get all info like REQ, RITM, SCTask, Catagory, Item..?
