reporting trouble

[El Cuchi]

hi All,

I trust this email finds you well.

Situation

i want a report showing all incidents in a period of time where i can specify in a filter the it owner.

The "IT owner" is a reference field in the business application form.

We use the "configuration item" field in the incident form to select the ci (could be a business application or a server, switch, etc).

The idea is for the report is to select the "it owner" and to show a list of incidents where the CI has the it owner configured in the business application form (without having duplicate records).

Issue 

the issues i am facing are:

1 - when using a simple report (incident table) i can only show incidents where the CI is a business application.

2 - when using a database view (incident, business application, cmdb_rel_ci) the report shows duplicate records because i am using the "relationship" table.

is there a better way of doing it without having this issues?

i have access to analytics. could i use it to get this report?

regards.

[Dr Atul G- LNG]

Then it will not show when the CI class is BA, as this field exists only on BA. If you select any other class, this field will not appear because other classes don’t have it. So either bring this field to all CI classes — which might not be a good case — or keep it as it is, like in BA.