{"id":310,"date":"2008-12-20T21:40:58","date_gmt":"2008-12-20T19:40:58","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=310"},"modified":"2010-09-01T12:26:52","modified_gmt":"2010-09-01T10:26:52","slug":"query-a-database-with-a-monitor","status":"publish","type":"post","link":"http:\/\/contoso.se\/blog\/?p=310","title":{"rendered":"Query a database with a monitor"},"content":{"rendered":"

I\u00c2\u00a0have seen a number of questions about how to run\u00c2\u00a0queries against a\u00c2\u00a0database and verify the answer. One way is to run a script inside a\u00c2\u00a0monitor. In this<\/a> blog I wrote how to setup a script in a two state monitor. The script in this post\u00c2\u00a0will count number of\u00c2\u00a0 fields, if there are more then five, status of the monitor will be changed. Note that counting starts at\u00c2\u00a00 with fields collection.<\/p>\n

\u00c2\u00a0Const adOpenStatic = 3
\nConst adLockOptimistic = 3<\/p>\n

Set oAPI = CreateObject(“MOM.ScriptAPI”)
\nSet oBag = oAPI.CreatePropertyBag()<\/p>\n

Set objConnection = CreateObject(“ADODB.Connection”)
\nSet objRecordSet = CreateObject(“ADODB.Recordset”)<\/p>\n

objConnection.Open _
\n“Provider=SQLOLEDB;Data Source=R2B1;” & _
\n“Trusted_Connection=Yes;Initial Catalog=ContosoConfiguration;” & _
\n“User ID=CORP\\Administrator;Password=;”<\/p>\n

objRecordSet.Open “SELECT * FROM roles”, _
\nobjConnection, adOpenStatic, adLockOptimistic<\/p>\n

varNo = objRecordSet.Record.Count<\/p>\n

If varNO > 5 Then
\nCall oBag.AddValue(“SQL_Status”,”Error”)
\nElse
\nCall oBag.AddValue(“SQL_Status”,”Ok”)
\nEnd If<\/p>\n

Call oAPI.Return(oBag)<\/p>\n","protected":false},"excerpt":{"rendered":"

I\u00c2\u00a0have seen a number of questions about how to run\u00c2\u00a0queries against a\u00c2\u00a0database and verify the answer. One way is to run a script inside a\u00c2\u00a0monitor. In this blog I wrote how to setup a script in a two state monitor. The script in this post\u00c2\u00a0will count number of\u00c2\u00a0 fields, if there are more then five, … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[13,19],"tags":[66,45,55,67],"_links":{"self":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/310"}],"collection":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=310"}],"version-history":[{"count":11,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/310\/revisions"}],"predecessor-version":[{"id":1345,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/310\/revisions\/1345"}],"wp:attachment":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=310"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}