How to create a Report on a Variable from a Variable Set in ServiceNow

[DiveshTyagi]

Hi everyone,

I have a variable named manual_address in a variable set on the sc_request table. Its values are stored in the question_answer table.

I want to create a report that shows requests where the manual_address variable is set to "Yes".

I’m attaching screenshots of the sc_request and question_answer tables for reference.

Could someone guide me on the best way to set up a report that filters based on this variable's value?

Thanks in advance!

 

[Aditya40 · Accepted solution]

Hi @DiveshTyagi ,

You can create a report using the sys_report table on your table sc_request. In the Configure tab, use the Group By functionality. To apply conditions, navigate to Questions, select the required Record Producer, and then choose the relevant Variable.

For additional clarity, please refer to the links below related to report configuration.

Report on Service Catalog Variables 

Report on Question Variables 

Thanks,

Aditya