zackm ✭✭✭✭✭

Top of my head, I would love to see a way to create easier searches here. I'm thinking something in the way of an option to limit searches to only show threads marked as 'answered'. One of the most frustrating things I find is looking for an answer to an issue and getting a thread from 2009 with no answers. It's not often,…

This is an easy process with the Web Report Writer. Create a new report and select the "Custom Node Poller" as your source (you can also make you limitations here. For instance: WHERE UniqueName STARTS WITH 'ups') Add the selected columns as outlined below Here is a preview of the end result (I chose to GROUP BY…

I would recommend testing this out, but I think this gets you in the right ballpark using a Custom SWQL Alert: SWQL Query with added comments: -- Inner Join the Nodes entity with the Container (Groups) entity, aligning on the NodeID and filtering to only Group Members that are actually nodes JOIN Orion.Container AS Groups…

I like to have a weekly report setup to 'audit' the unmanaged devices in the network. This SQL can be used to create something simple: SELECT CAPTION, IP_ADDRESS, UNMANAGEFROM, UNMANAGEUNTILFROM NODESWHERE UNMANAGED = 1ORDER BY UNMANAGEUNTIL ASC -ZackM Loop1 Systems: SolarWinds Training and Professional Services *…

You're doing this right now: (Node_Group = 'Network Team' ORNode_Group = 'Network Team' ORNode_Group = 'Network Team' OR(Vendor <> 'APC NetBotz'))ANDStatus = Down What you want is this: (Node_Group = 'Network Team' ANDVendor <> 'APC NetBotz')AND Status = Down Simplify your scope and switch that first OR to an AND and you…

I would start with this: Unable to retrieve the PDF, CSV, or URL of scheduled reports - SolarWinds Worldwide, LLC. Help and Support Past that, and it might be a silly one, but you're positive that the report in question only has a custom table resource right? Also, can you run the report in the SolarWinds website directly…

Try this: Avg_Interface_Utilization_-_Last_7_Days.OrionReport Here's the query: select n.nodeid, n.caption as device, i.interfaceid, i.caption as interface, case when tr.avg_in = 0 then 0 when i.inbandwidth = 0 then 'Bandwidth Not Set' else round((tr.avg_in/i.inbandwidth)*100,2) end as avg_in_perc_util, case when…

Try this: SELECT n.Caption, n.IP_Address, i.InterfaceName, i.StatusFROM Nodes nLEFT JOIN Interfaces iON n.nodeID=i.nodeIDWHERE i.AdminStatus = 1ANDi.OperStatus <> 1ORDER BY n.Caption So (line by line) 1) Device Hostname 2) Device IP Address 3) Interface Description 4) Interface Status (2 = DOWN) 5) Pull data from the Nodes…

In the SQL Database: dbo.APM_ExBB_Mailbox.OrganizationalUnit In SWQL it is: Orion.APM.Exchange.Mailbox.OrganizationalUnit In the Web Report Writer, that's going to be found under the "AppInsight for Exchange: Mailbox" object type as such: Hope that helps! -ZackM Loop1 Systems: SolarWinds Training and Professional Services…

You can use the "Custom Table" and "Custom Chart" resources in web views. You cannot just pick a report like you could with the old Report Writer, but you can recreate web reports using these resources fairly easily. -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook:…

Can you post some screenshots of what your are seeing?

Using Advanced Alert Manager, you can select to alert on the 'Custom Node Table Poller' type and then you can add simple conditions to match the criteria you desire. 'Row Status is equal to failed' is probably the key you want... If you are new to the Advanced Alert Manager, I would HIGHLY recommend perusing the following:…

Generally speaking, Interfaces are for NPM monitoring and Ports are for UDT. -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

You could also add emails as a custom property on your nodes and then parse that into your "To:" field on the alert definition. When any node alerts, it will only send a notice to the recipient on the custom property. Like this: Community works! - A simpler way to manage Orion email alerts

