Share

Read next article:

"Change Polling Type"

Read previous article:

"All assigned Active Monitors"

Export all Passive Monitor

In Default | 0 comments

It is a query to get all related data to Passive Monitor. You can copy them to excel or configure SQL to save data to file.


SELECT PMT.nPassiveMonitorTypeID,
       sMonitorTypeName,
       sMonitorTypeDescription,
       sName,
       sValue

 FROM dbo.PassiveMonitorType AS PMT
 LEFT OUTER JOIN dbo.PassiveMonitorTypeData AS PMTD ON
 PMTD.nPassiveMonitorTypeID = PMT.nPassiveMonitorTypeID
Share on Facebook0Tweet about this on TwitterShare on Google+0Share on LinkedIn0Pin on Pinterest0

Leave a Reply

Allowed Tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

twenty + eleven =

Facebook

Unable to display Facebook posts.
Show error

Error: Unsupported get request. Object with ID 'orchtechsoftwarehouse' does not exist, cannot be loaded due to missing permissions, or does not support this operation. Please read the Graph API documentation at https://developers.facebook.com/docs/graph-api
Type: GraphMethodException
Code: 100
Please refer to our Error Message Reference.