Alert using HipChat

Question

Good Morning Everyone, My team has been asked to start using HipChat in conjunction with Jira for incident management, communications. I am trying to get SolarWinds alerts to echo in the HipChat window and have been running into some snags. I saw this thread: Re: Alerting using #Slack#SlackRe: Alerting using #Slack and saw the piece for HipChat, but haven't had great success in getting it to work in my environment. I have the Alert Trigger Action Execute an External VB script with the following value:Here is my script: C:\SolarWinds\Hipchat\hipchat.vbs ${N=SwisEntity;M=ApplicationAlert.ApplicationName} ${N=SwisEntity;M=Node.IP_Address} ${N=Alerting;M=AlertName} Here is the VB Script: sUrl = "https://example.hipchat.com/v2/room//notification?auth_token=" sArgName0=WScript.Arguments.Item(0) ' CAPTION sArgName1=WScript.Arguments.Item(1) ' IP ADDRESS sArgName2=Replace(WScript.Arguments.Item(2), " ", "*") 'Alert Name with spaces changed to hypen sReqColor="""color"":""red""" sReqMessage="""message"":""" + "[" + sArgName2 + "]" + " - " + "Device:" + sArgName0 + " IP Address:" + sArgName1 + """" sReqNotify="""notify"":true" sReqMessage_format="""message_format"":""text""" sRequest="{" + sReqColor + "," + sReqMessage + "," + sReqNotify + "," + sReqMessage_format + "}" HTTPPost sUrl, sRequest Function HTTPPost(sUrl, sRequest) set oHTTP = CreateObject("Microsoft.XMLHTTP") oHTTP.open "POST", sUrl, false oHTTP.setRequestHeader "Content-Type", "application/json" oHTTP.setRequestHeader "Content-Length", Len(sRequest) oHTTP.send sRequest HTTPPost = oHTTP.responseText End Function The message posts, but the detail I expect to see isn't being posted along with it. Unfortunately, this is what I'm seeing in the HipChat window: SolarWinds·Oct-20 9:44 PM [Server] - Device:Microsoft IP Address:Windows I've done some playing around with the arguments, but unfortunately I'm not getting any additional details in the HipChat message. I am clearly not an expert with VB scripting as this was totally taken from the other thread. I am also wondering if my issue is because the example cschomburg posted was for a different type of alert than an Application going down so the variables are all wrong? Thanks in advance for your help! niterave

beeler4304 · Answer

I am currently using the HipChat integration and can get a few things I want to see show up in my HipChat room. Here is an example of what I have currently working. There are a few variables that I cannot seem to get to show up in the HipChat Room, but I am still trying to find a way to make it show. One variable that isn't working is the Disk Label - ${N=SwisEntity;M=FullName} or ${N=SwisEntity;M=DisplayName}.

This is for the Memory HipChat Notification:

In the Alert - Execute a VB Script and select CScript

A few examples of what I use

C:\Solarwinds-Scripts\Memory.vbs "${N=SwisEntity;M=DisplayName}" "${N=SwisEntity;M=IP_Address}" "${N=SwisEntity;M=PercentMemoryUsedThreshold.CurrentValue}%"

