zackm ✭✭✭✭✭

All of the current examples are in the Orion SDK Github: OrionSDK/Groups.ps1 at master · solarwinds/OrionSDK · GitHub There are multiple different examples in that script, including creating subgroups. None of this would be dependent on the DB Schema, so it is scalable.

If you have changed your event retention to 90 days, then you just need to wait. There is nothing in this query that is limiting the time, so it will return all results available in the table. Just a note, changing the retention to 90 days does not immediately give you 90 days of events. It gives you 90 days of capacity…

without testing, the first thought that comes to mind would be a group details view, but I don't know if the resources you want would be available there.

You need to set the scope of the reset condition to match the scope of the trigger condition. If this is for a single component monitor, then you can name that outright. As it is now, you have this: Trigger when any component has a statistic > XX (I assume 30?) Reset when any component has a statistic <30 or >=60 It should…

That's actually the default value for all alerts. The evaluation frequency is how often the trigger and reset conditions are evaluated against the database, so if the trigger and/or reset conditions are not matched, there should be no action no matter how often it is evaluated. My gut feeling is that the alert is resetting…

SWQL runs directly against SWIS (from my understanding, not a programmer ) so I would assume that the 'nolock' usage is a moot point. Apples to oranges and all that. But this is a really interesting question. SQL has some definite benefits over SWQL with reporting based on a lack of certain functions in the SWQL syntax.…

You're confusing the Volume Name with the Volume Type. They are different columns in the database.Volume Type is an enumeration from the hrStorageType OID defined in RFC 2790 and has some distinct options for values (RFC 2790 - Host Resources MIB)) It should end up looking similar to this:

I had thought of that, but still end up with the 431 devices listed and only 10 nodes in the Scheduled Discovery Results list on the Web. SELECT Name, PrimaryAddress, Timestamp, IgnoredNodeID, d.NodeIDFROM DiscoveryNodes d (nolock)WHERE d.NodeID NOT IN ( SELECT n.NodeID from Nodes n)ANDTimestamp >…

Why on earth would anyone want a breakfast burrito WITHOUT green chile?!?!?! What is this anarchy?

That sounds like a good idea for a Network Configuration Manager Feature Requests This should work for you, but it's not the prettiest thing in the world. SQL (Run from the NCM Database) SELECT n.NODECAPTION AS "DEVICE NAME",DOWNLOADTIME AS "DOWNLOADED ON",c.CONFIGTYPE AS "CONFIG TYPE",c.CONFIG AS "CONFIG"from NODES njoin…

that's probably it then! thanks for the 2nd set of eyes sir. I'll update after testing next week. have a great weekend! UPDATE: Tested and confirmed. Typos are the bane.

I thought about that as well, but separating the string will remove the functionality that I am wanting. End result should be that I create the device template and assign it to specific devices, create a custom config type on the website called 'CUE', and then I should be able to download the CUE configs at will through…

Try this. The limitation with the alert is that you can only return the columns identified in the top-level query. If you need other details, you need to pull thos into your alert notification using variables and/or SQL Qeury-variables in the body of the message. SELECT VoipCallDetailsAlert.ID, VoipCallDetailsAlert.Name…

ok, now that I am in front of a DB, here is the final query for you (thanks to Steven Klassen for the assist with the join) SELECT Nodes.NodeCaption AS 'Node', ConfigArchive.ConfigTitle AS 'Config'FROM [ConfigMgmt].[dbo].[Nodes]JOIN [ConfigMgmt].[dbo].[ConfigArchive] ON '{' + CAST (Nodes.NodeID AS VarChar (100)) + '}' =…

Thanks tdanner​. Do you know if a variable such as ${ViewID} would work in a situation like this as well?

1) You can absolutely setup alerts for groups. The limitation is that getting details on the exact member of the group with problems in an email message is not easy. Generally, group alerts are best used for a high-level alert for a recipient that doesn't need a lot of details. ("Something is wrong with XYZ") and node (or…

No scripting required! [VIDEO] NPM Core Training Part 4: Custom Properties and Account Limitations Once you have your custom properties created, they will be natively accessible in the web report GUI.

to add to this; you may need an additional poller beforehand depending on your server and polling specifications. Check the "Learn More" link next to your polling rates for some more details.…

Coming off of Marc's point, It looks like the problem is that you are saying this: (Interface Names) OR (Time Limitations) When you should be saying this: (Interface Names) AND (Time Limitations) What happens if you change the WHERE condition to this? AND ((Interfaces.Caption LIKE '%BTEE%') OR (Interfaces.Caption LIKE…

I think you're not getting a lot of responses because you're on the right track already. UCS monitoring is really straight-forward and set around PSUs, fans, up/down on blades and a little more with SNMP. All of this would be fairly simple to setup through the Advanced Alert Manager, just like you did with your first…

Cursory search on google: https://goo.gl/hd0uHd I would start there, even though those errors are 1-6+ years old, it is the #1 search result for that event ID. tl;dr - WMI queries against the Win32_Product class can cause these errors... Outside of that, I would see what types of events are showing up under the System and…

I would hesitate to recommend using the alert suppression tab, it has been known to cause a lot of errors in alerting. It's even mentioned as such in SW documentation: Understanding Orion Advanced Alerts (beginning on Page 8) Looking again at the dbo.AlertDefinitions table we see the suppression field is now populated with…

OK, that's bookmarked. Nice tip

"it depends" If you want to keep it inside of the Orion framework; then yes you could set this up as a reaction to an alert as you mentioned. However, I personally like to setup my scripts on an external (non-Orion) tools server and then use Windows Scheduled Tasks to query SWIS on a regular interval and provide action as…

Latest from SWI: Update for Case #589895 - "NTA Resources on NOC View" Hi I will contact developers ,internal ticket will be open for them . This ticket will be archived and patch should be produced in upcoming versions of NTA but for now please try not use NTA resources with NOC view. You'll get notification in web…

Alright, so the following has been tested in 2 separate environments; this should work for you To begin, I wanted to make sure that filtering events to ONLY Application Up/Application Down -types was working, so I created a datasource as so: To get this working, I used the default "Event Type" field from the root of the…

SAM Licenses by Group and Node Enjoy -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

faizan_123​ ^^^ this is the proper path to take if you want to use the native alerting engine in Orion. Otherwise, to use the Syslog Viewer alerting; see this guide: Configure Syslog Viewer rules - SolarWinds Worldwide, LLC. Help and Support

So, let me put this another way then: Is it possible to get decimal-point precision on a HOURSDIFF ?