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 

Now you provided more details. I tried at my end and i think with Task table is not do able. You need to create a report in change table alone.

Try

But here is another catch, you can use only 1 Related list in one report ,so create same report again and use

[mgoodwin12]

Hi,

Thanks for the suggestion. I'll try it; however, I did create the report from the task table. Still seeing other vendors in the report. I only want to see my company.

Thanks,

Maria

[Dr Atul G- LNG]

Hi @mgoodwin12