I don't remember if it was always this way, but I cannot create a "fully" custom SQL alert.
I am trying to create an alert that will notify me when someone modifies a map they aren't supposed to... (because there aren't any granular map permissions).
I have an audit Report that I created using the following query
SELECT fileName AS Map
, UpdateUser AS 'User'
WHERE isDeleted = 0 AND UpdateUser NOT IN (INSERT LIST OF SW ADMINS HERE)
ORDER BY TimeStamp DESC
This can be modified a bit to provide me an alert when it happens. But, since none of the "starter" queries have anything to do with the mapStudioFiles I cannot.
Is there any way around this for alerts?
The SELECT query is automatically determined based on the object type you choose. You can perhaps choose Node object, limit it to a very specific node (NodeID=1, for example) and your maps query becomes a Subquery Subquery Fundamentals
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.