christopher.t.jones123 · CRIS Solutions Architect/Engineer · ✭✭✭✭✭

@"mgillespie1981", in addition to writing a query that can find the nodes you can also adjust this value via SWIS so you can write a script to take the output of the "Discovery" query and then set that value appropriately. 

@"mgillespie1981", could probably right an SWQL query to find the Cisco devices that might meet that criteria, something like below should be a good starting point. SELECT TOP 1000 H.NodeID, H.ID, H.HardwareInfoID, HardwareCategoryStatusID, UniqueName, H.Name, H.Message, H.IsDisabled, H.StatusDescription FROM…

@"mgillespie1981", what factor do you key in on for the Hardware Sensors that indicate to you that the MIB needs to be updated?

@"mgillespie1981", yes this value can be modified in bulk, from the manage nodes screen select the nodes you want to change and then select Edit Properties. When you do this you will notice that it looks slightly different than singular edit properties. Scroll down to the Hardware Health Polling section and select the…

@"Chet", the syntax for that widget should be like this Nodes.CustomProperties.CCTV_Network =

@"cashwani333", I'm having a little difficulty understanding the question. Are you asking for guidance on adding alert variables to a trigger action? If so, can you paste screenshots of your trigger condition?

@"tszilagyi", Disable doesn't seem to be an available action via the SAM Service Control Manager, however, utilizing the alert action "Launch External Program" you can have SolarWinds execute a PowerShell script to stop and disable the service.

@"bfranklin1228", to find out exactly what is being executed you can enable session trace logs using this KB article. One thing of note is that I wouldnt recommend leaving it on for a long period of time, it can cause Jobs to take a really long time or not finish. I usually recommend enabling it to get the info you need…

@"Martin_Crothers", I believe Processor Queue Length is found in the "System" performance count sets, one thing you can do because its already defined in a template is copy that component from one template to the other. Here's an article on how to do it. The Template it is currently located is "Exchange Server 2000 and…

@"fgdark", why dont you give the below query a try? Basically because the Acess Points Table has a status we can still do the join so it pulls in a Name for the status, and because we've changed the FROM table it will only bring in AP's. SELECT SI.StatusName AS Status, COUNT(Status) AS Total FROM…

@"mulambo", do you have Log Viewer or Log analyzer installed? if so that info is stored in a Different location, it can be found under Orion.OLM in that section you'll see several sub sections and one of those will have the info you are looking for.

@"jpaluch" and @"kpmarcin", this question is probably going to be asked at some point, do you have instructions on setting up the connection to the DPA repository DB? maybe link those instructions or a quick run-through is beneficial.

@"martian_monster", this can be done at either the Template or the individual application assignment, just edit the properties and disable that component

@"WinterSoldier", can you try the below query and let me know if it outputs correctly? I dont have a cloud instance in my SolarWinds to test with. SELECT AI.Node.CloudInstance.DisplayName AS Nodename ,AI.Node.IPAddress ,AI.Node.CPULoad ,AI.Node.PercentMemoryUsed ,AI.Node.StatusDescription ,AI.Node.DetailsUrl…

@"WinterSoldier", can you repost the latest query you are working with? I dont have any cloud instances so it's hard for me to test but maybe I can work something similar out with a different table or something. 

@"WinterSoldier", try doing a left join instead of a join. This should return even the NULL values that are currently being excluded

@"amirsd" here's a great resource to get started github.com/.../PowerShell

@"hallstev5" there was a THWACK post floating around identifying this as a bug (I can't for the life of me find the post), but on that post, a workaround was presented where you can unmanage/remanage the node it will then in essence "reset" that status and those volumes that no longer exist will no longer contribute to a…

@"damon_2021" so for the info you're asking for you'll probably find it on either or a combination of Orion.UDT.Endpoint, Orion.UDT.AllEndpoints and Orion.UDT.PortsToEndpointHistory. Once you have the queries worked out in SWQL studio it should be fairly straightforward from there how to turn it into an API call. 

@"damon_2021" largely depends on what modules you have. Do you happen to own UDT?

@"shocko" I think the table you'd be interested in Querying is Orion.APM.ApplicationTcpConnection. At a quick glance at the info showed in that table it should have what you need to build out a query like that.

@"shocko" the OLM tables refer to Orion Log Viewer. I don't think that query shows what you are requesting, it's in essence showing Nodes that are configured for Log Viewer instead of the logging level assigned to the agent. I went poking around in the SWQL tables and couldn't find where it stores that setting, I'll keep…

@"shocko", you're probably right in that you'll have to do a custom variable, one of the downfalls with custom variables is that it only returns one value, but this Thwack Article shows how you can get it to return more than one and display kind of like a table. I use it often when writing alerts to display the child…

@"shocko"Something like below should be able to get you started. It basically looks at all nodes where the applicationID is NULL (or doesnt have an app assigned) I already added in a where statement to only look at Windows, but you could add/modify this to fit your needs however you see fit. SELECt n.Caption From…

@stuartd you have most of it you just need to alias out the details url to [_LinkFor_<Column you want it to be a link for>] so something like below would work SELECT FullName AS Node_and_Interface, OperStatus, Alias AS Interface_Name, IfName, InterfaceIndex, DetailsUrl as [_LinkFor_Interface_Name] FROM Orion.NPM.Interfaces…

@"LatteLarry" take a look at this KB article

@"bharris1", and to be honest because they are negative statements you dont need to put them in a group, you can just say and not like ... and not like .. etc AND V.Node.Caption NOT LIKE '%SERVER1%' and V.Node.Caption NOT LIKE '%SERVER2%' and V.Node.Caption NOT LIKE '%SERVER3%'

@"bharris1" you need to include wild cards within the single quotes, so it should look something like V.Node.Caption NOT LIKE '%SERVER1%'

@"klomper218", what version are you running? I found that in versions prior to 2020.2.5 I noticed the same behavior that would also cause deadlocks especially during service restarts. When we upgraded to 2020.2.5 the issue was addressed and resolved.

@"menningj", perhaps these two articles might shed more light if you haven't already seen them Secure Configuration IIS Handler Mapping