Custom SQL to display custom SQL data in Orion Node/Application details view?

andrew.crerand

Hi everyone, 

I'm working on building a custom Change Management system and the goal is to be able to view the changes related to a node or application on the details page in Orion. These changes would be stored in a custom table in the Orion database. 

What's the easiest way to display this data on the details page? I was thinking of a simple Custom SQL Table resource with a query like "SELECT * FROM ChangeRequests WHERE NodeID = $NodeID" however it seems macros aren't supported in SQL queries, only SWQL but SWQL doesn't support querying custom tables. 

How do you suggest doing this? 

Thanks, 

Andrew

jonathon.privett

Hey Andrew,

I recommend using the out of the box options to see what users are editing nodes and application monitors.

This is already included in the solarwinds Message Center Audit events.

https://support.solarwinds.com/SuccessCenter/s/article/Viewing-and-reporting-audit-events

https://documentation.solarwinds.com/en/Success_Center/EOC/Content/EOCAG_ViewEventsAndAlerts.htm