Database view - Incident and sc_req_item

[David Santel]

We have setup an choice field on incident form. Choice field= Ticket Type:  Incident or Request Type.

On incident form we have Category EOL , subcategory - laptop replacement. 

On sc_req_item we have EOL item.

I need to merge the 2 reports to understand total EOL upgrades for x time. 

 Is this possible? If so how would the database view be configured?

Thanks!

[Ashutosh Munot1]

Hi,

Not sure what you mean by:I need to merge the 2 reports to understand total EOL upgrades for x time. 

Can you explain this.

Thanks,
Ashutosh

[David Santel]

A database view defines table joins for reporting purposes.

For example, a database view can join the Incident table to the Metric Definition and Metric Instance tables. This view can be used to report on incident metrics and may include fields from any of these three tables.

A number of useful database views are installed with the Database View plugin and the Database Views for Service Management plugin. These database views cover most metric reporting needs and greatly reduce the need to define new ones.

Does this help u help me? lol

[Ashutosh Munot1]

HI,

I understand what database view is. But can you tell what is common in this two tables like incident relation with RITM?

Thanks,
Ashutosh

[David Santel]

I am going to be setting up a CHOICE field on the Incident form called "Ticket Type" with choice Incident or Request. We will log our request tickets this way going through helpdesk.

We also have RITM's we used for some automated workflows. Item = "Laptop Replacement"

I need to be able to report on RITM's and the Incident Requests as on report. 

How many requests for month....would include Items and Incident Requests.

Is that possible? Thank you for your help!

Thanks,

David