Could you help me with simple query?

Hi! Could you help me with a simple query to gather some components' statistic data with it's timestamp?
Just not sure about exact tables which I need to query.

I have a component with id = 500, which is a child of application id = 322.
As a result I want to get a table like this:

timestamp	value
timestamp	value
timestamp	value
timestamp	value
timestamp (latest poll)	value (current)

In other words, I want to have five last values (statistic data) of this component.

Find more posts tagged with

sam

wsql

Accepted answers

All comments

frn

Hey there, i don't have the full answer but here you can get the statistics data.

Orion.APM.CurrentStatistics | Orion SDK Schemas (solarwinds.github.io)

which I think can be access by SWQL with sth like:

SELECT ComponentStatisticData FROM Orion.APM.CurrentStatistics WHERE ComponentID = @componentid

omavel

Thanks. Sad, but this is only for current stats, not a history data

camping1981

not sure if this is the data you are looking for but give this a try. not sure what this translate to SWQL...but if you have access to just query the database

SELECT TOP 5 *
FROM dbo.APM_ComponentStatus
where ComponentID = '500' and ApplicationID = '22'
order by TimeStamp DESC

omavel

Thank you, but there is no statistic data

camping1981

well you might have to tell us then what the component is and what type of statistics you need. Without that information we have no clue what table you may be needing to join to get this data.

cnorcross

What I suspect you're looking for is going to come down to the component type that you're using.

There's a fair amount of tables that store historical statistic data but which one depends on the component. For example:

To query for historical data from something like an ODBC component, you can look in APM_PortEvidenceChart.

Custom script components like Powershell and you can use APM_DynamicEvidenceChart.

Process component metrics like CPU, Memory, etc can be queried from APM_ProcessEvidenceChart.

These all contain timestamp and componentID fields along with statistics. Additionally, for the Custom Scripts there is a 'ColumnLabel' field for when you have a script component that returns multiple statistics.

Hope that helps some!

omavel

So... There is a usual powershell component which gives me a pair of data: Statistic: value and Message: value
I need to gather historical Statistic: value with timestamp.

I can see component historical data on the standard multiple statistic chart:

But I need a table with timestamp to put it into email/alert body:

Timestamp - Statistic value
22 Jan 2021 3:30 PM - 0
22 Jan 2021 3:35 PM - 0
22 Jan 2021 3:40 PM - 1720
22 Jan 2021 3:45 PM - 0
22 Jan 2021 3:50 PM - 0