Forum Discussion

jagannath_p's avatar
jagannath_p
Icon for Participant rankParticipant
6 days ago

Root'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.) 

  • yaquaholic's avatar
    yaquaholic
    Icon for Contributor II rankContributor 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 🤷

  • Any 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"]>