Condition needed for reports creation

Saib1
Tera Guru

HI,

 

I have sc_req_item table , From there need to access the variable(ServiceNow Instance, Action Required, Environment) in the reports

 

Saib1_0-1703842235667.png

 

Reports

 

Saib1_1-1703842481241.png

 

 

1 ACCEPTED SOLUTION

Saurabh Gupta
Kilo Patron
Kilo Patron

Hi,
You can access as per below screenshot

SaurabhGupta_0-1703842746321.png


Select the catalog item and then variable

SaurabhGupta_1-1703842811715.png

Add variables on List

SaurabhGupta_2-1703842898834.png

 

 

C

If the provided solution meets your needs, kindly consider marking it as helpful and accepting it as the solution. This helps others who may have similar questions.


Thanks and Regards,

Saurabh Gupta

View solution in original post

2 REPLIES 2

Danish Bhairag2
Tera Sage
Tera Sage

Hi @Saib1 ,

 

Go to choose columns from left side of the screen n scroll at the bottom u will se variables field. Select that once u select variables field u will get an option to select the catalog item. Select the catalog item which contains those variables.

As soon as u select the catalog items it will display all the variables which are present under that item

 Select the ones which u require n move it to the right side of the bucket n save it. Run the report again u will be able to see the columns. Remember to save it at last.

 

Thanks,

Danish

 

Saurabh Gupta
Kilo Patron
Kilo Patron

Hi,
You can access as per below screenshot

SaurabhGupta_0-1703842746321.png


Select the catalog item and then variable

SaurabhGupta_1-1703842811715.png

Add variables on List

SaurabhGupta_2-1703842898834.png

 

 

C

If the provided solution meets your needs, kindly consider marking it as helpful and accepting it as the solution. This helps others who may have similar questions.


Thanks and Regards,

Saurabh Gupta