Currently it's not possible to amend the SELECT query in any way, it is fixed. It would be beneficial to be able to amend this for advanced alerting and reporting.
I don't understand this request - can you elaborate?
The SELECT query for any custom alert SQL/SWQL is fixed and can't be amended
You mean alerts created in the "Manage Alerts" area? Can you send me a screenshot so I know what you mean?
Et voila - was just working on it
ahh got it - didn't even know this was an option... I've done a lot of cutomisation of our alerts and wrote a little widet to show which ones are being hit...Can't think what I'd use a custom SQWL query for - what is a typical use?Sorry - not really giving you answers, but questions lol.