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

Looking for a monitor to visit a URL and parse some XML store the value to Orion DB.

I'm looking for a suggestion on the monitor type or script required to visit an HTTP:// URL that displays some XML text. REST API

From viewing this XML the monitor should parse the XML for a particular value and store this number to the Orion DB.

Example I would like to store the value of "Posts" to the Orion DB.

- <PerformanceCounter>- <counters> <counter name="Rate" value="2.2" /> <counter name="Average" value="4.5" /> <counter name="Requests" value="0" /> <counter name="Posts" value="35" />

Once this value can be monitored by Orion I can select to alert based on the value being too high, too low or changing (difference) compared to the previous polling result. Any suggestions or help would be welcomed.

Thanks

Find more posts tagged with

xml_rest_api

Python

Accepted answers

jiri.tomek

Hello,
if you run script on Windows machine using "Windows script monitor", only VBscript and JScript are supported. If you run it as "Linux script monitor" then it depends on your Linux machine. Scripts are executed using "sh" shell so if you have Python installed, it should work fine.

All comments

jiri.tomek

Hello jmorse,
you can try to write a windows script (VBscript/JScript) that connects to your URL, parses XML and returns desired value. Look at http://www.solarwinds.com/NetPerfMon/SolarWinds/OrionAPMAGCreatingWindowsScriptMonitor.htm

Then create Windows Script Monitor that stores your value into Orion DB so you can set alerts on it.

jmorse

I was sort of hoping there was an Orion script development guide, not so much a guide on the actual scripting lauguage but the dependancies of Orion. What I've had to do is pick apart the examples provided by Orion to develop my own scripts.

IE Orion "Hello World" for vbscript, jscript, perlscript etc...

Is Python a supported scripting choice? Does anyone have Orion monitors using Python?

Just looking for some more examples than those provided.

Thanks,

jmorse

I've developed a python script that reads XML via a URL and returns the value I want to see. It's dynamic and can search for other counter names.

I pieced this together from a few examples found on the web.

It's using the SAX parser.

-----------------------------------------------------

from xml.sax import make_parser
from xml.sax.handler import ContentHandler

class CounterHandler(ContentHandler):

def __init__ (self, searchTerm):
   self.searchTerm= searchTerm;

def startElement(self, name, attrs):
   if name == 'counter':
     self.CounterName = attrs.get('name',"")
     self.CounterValue = attrs.get('value',"")
   return

def endElement(self, name):
   if name == 'counter' and self.searchTerm== self.CounterName :
        print "Message: ", searchTerm
        print "Statistic: ", self.CounterValue

searchTerm = "Rate"
parser = make_parser()
curHandler = CounterHandler(searchTerm)
parser.setContentHandler(curHandler)
parser.parse("http://192.168.2.8:1182/Handler/perfcounters.stats")

jiri.tomek