Reporting on custom variables

peterleathe
Giga Contributor

First let me apologise for putting this in probably the wrong group, and for asking the following question which I'm sure has been answered many times before.

 

I am new to Service Now and just trying to get my head round the data dictionary so I can create a report.

 

So, my issue I have is;  I'm trying to create a report for the Asset Management team to show a hardware recovery request's location.

 

We have used what appears to be a custom variable for the Location (and other items) but I am not sure where they would be held in the database.

 

When I inspect the HTML data the lable is a long string of random numbers and no clue as to the table location.

 

I guess my main question is, "How do I find out which table a particular field is in".

 

Grateful for any assistance.

1 ACCEPTED SOLUTION

Ok so it is a catalog item variable. You can create a report on the sc_req_item table and get the variables for that catalog item.

On the report click on the columns button and the scroll to the bottom and single click Variable so it only highlights it. Once you do that an expand button will appear.

 

BrianLancaster_1-1753724651478.png

 

Click on that and it will ask for the catalog item name. Once the item is selected the variables will appear so they can be put in the selected section of the report.

 

I'm not sure why you keep saying non-standard as it looks like you are using variables as they are attended to be used.

View solution in original post

4 REPLIES 4

Brian Lancaster
Tera Sage

You mentioned request. Is this a Service Catalog item variable that you are talking about?

Hi Brian,

 

The situation is we have a request ticket for our staff to request a collection of kit.  Within that request ticket there's variables that appear to be non-standard.

 

So there's a radio button for "Local Office" collection

and then either a field with a drop down list if they select Local Office, or a free text field so they can put their home addresses in.

 

When I examine the HTML data I get something similar to  id="label_ni.VEa1207ce183be2650e0579170deaad309"

 

Which I assume is the field name in a table somewhere!  I just don't know the table so I can check for the contents if that makes sense?

 

I've put the form image below if that helps any

Ok so it is a catalog item variable. You can create a report on the sc_req_item table and get the variables for that catalog item.

On the report click on the columns button and the scroll to the bottom and single click Variable so it only highlights it. Once you do that an expand button will appear.

 

BrianLancaster_1-1753724651478.png

 

Click on that and it will ask for the catalog item name. Once the item is selected the variables will appear so they can be put in the selected section of the report.

 

I'm not sure why you keep saying non-standard as it looks like you are using variables as they are attended to be used.

peterleathe
Giga Contributor

Hi Brian, thank you so much for that!  I had got to that part but when I expanded the Variables it presented the list differently to how other lists had been presented so I went no further.

 

Your explanation of what I need being a catalogue item makes sense now!!

 

My reason for saying "non-standard" is just my mannerism in that the standard fields would be things such as item number, assigned to, etc where as what I was looking for are not part of the "out of the box" experience so, in my mind, they're "non-standard".

 

I should be able to produce the report I need now thanks to your expert knowledge and speedy reply's.