ServiceNow Reports

[mgoodwin12]

Hello,

I'm trying to run a report that includes Incidents, Problems and Changes. I'm able to pull all three record types into the report; however, there is more than once vendor using the tool. When I run the report I come up with thousands of records. I tried filtering the other vendors out by using Company.vendor is xxxx in my criteria but since the company field is sometimes (empty) I'm not getting an accurate report. Any suggestions for which field to use to differentiate and only pull up records for my company? 

Note. I do not have access to Studio and I'm not an admin. I only have itil access.

Thanks,

Maria

[Dr Atul G- LNG]

Hi @mgoodwin12 

You need to create a report on the Task table and then in the condition you need to select task type and vendor.

But reporting on task table can impact your system performance

[mgoodwin12]

Thanks, that seemed to have worked to pull only my company; however, my change total is very low. I'm asking for changes from 1/1/23 until today and I only come up with 62. I know we've processed more changes than that.

[Dr Atul G- LNG]

Might be company.vendor condition is not full filling. Please check the data again in change .

[mgoodwin12]

I don't understand; what do you mean by fullfilled and check the data for change?

Also, this is what my admin told me; in case it helps:

The Company field is populated only when a user creates a Normal or Emergency type change request from the Incident page. There is a button that appears upon clicking the context header—please refer to the attached screenshot. The logic is as follows: If the Company field on the parent Incident or Problem record contains a value, that button will copy the same value into the Change Request. In the Incident record, the Company value is populated based on the Caller. For example, if the Caller is XXX and his company in the user account is XXX, then the Company field in the Incident will display XXX. If a Change Request is created from that Incident using the mentioned button, the new CR will have the Company field set to XXX. However, if the CR is created manually by navigating directly to the Change Request form, the Company field will remain empty. Let me know if you have any questions