Ad Widget

Collapse

Displaying Event Log Source and Evenid in a trigger name

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • KevC
    Junior Member
    • Aug 2016
    • 7

    #1

    Displaying Event Log Source and Evenid in a trigger name

    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
  • batchenr
    Senior Member
    • Sep 2016
    • 440

    #2
    Originally posted by KevC
    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
    when you see this trigger on Dashboard
    does it resolves ?

    Comment

    • KevC
      Junior Member
      • Aug 2016
      • 7

      #3
      No it does not resolve in the dashboard either.
      Looking at the doc. a little more closely it looks like these macro are not supported in trigger names based on the following:

      Macro Supported in
      {ITEM.LOG.EVENTID<1-9>} → Trigger-based notifications
      {ITEM.LOG.SOURCE<1-9>} → Trigger-based notifications

      {ITEM.VALUE} which does resolve in trigger names shows the following in the doc.:

      {ITEM.VALUE<1-9>} → Trigger-based notifications
      → Trigger names and descriptions

      So it appears to be working as designed.

      Thanks for the reply.

      Comment

      Working...