zackm ✭✭✭✭✭

Sure thing, just remove the summary month from the results. This will give you a single average availability metric per node for the last month during business hours. DECLARE @startOfMonth DATETIME = DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0) SELECT n.NodeID ,n.VendorIcon Vendor_Icon ,n.Caption NodeName ,n.IP_Address…

The problem is that you have a differently named custom property... try this, it should limit the results to only your team based on "CP_ResponsibleTeam = OPS-Windows" (line 10) SELECT ac.Name 'Alert Name' ,ao.EntityCaption 'Alert Object' ,ac.ObjectType 'Object Type'…

I have tested this in both the web reporter and the legacy report writer with no issues on either one... Legacy Report Writer: The only thing I could see your error occurring with would be a lack of any real data. If you run this query against your database, do you return results? SELECTNodes.NodeID, Nodes.Caption,…

Yeah, the overlap can get confusing, but that resource you screenshot earlier is 100% from VNQM. NPM and SAM can gather these metrics through SNMP, but are definitely not doing so natively.

I have seen hundreds of custom properties before. The way they are added to the database, I'm not really sure there is a maximum number. That being said, make sure that your NCM and NPM databases have been synchronized after making the custom property. Settings > NCM Settings > Sync Nodes -ZackM Loop1 Systems: SolarWinds…

