Export all Passive Monitor

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