mrxinu

Comments

  • Ah, very smart - rather than fighting the email format and grep'ing for the strings you need to do the work you force the creator of the email alert action to add some easily-identifiable markers. That's more than reasonable and saves you/us a lot of heartache.
  • Man, very slick. The only thing that I feel a twinge about when I read it is SQL injection, but that's probably asking a bit much from VBscript. Nice job!
  • Nicely done! You're turning into a SQL beast my friend.
  • I don't believe there's any way to trim that out. There are events that are going to be naturally interesting to NPM and those are going to wind up in the logs (e.g., node/interface/volume/app/component status changes). The "Write Entry to NetPerfMon Event Log" alert action is meant to augment that with things that only…
  • If you're alerting on the roll-up status of the monitor as opposed to the individual components that's the level of specificity you're stuck with. If you need per-component status you need to create a component alert.
  • Have you looked at the 'Message' variable for the Alert:Component alert type?
  • Run the template hourly and exit at the top of the script unless (Get-Date).Hour is the hour you want it to happen.
  • I understand the essence of the question, but NPM can only know if an interface on a system is down by asking the system via SNMP. Do you mean the NIC on the server or the server's access to the rest of the network? You could suppress a node down alert, say, if its access switch were also down.
  • Sure - it's no different than any other admin-enabled user in the system. Make sure you have another admin user first though. =)
  • This is a great candidate for the 'Custom SQL Alert' option under 'Type of Property to Monitor'. Change the dropdown and then in the bottom area, type: WHERE GETDATE() > DATEADD(dd, -45, Nodes.MaintenanceEndDate) If MaintenanceEndDate is 11/16/2012 (-45 from 12/31/2012) and today is 11/17/2012, then GETDATE() > DATEADD(dd,…
  • You can use the API to create nodes. Have you had a chance to look at the examples? OrionSDK/CRUD.AddNode.ps1 at master · solarwinds/OrionSDK · GitHub
  • Sure, with some DB savvy and a couple hours: * Write a TSQL query scheduled every X minutes to calculate the difference between a) the utilization of the interface Y minutes ago, and b) insert that delta into an interface custom property (e.g., Interface_Traffic_Delta). * Create an alert that uses that custom property to…
  • Hey there, So you're right to be a little lost with this one - there's no direct connection between IPAM and NPM that I've been able to find. The query you have looks good but that only considers the IP address that's being used to monitor the device and not all the IP addresses on the node. Since each interface can have…
  • NCM encrypts the credentials and so it knows how to decrypt them before they're used. There is a way to decrypt them if you need to using the API but I hesitate to put something like that here because I'm not entirely sure why SolarWinds decided to make this method available. Shoot me an email at…
  • There aren't any limitations that I'm aware of, but do you really want to point that much syslog at NPM? Unless you're keeping a low number of days your database is going to fall on its head. NPM isn't designed to be a syslog server; it's just something it'll do in order to catch issues and alert on them. Maybe running…
  • SAM doesn't have a grouping concept beyond applying the same template to multiple nodes so I'm going to guess at a few different things that you could mean. If I get warm, let me know. The All Applications Resource - click the Edit button in the corner to organize how your applications are displayed (default: application…
  • The date functions can be found on SolarWinds wiki for the OrionSDK here: SWQL Functions · solarwinds/OrionSDK Wiki · GitHub An example for interface traffic over the last 60 minutes would be this: SELECT n.Caption, i.Caption, it.[DateTime], it.AveragebpsFROM Orion.Nodes nJOIN Orion.NPM.Interfaces i ON n.NodeID =…
  • Syslog and traps serve separate functions, but will often have similar information. Neither are solicited - the device sends them when it thinks it's appropriate, but the traps are event-based. Syslog messages may come in for authentication attempts, configuration changes, hits on ACLs and things like that; traps would…
  • Do you mean to delete them from monitoring or to omit them in a resource like Top 10 Volumes by Disk Space? If it's the latter, has the right idea. If it's the former, you'll need to flex the SolarWinds API or hit the database directly. Let us know what you were thinking.
  • Have you seen this utility? Product Upgrade Advisor | SolarWinds Customer Portal
  • Hey Q, As they mentioned, there are a handful of service providers. I'm the senior engineer for Sigma Solutions' team and, as far as I know, Sigma is the only Certified Solutions Provider for SolarWinds. The sales executive for the practice is Mikael Balderach (mbalderach@sigmasol.com). He can be reached via email as…
  • Also make sure you check out this guide in the documentation. It talks about exit values, named statistics/messages (for that 10 count I talked about), and other tidbits. http://www.solarwinds.com/documentation/apm/docs/Configuring_and_Integrating_PowerShell.pdf
  • When you're converting a script like this to a SAM PoSH component you have the following available to you: up to 10 named statistics (integers), up to 10 messages (strings, usually paired with the statistic), and an exit status (0 = up, 1 = down, 2 = warning, and 3 = critical). Since you're checking for moved databases, I…
  • Hey there, mentioned you had some PoSH and SAM integration questions. I'll have a look at what you've got there and make some suggestions later this evening.
  • Just a thought here, but: * Trigger Condition (LastReboot has changed) * Trigger Action (call a vbscript or external application to update the 'Recently_Rebooted' yes/no custom property to 'Yes' for that node). * Reset Condition ('Recently_Rebooted' is equal to 'No') Have your tech flip the 'Recently_Rebooted' custom…
  • Hi aftab​! The example that's out on the GitHub for SolarWinds leverages the REST API instead of the SOAP interface that would require a WSDL. There's no SwisClient class beyond showing you an example of creating a JSON request and submitting it to the service URL using the stock jersey web client Java libraries. Check out…
  • There's a Python API already out there in the OrionSDK github account. Check it out! OrionSDK/Samples/Python at master · solarwinds/OrionSDK · GitHub -- Steven Klassen Developer Analyst @ Loop1 Systems, Inc. http://www.loop1systems.com/
  • If you hover over the Next button while you're on that page what link shows up in the status bar at the bottom of your browser? Is it a different domain (www vs. no www) than the one in the address bar? -- Steven W. Klassen Programmer Analyst @ Loop1 Systems http://www.loop1systems.com/ http://www.linkedin.com/in/mrxinu
  • Which examples did you read?