You could try changing the scope of the alert to ignore anything with the VMware OUI. (vSphere 6.0 Documentation Center) I haven't been able to test this in production, but it looks good when compared to the DB values in the UDT_MovedMACAlert view. -ZackM Loop1 Systems: SolarWinds Training and Professional Services *…

change this "OR" to an "AND" and it should work. What you want: Average Response Time > 200ms and Node Name Not Like '%1920%' and Node Name Not Like '%819%' What you have right now: ( Average Response Time > 200ms and Node Name Not Like '%1920%' ) OR ( Average Response Time > 200ms and Node Name Not Like '%819%' ) It's a…

Here you go: SELECT d.IPAddress AS "DISCOVERED IP ADDRESS", d.SysName AS "DISCOVERED DEVICE"FROM DiscoveredNodes dJOIN Nodes n ON d.IPAddress=n.IP_AddressWHERE n.IP_Address is NULLAND d.IgnoredNodeID IS NULL You can use that to make a Custom SQL report in either the legacy Report Writer or the new Web-based. Basic…

what is the name of the application monitor template you are using?

Congrats Sir! (now slow down, I've been chasing you for a couple of months!)

SELECT TOP 100 * FROM APM_HardwareItem i JOIN APM_HardwareCategoryStatus c ON c.ID = i.HardwareCategoryStatusID JOIN APM_HardwareItemValueStatistics v ON v.HardwareItemID = i.ID AND v.HardwareCategoryStatusID = c.ID WHERE c.HardwareCategoryID = 4 --This is the Temperature Category (found in dbo.APM_HardwareCategory)

On your SolarWinds website, Settings > Manage Advanced Alerts Click on the Alert in Question Expand the "Read Only Attributes" section Copy everything there and paste in here. I think you have an "AND/OR" mixup in your selection there. The SQL under your read only attributes will confirm.

This is actually a really interesting idea. I *think* the trick would be with IVIM for you. Add your vCenters and Hosts into your virtualization monitoring with NPM. Then you should be able to get some cool SQL alerts based on the current architecture of VM to Host at all times. This is by no means exact, but the basic…

Try this: ${SQL:selectcase when ${SensorUnit} = 'degrees celsius'then (${SensorValue} *(9/5)+32)else 0 endfrom apm_hardwaresensoralertdatawhere hardwaresensorid = ___________} You'll have to find the last variable that goes in the '__________' (I don't have a demo site in front of me at the moment, sorry) The trick is that…

Jsut to show you how some of this joins together in SWQL: SELECT a.NodeID ,a.Node.Caption AS [Node_Name] ,a.ApplicationID ,a.Name AS [Application_Name] ,a.Components.ComponentID ,a.Components.Name AS [Component_Name] FROM Orion.APM.Application a WHERE a.CustomApplicationType = 'ABSA' ORDER BY [Node_Name],…

You can fix this in SQL. What exactly are the messages in the transfer screen? (highlighted below) Here are the scripts you run in the database (IN ORDER): Replacing 'Transferring' with whatever status you are trying to get rid of (from the picture above) To confirm the entries in the database match what you are seeing on…

The SQL view: dbo.AlertHistoryView would be a good start SELECT * FROM dbo.AlertHistoryView WHERE Severity = 0

I have worked with a large amount of LEM clients over the past 18 months. During that time, I have not had a single client need (or want) anything from WFP events. For me, I absolutely LOVE the new setup where we have to turn ON rules with a new installtion (instead of turning OFF things that were not neded). Given that…

can you give a precise example of what you are trying to accomplish? what "monitor-specific events" are you referring to?

It would probably be easiest to edit your existing report to limit the results to only include Fibre Channel interfaces. http://www.iana.org/assignments/ianaiftype-mib/ianaiftype-mib This is a list of all of the current "ifType" values. Fibre Channel is 56. -ZackM Loop1 Systems: SolarWinds Training and Professional…

are you looking specifically for resources that can only be applied to nodes? select resourceid, resourcename, resourcefile from resources where resourcefile like '%node%' order by resourcefile that's probably a good starting point