Nagios Support Forum

Code: Select all

select             assoc.id                    as id,             parentNode.id               as parentNodeId,             parentNode.version          as parentNodeVersion,             parentStore.protocol        as parentNodeProtocol,             parentStore.identifier      as parentNodeIdentifier,             parentNode.uuid             as parentNodeUuid,             childNode.id                as childNodeId,             childNode.version           as childNodeVersion,             childStore.protocol         as childNodeProtocol,             childStore.identifier       as childNodeIdentifier,             childNode.uuid              as childNodeUuid,             assoc.type_qname_id         as type_qname_id,             assoc.child_node_name_crc   as child_node_name_crc,             assoc.child_node_name       as child_node_name,             assoc.qname_ns_id           as qname_ns_id,             assoc.qname_localname       as qname_localname,             assoc.is_primary            as is_primary,             assoc.assoc_index           as assoc_index                         from             alf_child_assoc assoc             join alf_node parentNode on (parentNode.id = assoc.parent_node_id)             join alf_store parentStore on (parentStore.id = parentNode.store_id)             join alf_node childNode on (childNode.id = assoc.child_node_id)             left join alf_store childStore on (childStore.id = childNode.store_id)               where             parentNode.id = 464                                                                                                                                                                                         and childNode.type_qname_id in                   (                       54                  )                                                                    order by             assoc.assoc_index ASC,             assoc.id ASC

Code: Select all

    /usr/local/nagios/libexec/check_mssql -H HOST --username USER --password "PASS" --database DATABASE --port 1439 --query "select%20assoc.id%20as%20id%2C%20parentNode.id%20as%20parentNodeId%2C%20parentNode.version%20as%20parentNodeVersion%2C%20parentStore.protocol%20as%20parentNodeProtocol%2C%20parentStore.identifier%20as%20parentNodeIdentifier%2C%20parentNode.uuid%20as%20parentNodeUuid%2C%20childNode.id%20as%20childNodeId%2C%20childNode.version%20as%20childNodeVersion%2C%20childStore.protocol%20as%20childNodeProtocol%2C%20childStore.identifier%20as%20childNodeIdentifier%2C%20childNode.uuid%20as%20childNodeUuid%2C%20assoc.type_qname_id%20as%20type_qname_id%2C%20assoc.child_node_name_crc%20as%20child_node_name_crc%2C%20assoc.child_node_name%20as%20child_node_name%2C%20assoc.qname_ns_id%20as%20qname_ns_id%2C%20assoc.qname_localname%20as%20qname_localname%2C%20assoc.is_primary%20as%20is_primary%2C%20assoc.assoc_index%20as%20assoc_index%20from%20alf_child_assoc%20assoc%20join%20alf_node%20parentNode%20on%20%28parentNode.id%20%3D%20assoc.parent_node_id%29%20join%20alf_store%20parentStore%20on%20%28parentStore.id%20%3D%20parentNode.store_id%29%20join%20alf_node%20childNode%20on%20%28childNode.id%20%3D%20assoc.child_node_id%29%20left%20join%20alf_store%20childStore%20on%20%28childStore.id%20%3D%20childNode.store_id%29%20where%20parentNode.id%20%3D%20464%20%20%20and%20childNode.type_qname_id%20in%20%28%2054%20%29%20%20order%20by%20assoc.assoc_index%20ASC%2C%20assoc.id%20ASC%0A" --decode --warning 50 --critical 200 --querywarning 10 --querycritical 100 --result "Expected result"