Lofstrand · Solutions Architect · ✭✭✭✭✭

Hi, I would personally just use something like this: Alert when critical value is reach for receive or transmit errors/discards. Using the global or individual thresholds. But I understand it as you want to use percentage instead of errors/hour. Care to share your SWQL code and I'll have a look?

You have zoom control buttons on the upper right hand side: Also, you can press spacebar and move the picture with the mouse. Just as with maps.

See Where is the LDAP service account set in the SolarWinds Platform? - General - The SolarWinds Platform - THWACK

I just muted a node with a powershell script, logging in as "testuser1". From below example you can see that I first was failing (forgot the password and changed it) and then the script worked. So, unsuccessful logins are logged in the audit log and the mute-operation itself. Successful logins through the API does not seem…

It's a bit picky on having all columns named in the output. In this case you don't have a column name and it complains about that. Try add "AS T" at the end, just before the } So the end is like this: + ' minutes' AS T} 

If you have the maintenance windows in ServiceNow currently, and want them to be reflected into SolarWinds, I guess you need some script that pulls that data from ServiceNow and pushes it into SolarWinds. Perfectly doable but I don't have any examples currently. 

The easiest way is to use "manage nodes", and mark several nodes, click "maintenance mode" and choose a schedule for all of them at once. If you want to automate things, there is also the possibility to create for example a powershell script that assigns nodes to a schedule. Observability just got new possibilities…

Hi @"martian_monster" . If it's a custom PowerShell outside of SolarWinds, then SolarWinds does not have any logs for it. It's up to that powershell script to create a log. Try to run the script manually to see what happens. Or add a couple of logging lines in it to see how far it goes. 

Hi We always suggest using SWQL instead of SQL where possible. But now that you almost have all the query I adjusted this on. Joined in the table "NodeIPAddresses" on both interfaceindex and nodeid. Then if no IP was found bound to that interface I added the nodes IP instead, and added a * to mark it's the nodes IP. SELECT…

Ahh, you bet me to it @"stuartd" . But I had to create it from scratch :-D Here is my suggestion. Looks pretty much the same but I have another approach on the status icon. SELECT M.Container.DisplayName AS [Group] ,CASE WHEN M.Container.Owner='Core' THEN 'Group' WHEN M.Container.Owner='Maps' THEN 'Map' END AS [Type]…

Strange, sounds like it doesn't update the group members status. I think you should be able to see this from this SWQL table: FROM Orion.ContainerMemberSnapshotsEach groupmembers status should be stored there also. Do you have an Additional Web Server? if so, do you see that same thing when you go directly to the main…

Hi there Do you want a "notification" each morning on the maintenance status? In that case you probably want to create a scheduled report instead. If you want an ALERT when MT fails, then it's an alert but we can't look at all values. We just want tonights values. (I can't find Custom SWQL alert against events, so I choose…

Note what the MIB database is used for in this link: https://customerportal.solarwinds.com/info/mib-database I might not be necessary to update the mib database all the time. If you absolutely want the latest version, you can update it on a scheduled basis as a new file is complied once a week.

Ahh, thanks @"tobyw_loop1" , I forgot about that one. Haven't used it much over the years.

No, no documentation on the db schema. But if you download and use the free SWQL studio you can see all the tables and partly their relationship. Having worked with this database for 20 years also helps some....

Here is the same query but I have change it on two places to get the NumericData instead of StringData SELECT --DE.StringData AS [Message] DE.NumericData FROM Orion.APM.DynamicEvidenceCurrent AS DE -- ON CS.ComponentID=DE.ComponentID AND DE.StringData IS NOT NULL INNER JOIN Orion.APM.DynamicEvidenceColumnSchema AS S ON…

Hi @"dustinwoodhousemela" There is always the option to create the variables ourselves. By "Define SQL/SWQL Variable". I have tested below query in my lab, on a component that gets a value called "Expiration". Replace that string with "DisabledAgents" in your example. ${N=SWQL;M=SELECT DE.StringData AS [Message] FROM…

ADM is disabled be default on all SolarWinds servers, as it's not recommended to have it on there: https://documentation.solarwinds.com/en/success_center/sam/content/sam-adm-requirements.htm When it's disabled, the "enable adm" option under edit node is not visible. You can though enable it again by following the…

Great @"ShawD" The powershell script can be almost any code you want. Just remember that the output from the script has to be in a correct format. for example: Write-Host "Statistic.status=$MyValue" Write-Host "Message.status=$MyMessage"

Hi @"ShawD" The first thing you have to do is start monitor the cluster nodes status, after that you can create an alert for that. One way of monitor each cluster nodes status is by creating a powershell script that is ran in a SAM Powershell component. I don't have access to any WFC at the moment so I have no way of…

Hi @"BaldFeegle" First I have to agree with @"chad.every" , alerting on groups is not always such a great idea. Creating "grouping" with Custom Properties is often a better approach. (Though there are scenarios when groups are great!!) Sound like you want to alert on Nodes within a group rather than the group itself. Hence…

Hi I suggest you create a report using the built in reporting tool, with the information you would like. Then you can schedule that report so be sent to you in CSV format. Either by email or stored on a file share. Can that work?

Hi @"HenrikFFM" Does not sound like how it should behave :-) Suggest you open a support ticket about that so they can take a look.

You could dig around in DPA to find out what query is blocking your insert query, then it's that one that needs updating. If nothing if blocking your insert query, then it's the query itself that is slow.

I would check if you have blockings on that insert query stat makes the insert take long time. Can also check "lock wait time". All the indexes you have must be updated on every insert. So having more indexes SLOWS all inserts. They are "only" good for read operations. So having more indexes than you need will slow things…

I did a rewrite of above query without the union parts. All in one Select statement. Should give you about the same info. SELECT N.Caption AS [Node], CASE WHEN N.UnManaged=1 THEN DATETRUNC('minute', ToLocal(N.UnManageFrom)) WHEN ASup.EntityUri IS NOT NULL THEN DATETRUNC('minute', ToLocal(ASup.SuppressFrom)) END AS…

Hi, below gives you a little more than that but use the parts you want. Includes both muted and unmanaged nodes, who made it and when: Code is made for a "custom query widget", but can be used for reports also. Some columns can then be removed. --Unmanaged SELECT N.Caption AS [Node], DATETRUNC('minute', N.UnManageFrom) AS…

Hi Should be doable without any custom SWQL. Here is a report of just two example interfaces. Both graph and table. If that looks ok to you, these are a couple of key settings: Having the "from" value to the wanted timespan. 24h in my case Set the time periods for sample intervall on the graph to "every hour": And on the…

Hi, looks like that is not possible. The best option I was able to find is below with a table widget: SELECT CASE WHEN G.Status=1 THEN 0 -- OK WHEN G.Status=3 THEN 2 -- Warning WHEN G.status=14 THEN 3 -- Crtitical WHEN G.status=2 THEN 4 -- Down ELSE 1 -- Blue END AS GroupStatus ,G.StatusDescription FROM Orion.Groups AS G…

You could also use "Application dependency with connection quality polling": https://documentation.solarwinds.com/en/success_center/sam/content/sam-adm-configure-app-dependencies.htm?cshid=OrionSamADMEnableAppDependencyPolling It will give you latency and packetloss between your application and db. Not timeouts but close.