Kevin Holman's System Center Blog

Posts in this blog are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified in the Terms of UseAre you interested in having a dedicated engineer that will be your Mic

Alert Notification Subscription Variables, and linking that to the console, database, and SDK

Alert Notification Subscription Variables, and linking that to the console, database, and SDK

  • Comments 10
  • Likes

Attached you will find a spreadsheet, with all the possible alert notification subscription variables that I am aware of.  In this spreadsheet, I link these to the same values in the Alert table of the DB, the alert view of the DB, the Console alert view, the SDK (Get-Alert), and lastly the new R2 Connector Key pairs.

My thought was to better understand each data property type of an alert, and what you can managed, from each area.  Hope this is beneficial.

Most of these are listed at my other blog post on alert description and notification variables:

Here is a sample shot of the spreadsheet tool:


See attached:

Attachment: Alert Properties Notification Subscription Variable Master Table_v1.xlsx
  • Thanks for this information Kevin.

  • Kevin,

    Any idea how to add the other items available in the alert itself, such as NetbiosComputerName, etc. for notifications?  I don't see them on the spreadsheet so I assume they are not native.

  • I have same situation as Marnix, we use SCOM to send email alert notification, but details in notification is not practical.

    Generally in most company, we need basic information such as...

    Hostname : only NetBIOS name, not current path name as SCOM using

    IPv4 : should be very common value to scope and identify target monitoring.

    GroupName: In the real world, most company categorized group of servers rely on project, or production role, not group by Microsoft product.

    for example, CRM system group, Call Center Group, Web frontend, Web backend.

    this is very useful information to put in alert SMS or Email notification,

    I think SCOM already have information above, but I have to use a lot of effort created PowerShell script.

    I don't understand why this expensive product make it too complicated.

  • Great information that will help in the development of interface programs to process the UNC XML documents.

  • Great job Kevin.  This is very useful information.

  • Very useful information Kevin.

    Question however, Do you know of anyway to get a Servers AD Description field to display in an alert?

  • Dear All,

    I have question for you, In Alert Fields, we have Customer Fields right Can i Assign Performance Counter Value to them

    Let Say For Performance : context_PctUsage we will get this value can i assign this ? to custom Fields ?


  • @Sekhar -

    Yes, if there is any value in the workflow runtime context, you can add this to the alert custom field when alert is generated.

  • Kevin,

    Any idea How to find subscripton details from below ID ?
    SCOM - Notification subsystem failed to send notification over 'Smtp' protocol to ''. Rule id: Subscription0091a017_6a16_4948_b58d_64fa450c8494.

  • @Mitrak

    In SQL:

    select DisplayName, name, description
    from ruleview
    where name like 'subscription%'

    select DisplayName, name, description
    from ruleview
    where name like 'Subscription0091a017_6a16_4948_b58d_64fa450c8494'

    In posh:

    Get-SCOMNotificationSubscription | FT displayname,name

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
Search Blogs