WinterSoldier · System admin · ✭✭✭✭✭

Edit that widget and check for Check the Widget link url. Its something with the URL which could be incorrect.

Hi @bourlis , Thanks for sharing this information. I have one more question on KPI widgets. I have recently upgraded to 2025.4.3. I have a KPI widget for Node status and Interface status which lands me to the List of Nodes and list of interfaces page based on the status that I click. Example, if click on Critical Nodes, it…

Thank you for providing this SWQL. Does this query differs from version to version? This swql works on v2025.4 but it throws an error on v2025.2.1.

I am getting this error. <Fault xmlns="http://www.w3.org/2003/05/soap-envelope"> <Code> <Value>Sender</Value> </Code> <Reason> <Text xml:lang="">Orion.Dashboards.Instances.Import failed, check fault information. Unexpected character encountered while parsing value: x. Path '', line 0, position 0.</Text> </Reason> <Detail>…

Awesome. Thank you for that. Is there any between function I can use in SWQL? If I want to see the data from 1st Sept to 15 Sept for an instance?

Hi @RAJPAD , I disabled the session timeouts and looks like the issue is fixed. This could be a bug in previous versions.

Thank you @Lofstrand for sharing this query. I just need timestamp as in the date & time. For an example, if I want to extract a report of all windows servers with its avg cpu, memory for last month. How can I achieve that? Screenshot attached for reference.

Do we get any completion or participation certificate post attending this class?

We have primary poller and additional web server. The IP / hostname of both the servers are binded on F5 load balancer. So, we are using a https URL to access solarwinds web console as LB will forward requests to any of the server (Primary or AWS). The issue is, we occasionally face session time out issues while navigating…

HI @"bourlis" , Sorry, I mixed two things here. So when you open any node details page on SolarWinds, you will see Hardware details in the summary tab if that device or a server is Physical or virtual. If the hardware type is physical, it will show as Physical but if the hardware type is virtual, it will show as "virtually…

It worked. Thank you.

Thank you @"mesverrum" for quick response. This solves the purpose. Just need one more thing to add in both the queries. Can you help me appending these columns? 1. Acknowledged (Yes/No), Acknowledged By in Active Alerts query. 2. For Alert SLA Query: Instead of daydiff(ah.timestamp,GETUTCDATE())<30 how can I use Between…

I believe this is for VMAN module. Apologies for the delayed response. Please help me with the correct path to report this. Also, I was working on below query to get the devices count of hosts, clusters and VMs monitored through VMAN. Select DC.Name , VCC.DisplayName AS VCenter , VCC.Name AS IP , Count(VM.VirtualMachineID)…

Hi @"Seashore", Hope you are keeping well. I was working on one of the below query for Unmanaged or Muted Nodes which is working perfectly fine. --Unmanaged SELECT N.Caption AS [Node], DATETRUNC('minute', N.UnManageFrom) AS [Suppressed From], CASE WHEN ToString(tolocal(N.UnManageUntil))='Jan 1 9999 12:00AM' THEN ' -…

Hi @"sum_giais" Thank you for sharing this. My main objective is to get the list of all nodes when I click on the Total column of that relevant custom property count (example 4). Please refer to the output below. GroupUpDownWarningCriticalUnmanagedTotalActive Directories400004 I have used below query for the above output.…

SELECT n.CustomProperties.Primary_Category, '<a href="/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:' + TO_STRING(n.NodeID) + '">' + TO_STRING(COUNT(CASE n.Status WHEN '1' THEN 1 ELSE NULL END)) + '</a>' AS UP, '<a href="/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:' + TO_STRING(n.NodeID) + '">' + TO_STRING(COUNT(CASE…

Yes. That works. Thanks a ton for your help. :)

--Unmanaged SELECT N.Caption AS [Node], DATETRUNC('minute', N.UnManageFrom) AS [Suppressed From], CASE WHEN ToString(tolocal(N.UnManageUntil))='Jan 1 9999 12:00AM' THEN ' - Forever - ' ELSE ToString(tolocal(N.UnManageUntil)) END AS [Suppressed TO], CONCAT(DayDiff(N.UnManageFrom,GetDate()), ' days') as [Suppressed days],…

Yes. Excellent. This seems working. One last thing to add here. I need the timezone of local server. Can it be done?

Please help me with the following. 1. If I am suppressing for next x days (3 days) then it should show me Suppressed Until as X days. 2. Is it possible to keep the existing query and append point 1? I mean, it has two columns, one for Suppressed days which shows since how long it has been suppressed and one for Suppressed…

Oh okay. Can I you help me modifying the query to get the output for how many days it will be suppressed considering the screenshot I shared above please?

Hi I have used below query and got the output as mentioned in the screenshot below. It seems there's something wrong in query leading to incorrect Suppressed days. --Unmanaged SELECT N.Caption AS [Node], DATETRUNC('minute', N.UnManageFrom) AS [Suppressed From], CASE WHEN ToString(N.UnManageUntil)='Jan 1 9999 12:00AM' THEN…

I ran the query and got the below output. Action TypeIDActionTypeActionTypeDisplayName34Orion.NodeUnmanagedNode unmanaged64Orion.AlertSuppressionAddedAlerts muted65Orion.AlertSuppressionChangedSchedule for muting alerts changed

Hi, Thank you for sharing it. Yes I am planning for an upgrade. Meanwhile this came up as a requirement. Tried with your query but seems there's something missing. It doesn't show up the accountID in Suppressed by. Its blank. Also, I could see it is not calculating the suppress duration properly. Unfortunately I am not…

Thank you for your response. I went through the article which you shared. However, I am new to this, can you help me what to mention in WMI Namespace and the Query section of WMI monitor component? Or if you have any screenshot / used case scenario, please share. Thank you.

Yes I confirmed that bug with support which says issue with nightly maintenance is getting finished but it has some white noise bug. But how it relates to the SolarWindsOrionLog database? Can you please elaborate more? Also I tried…

I believe yes.

Yes I tried. I want to import Network Summary Dashboard via Orion SDK. So I tried copying the JSON & pasted in the definition tab of Orion.Dashboards.Instances .Invoke and ensured no spacing between the characters. However, it seems like there's some limitations in characters under the definition tab. Please the below…

I have received the response from the vendor support. While checking the logs it was observed that the VIEW SERVER STATE permission was denied on the object 'server'. database 'master'. The user doesnot have permission to perform this action. Work around: Reference article - How to grant the View Server State permission in…

Thank you for responding. Thought we don't use Azure SQL, its the Microsoft SQL 2019 standard which is being used.