Reading a component's component ID from a Powershell script

mlandman

I have a PowerShell script monitor that needs to read its component status to modify its action. It reads conditions from a SQL to a database and acts on the query's returns to restart a service on a different server. The issue is that I need to only restart the service if the monitor is in the UP state (status = 1). I have made this function:

# Function to get the component status to use for restart behavior modification

1. function GetComponentStatus (){
2. # initialize some variables
3. [int]$componentStatus = 0
4. [int]$componentID =123456
5. # build the connection string
6. $conPort = "[port_number]"
7. $conDatabase = "SolarWindsDatabase"
8. $conServer = "[ServerName]\[InstanceName]"
9. $conString = "Server={0},{1};Database={2};Integrated Security=True" -f `
10. ($conServer, $conPort, $conDatabase)
11. # create a new connection
12. $OrionConnection = New-Object system.Data.SqlClient.SqlConnection($conString)
13. $OrionConnection.Open()
14. # query returns the component status, 1,2,3,etc.
15. $query2 = "select top 1 availability as 'Status' from APM_ComponentStatus_Detail
16. where ComponentID = $componentID;"
17. $cmd2 = $OrionConnection.CreateCommand()
18. $cmd2.CommandText = $query2
19. $reader2 = $cmd2.ExecuteReader()
20. while ($reader2.Read())
21.     {
22.     $dataPoint2 = New-Object PSObject
23.     $dataPoint2 | Add-Member -MemberType NoteProperty -Name Status -Value $reader2.GetValue(0)
24.     $componentStatus = $dataPoint2.Status
25.     }
26.   return $componentStatus
27. }

This works but I have to hard-code the value of $componentID (line 4). How do I pull the component ID out of the environment similar to pulling the IP Address using ${IP}, which works from the command line? Is there a SWIS formatted command line macro I can use? I have tried several ${???} macros but none were filled with the componentID.

Thanks

Michael

aLTeReGo

The following list of macros are available to script monitors, such as the Linux/Unix, Nagios, Windows Script, and PowerShell script monitors.

• ${USER}
• ${PASSWORD}
• ${PORT}
• ${Node.SysName}
• ${Node.Caption}
• ${Node.DNS}
• ${Node.ID}
• ${Component.ID}
• ${Component.Name}
• ${Application.Id}
• ${Application.Name}
• ${Application.TemplateId
• ${Threshold.Warning}
• ${Threshold.Critical}
• Node Custom Property Macros ${Node.CustomPropertyName}
• Application Custom Property Macros ${Application.CustomPropertyName}