em_map_alert_to_service Map Alerts per Service

Kaylee Price2 · ‎04-10-2024

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 · ‎04-11-2024

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

View solution in original post

Kaylee Price2 · ‎04-17-2024

To follow up the HI support did confirm there seem to be some job(s) that run with service mapping plugin that populate this so even though we have mapped manually, it wasn't populating! I think that em_alert_bs_status_view also gives us what we need though and seems to work out of box with mapped services we have!