Alert Acknowledge massage in Report with event details.

Hi,

Anyone is using the report where we can get alert triggered event with alert acknowledge massage, below is the test example test sheet based on this we can create report,

Event TimeNodeEvent TypeMessageAcknowledged-statusAcknowledged Alert-Note Acknowledged-timeAcknowledged-By

Please suggest, how we can create a report. with above details.

Parents
  • Hello Everyone,

    kindly anyone can suggest, how can i get the report,

    i used the below both query with inner join but result is incorrect. can you all please modify or find the correct table with join.

    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Select top 1 RelatedNodeCaption, eventID, EventTime, AlertMessage, triggertimeStamp, AcknowledgedTime, AcknowledgedBy, Notes

    From Events

    inner join alerthistory

    on events.eventtype=alerthistory.eventtype

    inner join alertstatusview

    on alerthistory.alertobjectID=alertstatusview.alertobjectID

    inner join AlertHistoryView

    on alerthistory.alertobjectID=alertstatusview.alertobjectID

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Select top 100  RelatedNodeCaption, AlertMessage, triggertimeStamp, AcknowledgedTime, AcknowledgedBy, Notes

    From AlertHistoryView

    inner join AlertStatusView

    on AlertHistoryView.alertobjectID=AlertStatusView.alertobjectID

Reply
  • Hello Everyone,

    kindly anyone can suggest, how can i get the report,

    i used the below both query with inner join but result is incorrect. can you all please modify or find the correct table with join.

    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Select top 1 RelatedNodeCaption, eventID, EventTime, AlertMessage, triggertimeStamp, AcknowledgedTime, AcknowledgedBy, Notes

    From Events

    inner join alerthistory

    on events.eventtype=alerthistory.eventtype

    inner join alertstatusview

    on alerthistory.alertobjectID=alertstatusview.alertobjectID

    inner join AlertHistoryView

    on alerthistory.alertobjectID=alertstatusview.alertobjectID

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Select top 100  RelatedNodeCaption, AlertMessage, triggertimeStamp, AcknowledgedTime, AcknowledgedBy, Notes

    From AlertHistoryView

    inner join AlertStatusView

    on AlertHistoryView.alertobjectID=AlertStatusView.alertobjectID

Children