cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 11

Where is the "Custom" in Custom SQL Alerts!

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

   , TimeStamp

   , UpdateUser AS 'User'

   , lockUser

   , LockDate

   , ComputerName

   , TimeLastSynchronized

FROM MapStudioFiles

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?

0 Kudos
2 Replies
Level 17

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

I'll give that a try. Thank you.

0 Kudos