Lofstrand · Solutions Architect · ✭✭✭✭✭

Sorry, I don't think that is possible.

Hi @"Poirot" I think it works like this: As SolarWinds Observability self hosted is installed on a Windows server that is a member of the AD, and we use .net code, it's using the computers account to read the domain. For example in DPA that is a java-application, it has to have a domain account to be able to read the…

This is as far as I got on this one. Don't give you the month name but the number of the month, and year. SELECT SA.Node.Caption AS [Server] ,SA.Node.DetailsUrl as [_linkfor_Server] ,SA.InstanceName AS [SQL Instance] ,SA.Databases.DisplayName AS [Database] ,SA.Databases.StatusDescription AS [Status] ,B.Availability AS [AVG…

What you can try is a bit like the third option there. But, you ADD your own record there and put it as primary. So, add one extra line with your HA details and set that as primary. I have done that a couple of times for other reasons.

Hi @"wobobobo" And you have followed the instructions on this page? Configure website URL for Alerts and Reports in Orion

Thanks @"zachary.lemoine" I have added that to our internal bug tracking. @"mkarak" , FYI

Ok, understand. Try this out: The first part is just the foundation, a SWQL that tries to display all interfaces where the percentage of issues is over 5% (just took a number, change as you wish). Also, I summarized the values from last hour, to get an average and not alert right away. Adjust if you want. SELECT I.Uri --…

Perfect!

Huh, ok. A space there as well solved it. Strange. I see there is a space before SELECT also... Great you solved it!! There have been some tightening up on the SQL variable parts, for security reasons, in later versions. Probably something there.

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…