sc_task and sc_req_item are generate reports for RITMs with different count.

[atha]

what is the difference between Catalog Task [sc_task], Requested Item [sc_req_item] and [sc_request].

which one give correct report for all requests i.e, RITMs...

sc_task and sc_req_item are generate reports for RITMs but different count and some of the RITMs are missing while compare.

sc_task missing some RITMs as compare we compare RITMs in sc_req_items and vice versa.

[Chuck Tomasi]

You might consider starting with the SLA (task_sla) table and dot-walking to the required fields through the task field. That's the only way you will get to the SLA breached part (without creating some convoluted database view.)

[atha]

Thanks for you suggestion, I have been waiting since 6hr to see your reply. It is good for me.

I am quite new.

please do my favor and give me some tips based on below details.

Now my boss asking to generate report how many RITM request created by customer during particular period of time based on Company, Location, Assignment group, Category(software, hardware & services) & SLA Breached. Please suggest which table gives these requirements and best conditions to generate a good reports.

SLA Breached = table : task_sla and dot-walking

Company wise =

Location wise =

Assignment group =

Category =

[Chuck Tomasi]

Hi Athauallah,

The company information can be found on cmn_company, location=cmn_location, assignment group=sys_user_group, and category is part of the sys_choice table. Knowing the tables isn't the complete answer without knowing how they are related.

It sounds like you might benefit from some reporting training and perhaps take a look at Performance Analytics (because you want to see trends over time.) These are pretty complex reporting requirements that go beyond what I can provide via the community. I recommend reaching out to your ServiceNow account team or visiting the website below.

Reference:

Training and Certification | IT Systems Management | ServiceNow    

[atha]

its a good idea.

Still I need manage these.

have a look one by one below, how I am creating.

1) Number of RITMs (hardware,software & service requests) created on 'Last month' and row=company(dot-walking); Column=Active;           table=catalog Task [sc_task].

Ans: check catalog Task [sc_task] is correct or suggest

2) Number of RITMs (hardware,software & service requests) created on 'Last month' and row=Location(dot-walking); Column=Active                                               table=catalog Task [sc_task].

Ans: check catalog Task [sc_task] is correct or suggest

3) Number of RITMs (hardware,software & service requests) created on 'Last month' and row=Assignment group; Column=Active                                         table=catalog Task [sc_task].

Ans: check catalog Task [sc_task] is correct or suggest

4) Number of RITMs (hardware,software & service requests) created on 'Last month' and row=Item(dot-walking); Column=Active                                             table=catalog Task [sc_task].

Ans: check catalog Task [sc_task] is correct or suggest

Regards,