locked
SCOM Duplicate Alerts RRS feed

  • Question

  • Hi Team,

    How we can find the SCOM duplicate ( Same alert Name, same alert description, same server name) alerts created in last 24 hours.

    Monday, October 19, 2015 5:26 PM

Answers

  • Hi RatheeshAV,

    If Name,description,servername are the columns (column1,column2,column3) in same DB table , you can use SQL to query the records :

    select * from dbo.alert a join ( select firstname, lastname from dbo.alert group by column1,column2,column3 having count(*) > 1 ) b on a.column1 = b.column1 and a.column2 = b.column2 and a.column3 = b.column3

    PAUL

    • Proposed as answer by Elton_Ji Saturday, November 7, 2015 12:34 PM
    • Marked as answer by Elton_Ji Monday, November 9, 2015 11:08 AM
    Saturday, October 24, 2015 1:54 AM

All replies

  • Hi RatheeshAV,

    If Name,description,servername are the columns (column1,column2,column3) in same DB table , you can use SQL to query the records :

    select * from dbo.alert a join ( select firstname, lastname from dbo.alert group by column1,column2,column3 having count(*) > 1 ) b on a.column1 = b.column1 and a.column2 = b.column2 and a.column3 = b.column3

    PAUL

    • Proposed as answer by Elton_Ji Saturday, November 7, 2015 12:34 PM
    • Marked as answer by Elton_Ji Monday, November 9, 2015 11:08 AM
    Saturday, October 24, 2015 1:54 AM
  • Is it bug in scom if it showing duplicate for all alert. Is there anything to worry. Or it's comman in scom.

    Omkar umarani SCOM STUDENT

    Wednesday, April 27, 2016 12:46 AM