Node - Interface If the Interface goes down, a trap is sent. Then the Node goes down, the interface status is rolled under the node as it is inherently dependent. When the Node comes back online (with the interfaces up), it triggers a reset on the Node alert only as the interface status were dependent on the node. (that is…

One of the limitations you're going to have using SQL Express 2014 is a 10GB limit on your relational database size. You are showing a 8.15 GB database, and NCM is looking for 3.14 GB of free space. That's beyond the capabilities of your SQL product. One thing you could do is the "Minimum" data transfer option. Before you…

Surely! Depending on your installed Modules/Versions, you should be either able to use the older Report Scheduler (Start around 28:20) thick client on your server, or the newer web-based Report Scheduler. By the way, LOVE your golf course!!!

did you try to rename the components? those look like the default names for Windows Service monitors. If you edit the application (or, preferably the application template), you can rename each component to something more "friendly". -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1…

Roger that. Thanks for the clarification. So what you are asking for is more like this: Show me all the nodes that have either C or D, but not both C and D. So, to get there, what we want to do is create our own table (in memory) that has rows of nodes, and columns showing NodeID, C_Volume, and D_Volume. Then we are going…

This is from NPM 10.6; NCM would be a different monster.

Make sure that the target nodes are native the the originating engine. For example: * Polling Engine A has Router1 * Polling Engine B has Firewall3 Any script(s) that run against Router1 MUST be run from Polling Engine A. Likewise, script(s) for Firewall3 MUST be run from Polling Engine B. You can easily edit polling…

Is this what you are looking for? Here's the back-end SQL: SELECT IPAM_GroupReportView.FriendlyName AS Display_Name, IPAM_GroupReportView.Address AS Network_Address, IPAM_GroupReportView.AddressN AS Address_Sort_Key, IPAM_GroupReportView.CIDR AS CIDR, IPAM_GroupReportView.LastDiscovery AS Last_Discovery,…

This should get you in the right ballpark as far as the tables go: SELECT c.componentID ,c.Component.Application.Name AS [applicationName] ,c.Component.Name AS [componentName] ,AVG(c.PercentAvailability) AS [slaAvailability] ,DATETRUNC('day',TOLOCAL(c.TimeStamp)) AS [slaDay] FROM Orion.APM.ComponentStatus c WHERE…

That means that you don't have a nodeid in your data to apply to a details view option for the devices. When you're editing your table, just remove the detail summary view (I think that's what they call it) option from the caption column. Alternatively, there was a thread a while back where someone found a little work…

x2 on the LDF file, that is excessive from what I am used to seeing. Even though it wouldn't technically be supported by SWI, I generally like to put my DBs into FULL recovery and create a more robust backup schema that would allow for a better recovery timeframe if there were problems. Another benefit of this model is…

you could put something like this at the top: USE SolarWindsDatabase But no, I did not specify it distinctly. Generally I always have the correct DB selected in SSMS before running queries so I just don't normally add that line (even though I should) Nice catch.

That could just be a bug in the way that simulations are run. Custom Pollers have always been a little weird when testing alerts. I would try to change the trigger condition a little bit to fire a 'false positive' alert and make sure the logic is sound. Once you have a good test, just move the trigger threshold back to…

Here you go: SELECT TOP 10 c.Name AS [Container_Name] ,n.Caption AS [Member_Name] ,n.CustomProperties.OS_Environment ,SUM( n.ResponseTimeHistory.Availability * n.ResponseTimeHistory.Weight) / SUM( n.ResponseTimeHistory.Weight ) AS [Weighted_Availability] FROM Orion.Nodes n JOIN Orion.Container c ON…

Sorry about that. I misunderstood the question. Try this out (designed for the Custom Query Resource using SWQL) SELECT n.Caption as [DEVICE] ,nw.WebUri as [_LinkFor_DEVICE] ,i.Caption as [INTERFACE] ,iw.WebUri as [_LinkFor_INTERFACE] ,i.TypeDescription ,CASE WHEN p.PortType = '1' THEN 'Access' WHEN p.PortType = '2' THEN…

That path should definitely work for you. If you need to review it, you can use the compatibility matrix: SolarWinds Knowledge Base :: Compatibility of SolarWinds Orion Products for Installation and Upgrade Here are some good documents for you to review. If you have further questions, please feel free to ask!…

There's not a guide that I know of. There are a lot of resources in the Admin guide about advanced alerting including variables and creating custom SQL variables. The issue, as I remember it, is that the SQL variable will only return a single string, so you would have to play with the syntax to get all of your CPU loads in…

That's the 2nd query. The alertlog table is definitely the place to go. But getting those 'Alert Triggered' entries to correlate to acknowledged alerts is the tricky part.

For me, I would either search the NPM Content Exchange, or do some Googling to see if I could find an associated OID that would help. You can also start by using the SNMPWalk.exe utility in the SolarWinds install directory to see what OIDs are responding on your devices so you can narrow down your search. It sounds like…

That looks solid from this end I like the outside-the-box thinking on that by the way!

You nailed it. SWQL with both Times SELECTInterfaceID,DateTime AS [DateTime_UTC],ToLocal(DateTime) AS [DateTime_Local],InAveragebps,OutAveragebpsFROM Orion.NPM.InterfaceTrafficWHERE InterfaceID = 4469ORDER BY DateTime DESC SQL with both Times SELECTInterfaceID,DateTime 'DateTime_Local',DATEADD(second, DATEDIFF(second,…

Couple of Options: You can run a SQL report on your Alerts and then audit them (requires SQL knowledge to interpret the results) SELECT AlertName ,AlertDescription ,ObjectType ,TriggerQuery ,CASE WHEN ResetQueryDesign = 'Simple' THEN 'RESET WHEN TRIGGER CONDITIONS NO LONGER EXIST' WHEN ResetQuery = '' THEN 'NO RESET FOR…

I don't have a Nexus to test this against so I can't get a good test in the database. Try this in the database to see if you're getting any results: SELECT n.CAPTION,cp.UNIQUENAME,cps.STATUSFROM nodes nINNER JOIN custompollerassignment cpaON n.nodeid = cpa.nodeidINNER JOIN custompollers cpON cpa.custompollerid =…

10.6 has some really nice feature enhancements! That being said, if you just need to get this report ASAP, post your report files here and I would be happy to look at them and try and make you a single report like you are wanting. C:\Program Files (x86)\SolarWinds\Orion\Reports is the default directory for your files. Just…