em_map_alert_to_service Map Alerts per Service

[Kaylee Price2]

I cannot find exact documentation on what Alert Services table em_map_alert_to_service is supposed to be used for. I see it is empty. We need to report on which services were impacted the most from alerts over the last xyz days and I am not seeing anywhere to track count of alerts per service as many of the pulls seem dynamic for impacted services. I do see Impact Status table which seem to somewhat be close.

[AJ-TechTrek · Accepted solution]

Hi @Kaylee Price2 ,

Do you have Service Mapping Plugin activated in your ServiceNow Instance, Also do you have CI mapping available with Services which is available in CMDB_CI_Service (as Services Table is Parent, Under that Application Service, Business Service and Tag based Service Available) to populate the Alerts with Services, you must Have Service to CI mapping available and for that you need to Service Mapping or manual mapping, then only data will be available in Alert Services (em_map_alert_to_service).

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

[AJ-TechTrek]

 Hi @Kaylee Price2 ,

Just to add an relevant information related to that, I tried in my PDI and data available in Alert Service.

1. I created a Demo Alerts on CI - nc6500-a01

2. CI - nc6500-a01 is part of Service - Securities Lending 

3.  See, Alert Services having the details with Alert Number and Services.

I hope this will help to understand the relationship.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

[Kaylee Price2]

So we don't have service mapping plugin paid for, but we have the cmdb services mapped. Many with the Service Association table as alot of them rely on dynamic queries and such. So they populate under Impacted Services tab (dynamic pull) but not in the alert services table). I don't have anything in there hmm.

[AJ-TechTrek]

Hi @Kaylee Price2 ,

Exactly, due that they are not visible in Alerts Services table, I hope its will to give the understanding and resolve your query.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024