Reporting on Alerts on Technical Service

[abrahampc]

Hello!

I'm trying to run a report which will show a count of alerts for technical services, but having trouble finding the table structure connection between the technical services (cmdb_ci_query_based_service), cmdb_ci, and em_alert tables. I would assume this connection exists, due to the Event Management dashboard's list of alerts building a list off of technical services (/nav_to.do?uri=%2F$sw_dashboards.do). I just want to be able to run reports using the reports system. Does anyone know the proper path (for dot walking or whatnot) to run this type of report?

Thanks!

[Michael Skov2 · Accepted solution]

Hi

You can use the table called Alert [em_alert_bs_status_view] and then create a condition for your service. I have created one for a Manual Service (you would just select technical instead), which shows i have two alerts on my service (Invoicing).

[Josh11]

Hi ,

Michael is right. You can you the table em_alert_bs_status_view to generate the report. This table has a field Business Service which contains all the business services such as manual or technical.

So while building a condition build it as- Business Service is "your technical business service name".

e.g   Business service ---is----technical service. By this you will be able to see the alerts associated with this technical services as well as count

One is given in following screenshot :

Try this and let us know if you find any difficulties.

Hit helpful or correct on the impact of the answer.

Warm Regards,

Kiran Salunkhe

Engineer

 

www.DxSherpa.com

[Kiran7]

Hi,

You can use the table Alert(em_alert_bs_status_view) table for creating report. On this table there is a fileld called as Business Service which includes all the BS such as Manual and Technical Business Services. 

You can create a filter as below:

Business Service----is-----Technical (Name of your technical service).

This will give you all the alerts related to this technical service. Please refer below screenshots for reference

Note: Technical service is my own created technical service.

 

Try this and let me know if you face any queries.

Hit Helpful/correct on the impact of answer.

Warm Regards,

Kiran Salunkhe

Engineer

www.DxSherpa.com