According to the manual and a post in this forum, the following macros can be used to display the Source and EventID from a Windows Eventlog Data item.
{ITEM.LOG.EVENTID}
{ITEM.LOG.SOURCE}
When I put them in a trigger name, they do not resolve.
if I put them in the message portion of an ACTION they do resolve.
I need that information in the message that is fired by the trigger.
Any thoughts on how I might be able to do this ?
This is my trigger name:
Event ID: {ITEM.LOG.EVENTID} Source: {ITEM.LOG.SOURCE} Could not allocate s... - any [email_sqlda]
This is the text of the Action (we have an Action that sends emails):
Host: {HOST.HOST}
Eventid: {ITEM.LOG.EVENTID}
Source {ITEM.LOG.SOURCE}
Message:
{TRIGGER.NAME}
Original event ID: {EVENT.ID}
The email I receive is as follows:
Host: thq07asq
Eventid: 1105
Source MSSQL$CERT2012
Message:
Event ID: {ITEM.LOG.EVENTID} Source: {ITEM.LOG.SOURCE} Could not allocate space for object 'UTest0'UTest1 in database 'UTest2' because the 'UTest3' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. - any [email_sqlda]
Original event ID: 146304533
{ITEM.LOG.EVENTID}
{ITEM.LOG.SOURCE}
When I put them in a trigger name, they do not resolve.
if I put them in the message portion of an ACTION they do resolve.
I need that information in the message that is fired by the trigger.
Any thoughts on how I might be able to do this ?
This is my trigger name:
Event ID: {ITEM.LOG.EVENTID} Source: {ITEM.LOG.SOURCE} Could not allocate s... - any [email_sqlda]
This is the text of the Action (we have an Action that sends emails):
Host: {HOST.HOST}
Eventid: {ITEM.LOG.EVENTID}
Source {ITEM.LOG.SOURCE}
Message:
{TRIGGER.NAME}
Original event ID: {EVENT.ID}
The email I receive is as follows:
Host: thq07asq
Eventid: 1105
Source MSSQL$CERT2012
Message:
Event ID: {ITEM.LOG.EVENTID} Source: {ITEM.LOG.SOURCE} Could not allocate space for object 'UTest0'UTest1 in database 'UTest2' because the 'UTest3' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. - any [email_sqlda]
Original event ID: 146304533

Comment