Show acknowledged alerts and notes in Orion reports

When Orion generates an alert, it is displayed under Active Alerts as long as the trigger condition is active. When the alert has been resolved and the user has added acknowledgment and resolution notes, the trigger condition is no longer active and the alert is removed from the list of active alerts.

Described here, how to create a report on acknowledged alerts showing the acknowledgment notes.

The AlertHistoryView table shows the history of the alert including those that have been acknowledged and the notes placed during the acknowledgment. Execute the following query using Orion Database Manager:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

Select
TimeStamp,
EventTypeWord,
Name,
ObjectType,
Message,
AccountID,
AlertObjectid,
EntityCaption,
LastTriggeredDateTime,
AlertNote,
Severity
FROM [dbo].[AlertHistoryView]
WHERE EventTypeWord = 'acknowledged'
Order by TimeStamp DESC

To - use the database manager

The following is a sample output of the query when executed in Orion Database Manager. The Message Column shows the details entered during alert acknowledgment: This query can also be used to generate a report by using the Advanced SQL template when creating the report and then applying this query. Additional information on this process is here:
How to Create a Custom SQL Report in the Orion Web Console