C:\Solarwinds-Scripts\Service.vbs "${N=SwisEntity;M=Application.Node.NodeWarrantyAlert.HostName}" "${N=SwisEntity;M=ComponentAlert.ComponentName}" "${N=SwisEntity;M=Application.Node.NodeWarrantyAlert.HostName}" (I don't use the 3rd argument but needed it there for it to work)

C:\Solarwinds-Scripts\CPU.vbs "${N=SwisEntity;M=Caption}" "${N=SwisEntity;M=IP_Address}" "${N=SwisEntity;M=CPULoad}"

C:\Solarwinds-Scripts\Pagefile.vbs "${N=SwisEntity;M=Node.SysName}" "${N=SwisEntity;M=Node.IP_Address}" "${N=SwisEntity;M=VolumePercentUsed}"

C:\Solarwinds-Scripts\ServerDown.vbs "${N=SwisEntity;M=Caption}" "${N=SwisEntity;M=IP_Address}" "${N=SwisEntity;M=Status}"

Then for the VB Script on the Solarwinds server: (I edit the message a little differently for Pagefile, CPU, Services, and Server Down)

sUrl = "https://company.hipchat.com/v2/room/#########/notification?auth_token=##################"

sArgName0=WScript.Arguments.Item(0)

sArgName1=WScript.Arguments.Item(1)

sArgName2=Replace(WScript.Arguments.Item(2), " ", "-")

sReqColor="""color"":""red"""

sReqMessage="""message"":""" + "** PROBLEM Memory Alert: " + sArgName0 + " - " + sArgName1  + " - " + "Memory Used - " + sArgName2 + " **" + """"

sReqNotify="""notify"":true"

sReqMessage_format="""message_format"":""text"""

sRequest="{" + sReqColor + "," + sReqMessage + "," + sReqNotify + "," + sReqMessage_format + "}"

HTTPPost sUrl, sRequest

Function HTTPPost(sUrl, sRequest)

set HTTP = CreateObject("Microsoft.XMLHTTP")

HTTP.open "POST", sUrl, false

HTTP.setRequestHeader "Content-Type", "application/json"

HTTP.setRequestHeader "Content-Length", Len(sRequest)

HTTP.send sRequest

HTTPPost = HTTP.responseText

End Function

Here is the output from that script

**PROBLEM Memory Alert: Servername - IP Address - Memory Used - 65% **

**PROBLEM Service Alert: Servername - Service Name has STOPPED **

**PROBLEM CPU Alert: Servername - IP Address - CPU Used - 100% **

**PROBLEM Pagefile Alert: Servername - IP Address - Pagefile Used - 65% **

**PROBLEM Server Alert: Servername - IP Address is DOWN **

toy4two · Answer

This will do it for you, thanks cshomburg

HipChat Integration

When creating an alert action and you want to post to a HipChat room, first go to https://hipchat.prod.yourcompany.com/home click on the top left "Integrations" link.

Click on BYO Custom Integration

In the Select Rooms change from Global (all rooms) to the room you want to post to.

On the next screen copy your integration URL with key as you will need it for the Solarwinds script.

The following script must be modified for each room with a unique room key.  You can also change the alert color in HipChat from Red to Green depending if you want to alert on an Down or Up (recovered) event.

sUrl = "https://hipchat.prod.yourcompany.com/v2/room/1045/notification?auth_token=xxxxxxxxxx"
sArgName0=WScript.Arguments.Item(0) 
sArgName1=WScript.Arguments.Item(1)
sArgName2=Replace(WScript.Arguments.Item(2), " ", "-") 
sReqColor="""color"":""red"""
sReqMessage="""message"":""" + "ALERT: " + "[" + sArgName2 + "]" + " - " + "Device:" + sArgName0 + " IP Address:" + sArgName1 + """"
sReqNotify="""notify"":true"
sReqMessage_format="""message_format"":""text"""
sRequest="{" + sReqColor + "," + sReqMessage + "," + sReqNotify + "," + sReqMessage_format + "}"
HTTPPost sUrl, sRequest
Function HTTPPost(sUrl, sRequest)
set HTTP = CreateObject("Microsoft.XMLHTTP")
HTTP.open "POST", sUrl, false
HTTP.setRequestHeader "Content-Type", "application/json"
HTTP.setRequestHeader "Content-Length", Len(sRequest)
HTTP.send sRequest
HTTPPost = HTTP.responseText
End Function

Save the script on the Solarwinds server to: C:\solarwinds-scripts  with a name of the room you want to notify

When creating the alert in SolarWinds you must specify "Execute external VB Script" and use CSscript.exe then paste in the location with 3 variables after, like this:

c:\Solarwinds-Scripts\HipChat_Alert_Infra_Monitoring_Test.vbs "${N=SwisEntity;M=Caption}" "${N=SwisEntity;M=IP_Address}" "${N=Alerting;M=AlertName}"

The double quotes are mandatory around the variables.

If you want to make a recovery alert just duplicate the script but rename it "name_Recovered.vbs" and change the color from red to green and change the message from "ALERT: " to "RECOVER: " and use it as the recovery alert.

johnryder_cocc · Answer

Try dumping the SWQL stuff to an email first, and see if the ${N=SwisEntity;M=ApplicationAlert.ApplicationName} starts with 'Microsoft Windows'.

Depending on how Orion is passing the SWQL data to your VB script, you may just need to use the Replace that you have for sArgName2 on 0 and 1.

Or it might be more complicated (add delimiters to the passed SWQL data, or escape characters or some fancy code).

Hope this helps.