Comments
-
Haha, sure thing @"planglois". It's soon my turn to switch off for today. Your turn to assist now
-
Hi Olof Might this work for you SELECT TOP 1000 VN.EntryId AS [Entry ID] ,N.NodeCaption AS [Device Name] ,VN.State AS [State] ,VN.VulnerabilitiesAnnouncements.Score AS [CVSS V2 Base Score] ,VN.VulnerabilitiesAnnouncements.Severity AS [Severity] ,VN.VulnerabilitiesAnnouncements.AnnouncementUrl AS [URL] FROM…
-
I would put below line AFTER all the other code: WHERE N.Vendor='Cisco'
-
Changed one line and got some more temperature values (not all temp sensors are called temp sensors....): SELECT Top 100 N.Caption AS [Device name] ,N.IP_Address ,N.MachineType ,N.Vendor ,N.HardwareHealthInfos.ServiceTag AS [Serial Number] ,T.AVG_Node_Temp_Celcius AS [AVG Temp in C] ,T.AVG_Node_Temp_Farenheit AS [AVG Temp…
-
I guess you have to go to custom SWQL then
-
Is this what you are looking for? SELECT Top 100 N.Caption AS [Device name] ,N.IP_Address ,N.MachineType ,N.Vendor ,N.HardwareHealthInfos.ServiceTag AS [Serial Number] ,T.AVG_Node_Temp_Celcius AS [AVG Temp in C] ,T.AVG_Node_Temp_Farenheit AS [AVG Temp in F] FROM Orion.Nodes AS N LEFT OUTER JOIN ( SELECT NodeID ,CASE WHEN…
-
Well the warning still stands and you continue reading on your own risk Grab your favorite tool to connect to your SQL server, no Solarwinds Orion database manger will not work. It does strange things.... You will most likely use SQL Server Management studio. Maybe you have that installed on your pc, a management server or…
-
On the application monitor configuration page, you can set debug logging to "on": Then you get a log file on the orion polling server at "C:\ProgramData\SolarWinds\Logs\APM\ApplicationLogs", one folder per application ID with debug enabled. Some googling shows several that has issues with antivirus program, giving that…
-
Isn't this something for the "User Device Tracker" module?!? There you can see what device is connected to what port, and if you connect to your domain controller also you see what used logged in on what device - port- switch..
-
Hi, do you have that on the "groups" page as well? In one installation I have that for some groups but not all. If you create a new group, do you get the same result?
-
I don't know for sure for this exact template but I would create an external node representing that AWS instance. Then assign the template there. The template will run on the polling engine the external node is assigned to so make sure it works from there.
-
If you have the availability in percent you can just multiply that with number of hours in the timespan you want your report in. Same method with downtime, (100-[Availability percent])*[Hours in time span]
-
Are the PS scripts ran locally or remote? What is the "execution mode"? Depending on that it behaves differently.
-
Have you tried this? Do you get any error? I think this will work. You are correct that custom properties are not in orion.nodes BUT many tables are "pre-joined", meaning that you can actually write like suggested above. Jumping from one table to another on the same line.
-
It's a feature, not a bug :-D It can be convenient to be able to set whatever name you want in Orion and it still works and displays the "real world name"
-
To be able to monitor a device, or a vcenter, an Orion Polling Engine must have access to that device over the network. (Main server includes one Polling Engine) The easiest way would be to open connection from your main orion server to the monitored device. Another way would be as you say to install a polling engine on…
-
I haven't tried it with volumes but I guess it's the same as with node names. Node names and volume names are called "Caption" in the database. Caption is set upon adding the node or volume. It does not change even if the nodes name change. You can go in an edit the volume and change the name there to what you want. Same…
-
I have seen situations like this a couple of times last month at different customers. One time the link between the application and the template was gone. The other time the template was removed but the application remained. First time, when I looked at the application in SAM I just got errors. I then had to go into the…
-
I suggest you contact support to get assistance. Installing Orion on Win2019 and SQL2019 should not be any problems. "Named pipes" sounds like you have issues connecting to the database. Are you running a SQL express maybe? Have you in that case enabled TCP/IP on that? (Off by default)
-
Hi Sumit12, as you can see in the script we are getting different columns and on my labborion I get different output in the different columns. Did you get different output before but not now?
-
Changed the script at bit as you wanted Sumit12; SELECT C.Name AS [Name] ,C.Application.Node.Caption AS [Server] ,C.Application.Node.IP_Address AS [Server IP] ,ISNULL(CS.Value,CTS.Value) AS [Website] ,S2.NumericData AS [Days until expire] --,S1.StringData AS [Issuer] ,SUBSTRING(S1.StringData,24,100) as [Issuer]…
-
The output from the Powershell script must be formated in a way that Orion likes. Start by looking here: https://documentation.solarwinds.com/en/success_center/sam/content/sam-script-text-output.htm The output should be a number and an optional text. For example write-host Statistic.License1: 4999 write-host…
-
If I remember correct Grafana wants to as SQL queries right against the database to create its graphs. So it need a readonly account in the SQL database and then you need to know what queries to ask. Nothing is prepared for that so it's just to start from the beginning.
-
When you do a "group by" all columns must be either in an aggregation, as "MAX" that you used, or noted in the GROUP BY statement. So adding the columns like KMSigma suggested bakes it work. Change the group by line to: GROUP BY [Events].Nodes.Caption,[Events].Nodes.StatusIcon,[Events].Nodes.DetailsUrl,[NN2].Note
-
See; thwack.solarwinds.com/.../supplement-the-hardwareserialnumber
-
If you are monitoring vmware from Orion you will have a lot of info about all virtual machines, including a value called [UUID]. That value seems to be the same as what you get if you run "wmic bios get serialnumber". A bit different formatting but the value is the same.
-
I checked my lab, no vmware guests have serial number. The physical machines have but not the virtual.
-
On the KPI widget in modern dashboard you can set thresholds. When those are breached is changed color. That's the only way I think:
-
Maybe this can give you some clues: https://documentation.solarwinds.com/en/success_center/whd/content/helpdeskaddadldapdirectoryconnections.htm
-
Hi, I don't know anything about WHD but some about certificates. Here it looks like your computer does not trust the publisher of the certificate. Can it be that you created a self-signed certificate? Not a certificate from a trusted publisher?
