none
how to get the alerts details for particular day for a server in scom or sql RRS feed

  • Question

  • how to get the alerts details for particular day for a server  in scom or in sql server
    • Edited by Chetan rsm Thursday, July 9, 2020 7:04 AM
    Thursday, July 9, 2020 6:41 AM

All replies

  • select * from Alert.vAlertResolutionState ars
    inner join Alert.vAlertDetail adt on ars.alertguid = adt.alertguid
    inner join Alert.vAlert alt on ars.alertguid = alt.alertguid
    where alt.raiseddatetime='yyyy-mm-dd'


    For details, pls. refer to Kevin Holman's Blog SCOM SQL queries
    https://kevinholman.com/2016/11/11/scom-sql-queries/

    Roger
    Thursday, July 9, 2020 8:12 AM
  • hi 

    it is not providing any output.

    I want the operation manager DW alert details .

    Thursday, July 9, 2020 10:40 AM
  • Hi,

    The following T-SQL query should work :

    SELECT AlertName, AlertDescription, RaisedDateTime
      FROM [OperationsManagerDW].[Alert].[vAlert] where ManagedEntityRowId IN
    (SELECT  [ManagedEntityRowId]
    FROM [OperationsManagerDW].[dbo].[vManagedEntity] where FullName  like '%computername.domain.acom%' 
    and RaisedDateTime between '2020-07-07 00:00:00.000' and '2020-07-09 00:00:00.000')

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:


    • Edited by Leon Laude Thursday, July 9, 2020 11:24 AM
    Thursday, July 9, 2020 11:24 AM