Problem: I needed a way to associate Changes in WebHelpDesk with Outages in SAM (Orion). Solution: I wrote a Powershell script to write Events to the Orion Node Details page by associating a custom field in WHD with the Node IP. Setup: I created 2 custom fields in WHD. One named 'Node IP', and another named 'Orion Event Updated'. Ensure these Custom Fields are associated with the ticket type. The Node IP is used to map the associated Node in Orion; the Orion Event Updated is to identify events already sent. Create a service user in WHD and Orion to execute API requests. I created an Admin in Orion,I used the API key in WHD. Install Powershell file and update Connection settings and Custom Field values. There are 3 Custom Field values to update, read the Script for an example to get the values. Install the Orion SDK on the host running the scheduled task. Setup Script as a scheduled task, mine runs every 15 minutes. In the Orion Node Details page, I added 2 "Custom Query" resources. One for Node Specific, one Global SELECT top 25 NetworkNode as Node, Message, EventTime FROM Orion.Events WHERE NetworkNode = ${NodeID}" and EventTime > Addhour(-24,GETDATE()) and EventType=1000 order by eventtime desc SELECT top 6 Message, EventTime as EventTime_CST FROM Orion.Events WHERE EventTime > Addhour(-24,GETDATE()) and EventType=1000 and NetObjectType='AM' order by eventtime desc Now I can see when others are working on a node that alerts or when someone else's change causes disruption down stream. Hope this helps.

This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Web Help Desk to Orion Integration for Change Management

JohnMartinich over 7 years ago

Problem: I needed a way to associate Changes in WebHelpDesk with Outages in SAM (Orion).

Solution: I wrote a Powershell script to write Events to the Orion Node Details page by associating a custom field in WHD with the Node IP.

Setup:

I created 2 custom fields in WHD. One named 'Node IP', and another named 'Orion Event Updated'. Ensure these Custom Fields are associated with the ticket type. The Node IP is used to map the associated Node in Orion; the Orion Event Updated is to identify events already sent.
Create a service user in WHD and Orion to execute API requests. I created an Admin in Orion,I used the API key in WHD.
Install Powershell file and update Connection settings and Custom Field values. There are 3 Custom Field values to update, read the Script for an example to get the values.
Install the Orion SDK on the host running the scheduled task.
Setup Script as a scheduled task, mine runs every 15 minutes.
In the Orion Node Details page, I added 2 "Custom Query" resources.
- One for Node Specific, one Global
  - SELECT top 25 NetworkNode as Node, Message, EventTime FROM Orion.Events WHERE NetworkNode = ${NodeID}" and EventTime > Addhour(-24,GETDATE()) and EventType=1000 order by eventtime desc
  - SELECT top 6 Message, EventTime as EventTime_CST FROM Orion.Events WHERE EventTime > Addhour(-24,GETDATE()) and EventType=1000 and NetObjectType='AM' order by eventtime desc

Now I can see when others are working on a node that alerts or when someone else's change causes disruption down stream.

Hope this helps.

WHD.ps1