zackm ✭✭✭✭✭

Here is a quick SQL Report you can use to identify your missing devices from the L2 and L3 topology tables: (this may need to be validated, I haven't had a chance to check the data) SELECT 'MISSING L2' AS 'ISSUE' ,Caption ,IP_AddressFROM NodesLEFT JOIN NodeL2Connections ON Nodes.NodeID = NodeL2Connections.NodeIDWHERE…

That looks like the account you're using for SQL access doesn't have the proper permissions for those specific databases. Generally speaking, anything in Orion with a status of "Unknown" is caused by either an object that doesn't exist anymore, or credentials failing against an object. -ZackM Loop1 Systems: SolarWinds…

Try to Enable Session Tracing and see what the connection logs tell you when you try to download a configuration. Setting up Session Tracing in NCM to debug device interaction issues Also, what type of switches are you adding?

It sounds like your conditional logic is breaking your alerts, but without actually seeing the trigger conditions I wouldn't know that for sure. Generally, we try to leverage custom properties and baselines as much as possible in our alerting schema. To give you perspective, I have worked with >500 clients in the past 3.5…

You should be able to create local groups on the server and then link to those groups within the web console. From the Admin Guide (p228): "complete the following steps: - Provide the User Name and Password for a user that has administrative access to your Active Directory or local domain. - In the Search for Account area,…

This should take care of your request. You'll want to use this in a Custom Query Resource, and those can be added in web reports as well if you want to export the results. Query (in SWQL): SELECT AccountID AS [NAME] ,CASE WHEN AccountType = 0 THEN 'Orion Service Account' WHEN AccountType = 1 THEN 'Local Orion' WHEN…

Need help identifying Database Table location for hardware field Check this thread out, not sure you can count on that as a variable per say, but a custom property would definitely work. -ZackM http://www.loop1systems.com

your screenshot is from the Node Details page, but your SQL query is looking at the Application Availability. If you want the Node availability, look for the "ResponseTime" tables and/or views.

You are definitely correct with the limitations of AppInsight for SQL supporting only 2008+. However, the trick with understanding AppInsight is to realize that it is really just a fancy Application Monitor Template (that can't be edited). Before AppInsight, we had regular templates. Last I looked, all of these are still…

You're gonna need to use SAM to collect those metrics with SolarWinds. I'm pretty sure they're not natively gathered via AssetInventory. If you only need a point-in-time report, you could also just run a script remotely against a list of your target devices (using PowerShell outside of SolarWinds)…

Since you have the 'NodesOLD' table, I am going to assume that you are on NPM 11.5. If that's the case, you could make this easier with the web report writer GUI by selecting all interfaces with Status = Down The trick is to know that interfaces are inherently dependent on their parent nodes. Meaning that if a node goes…

Here is a good video to get you started on using web based alerting if you are on SAM 6.2 - SolarWinds Lab #24: NPM 11.5 - Web-Based Alerting How-to plus Wireless Heat Maps, Duplex Mismatch Detection and More! - … For earlier versions - Orion NPM Alerts and Events - SolarWinds Certified Professional - YouTube (it says NPM,…

Check out Page 228 http://www.solarwinds.com/documentation/LEM/Docs/LEMUserGuide.pdf And for a better explanation check out nicole pauls response in this thread: Managing multiple LEM appliances -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems *…

If you peruse through the 'Pollers' section of the KB, most of your answers should be in there. http://knowledgebase.solarwinds.com/kb/categories/Network+Performance+Monitor+%28NPM%29/Polling+%28NPM%29/ -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems *…

you nailed it on the edit re: the retention period. storage space definitely. I generally push mine to 31 days just so I can always run a "Last Month" report on the 1st. I have definitely seen it longer (up to 90 or more days) but your SQL server is going to take a hit when you ask it to do more work, so there's an obvious…

NODES_Currently_Down_with_Duration_.OrionReport

Are you looking for a report that takes the 30-day average availability from 2 interfaces and then subtracts InterfaceB from InterfaceA? Or are you wanting to see the individual data points for the last month then run some math against them? The first option would not be too hard, but will really only return something like…

What OID are you using and what settings for your UnDP?

To update the Captions, try this: ***BACKUP YOUR DATABASE FIRST*** In Notepad++ (Somewhat quicker than Excel in my opinion, but you can use whatever you want to get to the end result) 1) Copy Captions and IP Addresses from Excel into Notepad++ 2) CNTRL+H (Find/Replace) 3) Find ^, Replace with (using Regex) UPDATE Nodes SET…

Adding my response to your DM here, so others can find the answer as well. My first thought would be to look at creating a group and then alerting when X objects are down. You most likely need to do this with a swql alert. So you'd setup a custom swql alert for group objects, then add something similar to this in the lower…

I would be willing to bet a few thwack points that somewhere along the line the default view for your nodes has been changed... Settings > Views by Device Type There could also be a problem in your Account settings Settings > Manage Accounts -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN:…

I don't have a live IPAM in front of me right now, but give this a shot to see if it is what you're looking for: SQL: SELECT t.GroupType, g.FriendlyName, g.Address, g.AddressMask, g.CIDR, g.CommentsFROM IPAM_Group gJOIN IPAM_GroupType t ON t.GroupTypeID = g.GroupTypeORDER BY g.FriendlyName Try that out, if you need…

SELECT Caption, IP_Address, COUNT(*) AS Node_Events FROM [Solarwinds].[dbo].[Events] INNER JOIN dbo.Nodes ON (dbo.Events.NetworkNode = dbo.Nodes.NodeID) WHERE EventType = 5000 and Message like '%utilization%' and EventTime > (GetDate ()-7) GROUP BY Caption, IP_Address ORDER BY Node_Events DESC -ZackM Loop1 Systems:…

IIRC, the .msi was intended to only be run in silent mode and you can add options to the cmd line to enable/disable specific items from the tools tab. The intent would be for a standard deployment across all machines. I would either A) create multiple package 'templates' with different options enabled and then push those…

You won't get much more out of adding in the nodes/interface tables. AlertLog.ObjectName takes care of that for you. for reference, this shows all active alerts and joins multiple tables to end up with about the same results: SELECT AL.LOGDATETIME AS 'TIMESTAMP', AD.ALERTNAME, AL.OBJECTTYPE, N.CAPTION AS 'NODE', 'NULL' AS…

This is a few years old, but still very accurate and a great way to familiarize yourself with the report engine: New Orion Reporting: Deep Dive - YouTube Additionally, there are several classes available both on-demand and live sitting in your Customer Portal: Virtual Classrooms | SolarWinds Customer Portal

the issue you're running into is a lack of events because they dropped out of your DB. default event table retention is only 30 days by default. if you want to change this setting, you can; but it can cause some negative consequences re: your platform health because of the sheer amount of events that are generally created.…

Trigger Condition ...Trigger Alert when all the following Apply Interface Status is equal to Down I can add a condition to only alert on SAN or Storage devices by using the the contains variable for example field Node Name contains SAN You are so close! Here you go: Trigger Alert when ALL of the following apply: Interface…

If you go past your detail statistics retention period (default 7 days) you won't be able to get this data as it is averaged to the hour. Can you post your report file here? C:\Program Files (x86)\SolarWinds\Orion\Reports

Greetings! First - please note that this is not the official SolarWinds support site, this is the user community. While you can most likely find the answers to most of your questions here, if you need to open a ticket with the Vendor, I would recommend visiting this page: http://www.solarwinds.com/support/ticket/ Second -…