Reporting On Incident Variables

[david_walters]

I've seen a few posts about this but none that answer my question.

I have incident records that are created using a record producer. This record producer has a number of variables, some of which map to fields in the incident form.

I would like to create a report that shows a list of the records created by this record producer and the name and value of some of the variables. I can build the report to show the list of records and the name and value of the variables that map to fields (because those are just regular fields in the incident form), but how do you also get variables included in the report?

thanks,

David

[Kalaiarasan Pus]

This answers it

Re: How to report on Incident variable [editor]

[david_walters]

Thanks, but that's not quite it, or perhaps I've misunderstood the answer to the other post.

I want a report that shows each record created by the record producer with all the usual incident fields as columns and then some of the variables as columns.

So .. something like this:

incident number | caller | variable1 | variable 2 |

INC0001 | david walters | banana | dog

Is that possible?

[Kalaiarasan Pus]

Make use of database view and join incident and question_answer table.

http://wiki.servicenow.com/index.php?title=Database_Views#gsc.tab=0

[david_walters]

Ok, thanks.

Had a go at that, but I didnt get very far.

Do you have a worked example, or want to give it a shot and share how it's done?