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

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>

2 × five =

Facebook

Unable to display Facebook posts.
Show error

Error: (#10) To use 'Page Public Content Access', your use of this endpoint must be reviewed and approved by Facebook. To submit this 'Page Public Content Access' feature for review please read our documentation on reviewable features: https://developers.facebook.com/docs/apps/review.
Type: OAuthException
Code: 10
Please refer to our Error Message Reference.