jagannath_p
Participant
ParticipantRoot's IP address in database alerts
Hi All,
Do we have any ways under Action Policy by which we can configure so that Parent/Root's IP address can be populated at the time of DB alerts (MSSQL, Oracle etc.)
Forum Discussion
jagannath_pAny other ways if we are using Action Type "Run a Snippet" using RunBook>Action Policy. Anyone has used this variables <IP_Address":EM7_VALUES["%a"]>
- yaquaholic
Contributor II
We've got similar issues, where we have hundreds of MSSQLSERVER instances.
We managed to resolve the problem using the API first searching /api/device/ for the MSSQLSERVER and then using /api/relationship look up the parents name adding it to the devices:
MSSQLSERVER (Virtual Machine Parent Name)
Then updating the device's name with the API.
Then searching for the databases and adding the parent name which then contains the root device's name:
<DB name>MSSQLSERVER (Virtual Machine Parent Name)
And again updating the device's name with the API.
And all to save our Service Desk 5 minutes logging onto SL1 and having a look 🤷 - jagannath_p
DB alerts in MoM Layer (event management console)
