I have used SQL queries in email messages under alerts, however I have tried them for trap email messages but they are not working at all.
Can we query the tables in a trap message?
Or how do I make an alert from a trap?
Thanks for your help,
Thanks for the information and suggestion. i will look at a vbscript.
Thanks again,
Pete
Given the EXTREMELY limited functions available in the Traps viewer/alerts, I'd say you'd be better off writing a VBScript that performs the same queries. The problem with that solution, though, would be the fact that you wouldn't be able to link the script and the email you're sending via the trap. Another way around that would be to create the email/query in the same VBScript file and just have that run when the trap is thrown.
