Get PowerShell Script Output from Database

hs08

Hello,

I have powershell script and the result store in 2 variables (message.kb and message.dt). Anyone know in which table both value stored?

I need to make customization report to query both result using SQL.

yaquaholic

Hi hs08,

Glad to hear that you sorted the PowerShell remoting issue, what was the resolution? 

First find the component IDs for the monitors (replace XX with the NodeID where the monitors are applied):

SELECT ApplicationID, 
       Application.[Node].[Caption],
       Name,
       Application.[Components].[ComponentID],
       Application.[Components].[Name]
FROM Orion.APM.Application
WHERE Application.[Node].[NodeId] = XXX
ORDER BY  Application.[Node].[Caption]

And with those IDs in hand, have a look at Orion.APM.CurrentStatistics.