zackm ✭✭✭✭✭

are you just asking how to create a report that shows application health per node?

I don't have any VRFs in my lab to test real data, but if you make a report with a custom datasource of the SWQL type, this should get you in the right ballpark: SELECT v.Name ,v.RouteDistinguisher ,v.Status ,v.Node.Caption ,v.Interfaces.Description ,v.Interfaces.DistributionProtocol ,v.Interfaces.VrfInterfaceType…

I assume by 'hostname from snmp' you mean the SysName field. If you are referring to the Node Name in SolarWinds that you can edit, then your trigger would be Nodes.Caption <> Nodes.DNS -ZackM http://www.loop1systems.com

I assume you mean the average availability of the individual component monitors? Once you've selected your components (make sure you select, Component, not Application in your data source), you can see the % Availability metric: The same concept applies at the application level, but app availability is a rollup of the…

Assuming that you have NPM 11.5 or later, you should be able to accomplish something like this: 1) Find your AlertID for the CPU Alert you mentioned (You can query the database with this) SELECT AlertID, NameFROM AlertConfigurationsWHERE Enabled = 1ORDER BY AlertID 2) Once you have your AlertID, you can then go to your…

Seems they have a pretty robust SDK available with PowerShell snap-ins: Get-BrokerSession

You need to check the 'Write to NVRAM' option in order to save your changes to the startup-config. This would be the same as a "write mem" command in a traditional IOS script. -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

SELECT Containers_AlertsAndReportsData.GroupName AS Group_Name, Containers_AlertsAndReportsData.GroupStatusDescription AS Group_Status, Containers_AlertsAndReportsData.GroupPercentAvailability AS Group_Availability, Containers_AlertsAndReportsData.GroupMemberName AS Group_Member_Name,…

The easiest way would probably be to setup an alert for server reboots and have that alert write an event to the NetPerfMon event log. Then you should be able to easily get a report on those events. -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems *…

When you say "Group", do you mean an actual Orion Group (Settings > Manage Groups), or do you mean a group of people (Team)? If you mean an Orion Group, you would probably be better off with not alerting on the group itself as you lose a lot of granularity with your variable options in your notifications. Try just creating…

This is a built-in function within Advanced Alert Manager: If this doesn't work, you can create a custom SQL alert as well: Hopefully one of those options will get you where you are wanting to go. Please note that the trigger looks at the NPM_RoutingNeighbor_V view, which is created with this query: (so it's not your…

I just realized that I work from home and STILL need cough drops/hand sanitizer/ibuprofen/kind bar/trail mix/tissues/and my daughter's stuffed elephant... I'm getting old and cluttered

are you saying that you need that specific report limited to only Cisco, or is there something else you need the data to look like? if the former, you should be able to edit that report and then create a filter on the Vendor field if the latter, can you provide a description of the specific columns and data you'd like to…

you might move away from the custom query and make a legacy report using the Report Writer app on your server. SELECT Caption ,NotesFROM NodesWHERE Notes <> '' AND Notes IS NOT NULLORDER BY Caption (If you want to see all devices, including those without notes, remove the "WHERE" line) Unless of course you are needing to…

I would not think this would be an issue with SolarWinds as you have indicated no changes to SolarWinds in this process. The only change has been the SQL server, so I would definitely start there. Top 25 Tables by Size: SELECT TOP 25 t.NAME AS 'Table Name', p.rows AS 'Row Counts', (SUM(a.total_pages) * 8)/1000 AS 'Total…

You need to use the Custom Poller options in your target type: From there, you're going to want to limit your scope based on uniqueName (or maybe OID) and then set your threshold on the current value: Hope that help! -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook:…

It sounds like you have your NCM setup to run all jobs from the primary polling engine. http://www.solarwinds.com/NetPerfMon/SolarWinds/wwhelp/wwhimpl/js/html/wwhelp.htm#href=OrionNCMPHPollerEngineNodeHelp.ht… Settings > NCM Settings > Polling Engine Configuration for NCM If you are load balancing your NCM nodes across…

You could do this as a SQL script, but I would suggest creating an advanced alert using advanced alert manager. (It's basically just a GUI to create SQL queries) Something like this should get you in the right direction:

can you paste your query in here so we can see it?

SWQL Studio is packaged within the SDK. You can get a download here: SolarWinds Knowledge Base :: Downloading the SolarWinds Orion SDK Also, the SDK community is migrating to GitHub, here is a link for samples and such: solarwinds/OrionSDK · GitHub -ZackM Loop1 Systems: SolarWinds Training and Professional Services *…

stuartwhyte is correct; this will be a very expensive report in regards to cycles on your SQL box. In your other question about this (Re: How to display polling Engine as well as Other node information?) you mentioned you wanted PEAK CPU, This will get you the PEAK CPU load from any one polling cycle out of the last 7…

can you give a few more details? - what modules and versions are you migrating? - do you need to retain historical data on your existing nodes?

This should do the trick for you: Scheduling unmanage task for nodes, interfaces and applications Otherwise, you could restrict the nodes OUT of the normal alerts; and then create unique alerts for that specific node that ignore the daily maintenance window. Depending on the number of devices in question, this may be…

You'd need to create a custom SQL alert and join the CPUMultiLoad view to a Node alert like so: QUERY: JOIN CPUMultiLoad on Nodes.NodeID = CPUMultiLoad.NodeID WHERE DATEDIFF(mi, CPUMultiLoad.TimeStampUTC, SYSUTCDATETIME()) < 5 and CPUMultiLoad.AvgLoad >= 80 You might need to play with the reset condition a little to make…

Negative. You just run the installer on top of your existing environment. Here are a few links to help. SolarWinds Knowledge Base :: Compatibility of SolarWinds Orion Products for Installation and Upgrade Network Performance Monitor (NPM) Upgrade Path Orion NPM 7.8.5 ⇒ 8.5.1 ⇒ 9.1 ⇒ 9.5.1 ⇒ 10.1.3 ⇒ 10.3 ⇒ 10.6 Installing,…

This can surely be done with a custom SQL report as well. I'm not hooked into a DB right now to get the exact syntax, but if you can reply with the exact names of your 2 UnDPs, I should be able to get something spun up tomorrow if the table referenced above doesn't work for you. -ZackM Loop1 Systems: SolarWinds Training…

Here's a good breakdown, courtesy of Mr. adatole‌ SNMP vs WMI polling - pros and cons -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

firefox quantum and chrome both looking good here sir. you sure you didn't google/i'm feeling lucky "do a barrel roll" ? (or "google gravity")

You were really close actually: SELECT Node.Caption FROM [dbo].[NodesData] AS Node LEFT JOIN [dbo].[Volumes] AS Vol ON Node.NodeID = Vol.NodeID WHERE Node.Vendor = 'Windows' AND Vol.VolumeTypeID = '4' AND Vol.VolumeDescription NOT LIKE 'C:\%'AND Vol.VolumeDescription NOT LIKE 'D:\%' I think what was throwing you off was…

Top of my head, this would not be easily accomplished. The problem is wanting the acknowledged alerts... The only 2 places (that I know of) that have a marker for acknowledged alerts is the AlertStatus table, and the AuditingEvents table. For the latter, you can use something like this: select timeloggedutc…