Applications Systems

Create SAM component report that includes Multivalue Messages and Component Messages

This article describes the steps on how to pull report information from the Component Messages in a SAM component.

First published date

10/10/2018 7:51 PM

Last published date

10/20/2022 1:45 AM

Overview

This article describes the steps on how to pull report information from the Component Messages in a SAM component. 

Product section

Server Application Monitor

Resolution

  1. Open the SQL Management Studio.
  2. Sign into SQL.
  3. Query the View 'APM_AlertsAndReportsData' in the database. For example, 
    SELECT TOP 1000 *
  FROM [dbo].[APM_AlertsAndReportsData]
  4. ​Select the columns you want to retain and remove the others. SolarWinds recommends that you retain MultivalueStatistics, MultivalueMessages, and ComponentMessage. Example query: 
SELECT NodeId, 

    NodeName, 

    ComponentName, 

    ApplicationName, 

    ComponentMessage, 

    MultiValueStatistics, 

    MultiValueMessages, 

    WindowsEventMessages

FROM [dbo].[APM_AlertsAndReportsData] where ComponentName ='HTTP Port Monitor'