mrxinu

Comments

  • Okay, there's some confusion here. A couple of things to get clear on before jumping in. First, the 'alert evaluation frequency' is how often the *database* is being checked for that condition, not the device. If you haven't modified the default statistics gathering interval its default is 10 minutes. Second, if 'do not…
  • I'm a little confused by the question because you already used the terms "groups" and "dependencies" so it sounds like you know that's what you need. Are you looking for help automating it? Setting it up? Planning it out?
  • Hey BobHatcher​ - since SolarWinds is using standard OIDs to get most of the information it shouldn't matter what vendor the switch is. They certainly have the HP MIBs loaded so unless it's an HP acquisition or a really new device it should be working. Can you give us more information about the model that you're trying to…
  • You're missing the join between Container_AlertsAndReports.GroupName and Nodes.Caption. I don't see any other way to make the association given that members of groups don't necessarily have to be nodes and that GroupName is about as close as you're going to get. I'm booked this week but I'll tinker with this a bit when…
  • Hi there, The SwisClient is meant to be used to talk to the SolarWinds server using SWQL (SolarWinds Query Language) not the database server. There's more information about it at the URL below: Home · solarwinds/OrionSDK Wiki · GitHub Give this a try instead: orionsdk-python/query.py at master · solarwinds/orionsdk-python…
  • Try this query: SELECT Caption, IPAddress, UnManageUntil, UnManageFromFROM Orion.NodesWHERE UnManaged = 1 -- Steven W. Klassen Programmer Analyst @ Loop1 Systems http://www.loop1systems.com/ http://www.linkedin.com/in/mrxinu
  • Hey casanave​ - you could start with the SWQL query below and then whittle it down to just the operation you're looking for. Once you've got that, you can schedule the report to be run hourly via Settings > Manage Reports. If you're not already using SWQL Studio grab the latest copy by installing the Orion SDK: Release…
  • Yeah, Orion has so many points of integration it's dealer's choice. What is SMSC and how would it like to be talked to?
  • Give this a try: SELECT n.Caption FROM Orion.Nodes n WHERE n.VirtualMachine.VirtualMachineID IS NOT NULL
  • The netperfmon eventlog entry will have the same variables as the external application execution. I'd copy/paste the command line you're trying to run into that other alert action and then see what shows up in the event log to make sure the variables are interpolating right.
  • The component you're working with is usually applied on an application that you always expect to be running. It may make sense to move this into a PowerShell monitor but that involves a bit of configuration overhead. You would then be able to check on the process, its CPU consumption, and finally what exit status is thrown…
  • The events for nodes are coded in the events table. A node down is an event of type 5. If you know which particular node it is, you could query the events table for the node you want. You can create SQL variables to insert into alert messages but I'd have to play with this one to figure it out. The variable would look…
  • I'd give support a call on that one. You could run the Configuration Wizard and check 'website' and 'database'. That would probably clear it up.
  • The Linux/Unix Script component supports any executable you want to run - is there any particular reason you wrapped a shell script in Perl?
  • Don't forget to mark 's answer as the correct answer for this thread if he's hit the mark!
  • It looks like there's a Microsoft event ID associated with that issue. You could have your events forwarded as traps to SolarWinds and then alert when you see this particular one come across. http://technet.microsoft.com/en-us/library/cc957250.aspx
  • It's the 'object type' value for a node report. You'd want the ones with the value 'ICMP'.
  • Which report? What's the difference between the two? Are you comparing the same time period on the same device?
  • There's a whole entity on thresholds called Orion.Thresholds. Download the SWQL Studio utility from github.com/solarwinds/OrionSDK/releases and have a look: SELECT EntityType, InstanceId, ThresholdType, ThresholdOperator, Name, CurrentValue, Level1Value, Level1Formula, IsLevel1State, Level2Value, Level2Formula,…
  • This should do the trick. SELECT MAX(LastSync) FROM NodesStatistics;
  • This thread has the right idea: http://www.orafaq.com/forum/t/65099/0/
  • You should be able to get this information via JMX and the memory MBEAN. The best way to get at that information is by using the Component Monitor Wizard at the top of the SAM settings page to query your system for available JMX monitoring points and build your template that way. FAQ/Monitoring - Tomcat Wiki -- Steven W.…
  • Try prefixing the Maxbps_In95 with AA?
  • If you can find a connector, you win. If not, you can send a sample to SolarWinds support and they'll generate a new one for you that you can drop in.
  • The joins are probably where you're getting messed up: From Orion.AlertStatus s Join Orion.AlertDefinitions d on s.AlertDefID = d.AlertDefID Join Orion.Volumes c ON s.ObjectName = c.FullName Instead of joining the volumes table on the objectname look for an ID instead. I'm pretty sure the Orion.Volumes table would have…
  • Case E looks good to me. -- Steven "MrXinu" Klassen Hosted Web Help Desk Engineer | Loop1 Systems, Inc.
  • Is this on your personal desktop machine? Unplug it from the network, salvage the files you can, and reinstall Windows. If it's a business system, I'd be more concerned about the machines connected to the one that's behaving oddly. Leaving this machine on your network is a really bad idea. Help us out with more…
  • It looks like you're writing out different values whenever something interesting happens and you're changing the exit code based on a general pass/fail. Is the issue creating the alert definition then? You provided a lot of good information but I'm not seeing where you're having a problem.
  • Sounds like a powershell script that hits a UNC on the network (i.e., \\systemname\path\to\files) and then runs through the logic you're talking about. If you give me more details I can hack something up for you.
    in Files Exist Comment by mrxinu July 2012
  • That looks like an array that's been forced to a string. IMO, time for a ticket with SolarWinds support. -- Steven "MrXinu" Klassen Hosted Web Help Desk Engineer | Loop1 Systems