# SQL Query into a Rule (via PowerShell) \> then into Squared Up **URL:** \ **Category:** PowerShell\ **Tags:** performance-rules, sql, scom, powershell\ **Created:** [June 17, 2016, 1:52pm UTC](https://community.squaredup.com/t/sql-query-into-a-rule-via-powershell-then-into-squared-up/148 "2016-06-17T13:52:25Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![martynbaggs](https://community.squaredup.com/letter_avatar_proxy/v4/letter/m/6f9a4e/32.png) [@martynbaggs](https://community.squaredup.com/u/martynbaggs)\ **Post date:** [June 17, 2016, 1:52pm UTC](https://community.squaredup.com/t/sql-query-into-a-rule-via-powershell-then-into-squared-up/148/1 "2016-06-17T13:52:25Z")
Hi all, I would like to run a SQL query against my db which returns a list of rows with a value against each row (sample below). I assume this is done via a vbs script embedded into a Rule run every x mins. The values inserted into property bags, then returned. I have been able to return a single value from a rule and view its change over time (performance), **however getting multiple values into the property bag and returning them ive been unable to do. any help greatly appriciated.** apples 20 oranges 25 pears 3 Script sample below, key server names removed Const adOpenStatic = 3 Const adLockOptimistic = 3 Set oAPI = CreateObject(“MOM.ScriptAPI”) Set oBag = oAPI.CreatePropertyBag() Set objConnection = CreateObject(“ADODB.Connection”) Set objRecordSet = CreateObject(“ADODB.Recordset”) objConnection.Open \_ “Provider=prov;Data Source=db;” & \_ “Initial Catalog=IC;” objRecordSet.Open “SQL query here”, \_ objConnection, adOpenStatic, adLockOptimistic apples = objRecordSet.Fields.Item(0) objRecordSet.MoveNext oranges = objRecordSet.Fields.Item(0) objRecordSet.MoveNext pears = objRecordSet.Fields.Item(0) apples = apples oranges = oranges pears = pears Call oBag.AddValue(“apples”,apples) Call oBag.AddValue(“oranges”,oranges) Call oBag.AddValue(“pears”,pears) Call oAPI.Return(oBag) ---
**Author:** ![jswadley](https://community.squaredup.com/letter_avatar_proxy/v4/letter/j/71c47a/32.png) [@jswadley](https://community.squaredup.com/u/jswadley)\ **Post date:** [June 17, 2016, 1:59pm UTC](https://community.squaredup.com/t/sql-query-into-a-rule-via-powershell-then-into-squared-up/148/2 "2016-06-17T13:59:48Z")
Just to help clarify it for me, are you wanting this in a rule so you can collect the data over time? If not, you could use the SQL Plugin to pull the data into a dashboard. If you are wanting the data over time, it might be best to have each one as its own metric and collect them individually to display the values over time. ---
**Author:** ![Jelly](https://community.squaredup.com/user_avatar/community.squaredup.com/jelly/32/812_2.png) [@Jelly](https://community.squaredup.com/u/Jelly)\ **Post date:** [October 10, 2017, 4:28pm UTC](https://community.squaredup.com/t/sql-query-into-a-rule-via-powershell-then-into-squared-up/148/3 "2017-10-10T16:28:28Z")
You actually have a couple of options here. Squared Up released a PowerShell monitoring management pack that will allow you to create monitoring using PowerShell, anywhere in the authoring pane that you previously saw VBScript. [https://download.squaredup.com/management-packs/powershell-monitoring-management-pack/](https://download.squaredup.com/management-packs/powershell-monitoring-management-pack/) Zvi also created a similar MP that utilizes SQL queries. [https://squaredup.com/blog/a-new-free-management-pack-to-create-scom-monitors-from-any-sql-query/](https://squaredup.com/blog/a-new-free-management-pack-to-create-scom-monitors-from-any-sql-query/) You now have the ability to do it however you like, with relative ease. ---
**Author:** ![martynbaggs](https://community.squaredup.com/letter_avatar_proxy/v4/letter/m/6f9a4e/32.png) [@martynbaggs](https://community.squaredup.com/u/martynbaggs)\ **Post date:** [June 17, 2016, 2:33pm UTC](https://community.squaredup.com/t/sql-query-into-a-rule-via-powershell-then-into-squared-up/148/4 "2016-06-17T14:33:28Z")
Thanks for coming back, I guess id like to explore both options, but yes, over time (say a week) would be best. With regards to the SQL plugin, id like to know more as I could potentially use this for other parts of the system. Is there any documentation about this plugin covering how to install and what it can do? ---
**Author:** ![jswadley](https://community.squaredup.com/letter_avatar_proxy/v4/letter/j/71c47a/32.png) [@jswadley](https://community.squaredup.com/u/jswadley)\ **Post date:** [June 17, 2016, 2:37pm UTC](https://community.squaredup.com/t/sql-query-into-a-rule-via-powershell-then-into-squared-up/148/5 "2016-06-17T14:37:21Z")
[http://support.squaredup.com/support/solutions/articles/206748-how-to-configure-the-sql-plugin](http://support.squaredup.com/support/solutions/articles/206748-how-to-configure-the-sql-plugin)