Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Alert Macro Question with Orion V7

I am trying to make an Alert Macro update our inhouse Help Desk SQL database with same info from the ActiveAlerts and Nodes tables, does anyone have any suggestions?

Thanks in advance.

Len

Find more posts tagged with

Accepted answers

All comments

Network_Guru

Perhaps you can send the alerts to your helpdesk server using SNMP trap from Orion,
and have these imported/logged into the database using a third party util,
such as Kiwilogger?
There are many different ways to do this, all depending on your help desk software.
Can it receive e-mails and input them into the database?
You could use the "log alert to a file" option, and have a drive mapped to the helpdesk
server. Create the file on the server and import it into the database.....

-=Cheers=-
NG

DonYonce

Len,
There are a number of ways to do this.
Here are a few of the more common .. and a couple not so common

1) Send a SysLog message.
Many help desk systems can update trouble tickets via SysLog messages (ala Remedy).

2) Send an SNMP trap.
Once again, some help desk systems can update a trouble ticket via an SNMP trap.

3) Run an external program or VB Script.
Add an Alert action that runs an external program and passes the information you need from Orion as command line parameters. The external program would then update the SQL database.

4) Send a preformatted E-Mail to the Help Desk system.
Many help Desk systems support trouble ticket creation and updating via simple E-Mail forms.

5) Have the Orion server automatically post an update via a Web page form.
This one is kinda complicated, but works quite well once it is setup.
Add a "Get or Post a URL to a Web Server" action to the Alert. Then specify the complete URL of the Help Desk web form that should be filled in automatically. Either include each field in the form as part of the URL, or... you can even include each of the form's fields as part of an HTTP POST.

If you have an "in-house" developed application, your best bet may be triggering en external program to update the SQL database in real time.

LenBoyer

Don et al,

I am trying the POST to a web page, but it appears as if Orion isn't firing the webpage? Get doesn't seem to fire the webpage either, I'm almost at wits end, think i'll go home and soak up some eggnog and try and tackle this one in the new year.

Len

Network_Guru

Len,

I haven't used the post to Web page feature yet, but I have set up alerting to send a web page via e-mail. Here is a sample of what the URL to send looks like:

ORION/.../CustomChart.asp

I find a chart or graph which I want to send by surfing to the web page on Orion.
I then copy & past the URL into the Trigger URL field.
I just substitute the node number of the chart I want to send with the macro ${NodeID}.

When the alert fires, it e-mails the webpage with the packet loss graph for the associated node.

Also make sure you have created the Directlink account in the account manager, as I believe it uses this account to send the URL.

-=Cheers=-
NG