Alert Acknowledge massage in Report with event details.

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

Please help on this

Please help on this