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]

There are few out of the box database view like for Incident SLA, Incident metrics etc... I would suggest you to have a look at those...

[david_walters]

Thanks, still struggling. This view below allows me to build the report I want (I think), but returns no data. Ideas?

[david_walters]

In fact, this isn't showing the correct columns in the report either.

I want to be able to see the variables I've created as columns in the report, is that possible?

[sam_hull]

Hi David,

Were you ever able to get this to work? This is almost exactly what I am trying but I'm not sure what to put in the "where clause" on the database view. I'm not too concerned with getting the variables as columns. I just want to be able to get a report that at the very least, shows me the incident number, variable, and answer. Even if it's one variable per line, that's fine. I can finesse it in Excel later.

Thanks!

Sam

[david_walters]

Hi Sam,

Unfortunately not. I couldn't get what I was after.

If you figure it out though, do let me know.

thanks,

David