jm_sysadmin · Sr System Engineer · ✭✭✭✭✭

Ok this one is better, 2 filters for the installed SQL list above that you likely want to tweak, one filter for SAM applications named like SQL, one for components named like SQL. Tailor it to fit your needs. SELECT DISTINCT N.NodeID, N.Caption FROM Orion.Nodes N INNER JOIN Orion.AssetInventory.Software OAIS ON N.NodeID =…

I reread your post, I think I get it better now. Let me think a minute.

Use use the SWQL below to find servers installed with the SQL database engine SELECT DISTINCT N.NodeID FROM Orion.Nodes N INNER JOIN Orion.AssetInventory.Software OAIS ON N.NodeID = OAIS.NodeID Where n.IsServer = TRUE and OAIS.Name like 'Microsoft SQL Server 2%' and OAIS.Name not like '%Common%' and OAIS.Name not like…

There are directions on how to export them over there, its just a powershell script, and that will make it much easier/ 

So @shuth reviewed the SQL UEM pretty well, but I guess I am not sure why this data needs to be in Orion. I do have data that might be useful to Orion users in other systems, and at that point I make a link out to it. (Things like the CMDB and its reports, our packet capture and analysis tool, things in vCenter, etc.) If…

What widget would you like to show the data in? And I assume you want % used, is that both transmit and receive? More details will help us guide you. 

Why don't you give us some more details. What do you want to see in the report? The numbers of columns and rows isn't enough to let me help. 

By default that it triggered by the number of events it gets for that ID. On the application page, hit "Edit the application monitor" find the Account failed to logon event component, and then alter the Statistic threshold by overriding the template. You can either remove the number to have it never go to warning or…

And I think most hex color codes are able to be used as well instead of color names. 

Sure you would use the API to get the information from Orion. https://thwack.solarwinds.com/product-forums/the-orion-platform/f/orion-sdk GitHub - solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in PowerShell, C#, Go, Perl, and Java. Swagger UI (solarwinds.github.io)

If you haven't already go get GitHub - solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in PowerShell, C#, Go, Perl, and Java. It installs SWQL studio which is very useful when writing these queries. Next, when you look at a node, how to you tell which vlan its in? I…

Here is an example of how I added colors to a Windows OS pie chart. First I added a case statement to my SWQL for the colors I wanted. Case When ServerList.OS like 'Windows 2008 Server' Then 'Red' When ServerList.OS like 'Windows 2008 R2 Server' Then 'Red' When ServerList.OS like 'Windows 2012 Server' Then 'Red' When…

Yes, that should work, if you have issues, show us the whole thing and we can work it out.

You only need ports open to the polling engine, where ever that is for you. SolarWinds Platform agent requirements 

This is what I use: SELECT Count (Distinct N.Caption) as [Backups] FROM NCM.NodeProperties as NP JOIN Orion.Nodes N ON N.NodeID = NP.CoreNodeID LEFT JOIN NCM.ConfigArchive CT ON NP.NodeID = CT.NodeID Where CT.NodeID IS Not NULL

Do you have access to the free training in the customer portal? I would start there

what information are you trying to pull, and how are you trying to pull it? Can you provide more details? Otherwise it might be here: Home · solarwinds/OrionSDK Wiki · GitHub

Are your running on the Orion polling engine or on the remote device? Is the module installed there? 

First, does service restart help? Second, does the report load in the website? How long does it take? Is it possible its timing out getting and converting that report? 

Generally I find that templates work the same for SNMP 1, 2, and 3. If you walk the SNMP device no using v3, don't you see the same values? 

On a personal note I have issues with email that gets pasted into Orion instead of typed, there are characters there that sometimes cause it to fail. typing it directly helps

Also look at this KB: Orion Platform Troubleshooting - Alerts (solarwinds.com) 

Does this report help? https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/reports/2035 

OK, then we shouldn't use the name to sort these out. It will just make too much work over time. It might be right today, but wrong next week. You can use that location Property and just find the city, and using a case statement map that to the Country. Or if your subnets map well to locations, or countries, consider that…

Since you have location information in the name, I assume that you have a format or pattern that you follow when a device is named. What is the whole format? Can we locate the number more specifically to reduce the errors you talked about? If not, we may want to set a location name in a custom property instead of using the…

What's the pattern for your naming format? If we know where to look for the number, it may iron out the other stuff. when you look for '%3%' the 3 can be any character in the string. 

One widget, just add values with its own SWQL Configured like this: 

Each box in the kpi widget is its own SWQL statement, so just filter the where with the same logic as the case statement, and use the label. Something like: SELECT Count(N.nodeid) as [UK] FROM Orion.Nodes N WHERE N.Caption like '%3%' and Status=2 AND (n.customproperties.AssetTag like 'Store Router')

I didn't have that custom property so I tested with it comment out, I didn't edit your line to use my alias for nodes. We may also want to replace '=' with 'like' since its a string comparison. Find: AND (nodes.customproperties.AssetTag='Store Router') Replace with: AND (N.customproperties.AssetTag like 'Store Router') I…

I'd filter results with the where added to first, and count them after, something like this. Select Count(t0.Caption) AS KPI_Numbe, t0.Location From (SELECT N.Caption, Case when N.Caption like '%3%' Then 'UK' when N.Caption like '%5%' Then 'Roi' when N.Caption like '%7%' Then 'NL' when N.Caption like '%9%' Then 'BE' Else…