heldy

Did all this but no significant errors , the engineer i was working with on this did some changes after consulting with their dev team , optimizing webpages by decreasing widgets and decreasing nvchar for Node Custom properties but no change , slowness still persists 

THe CPU is mostly at 45% Polling engines are not at capacity Ports are open SQL database is on a different server I have two tickets open with TAC on this but no resolution so far , can someone help here , one of the cases have been open for months , i was told DEV team is looking into it but no communication , i have been…

It happens on any webpage of this instance , especially if its opened for more than 5 minutes .Our license is HCO now we so have everything included , currently we are not monitoring anything with SAM.When filtering logs with being set to as critical , can see below error

But this should work , especially when i have a custom property Site Already assigned ?

I deleiberately changed them and site code to to garbage values , dont want to paste it on a public forum 

I am still curious , will try what you have suggested and the group approach , but I am trying to import this property using excel and it should work taking in mind that Region/Site Coulumn exist in Custom Property of SQL database I am still getting errors after uploading the sheet , should i incorporate another table…

IPs will be a lot of information as it will vary , we have an existing coloumn Custom Property called region in database which is common on nodes where we want to assign Latitude and Longitude , i have been trying to use it but getting errors.Is it not possible to use it , documents says atleast one existing column should…

Also I am aware of this custom property of World Map , if I have the Region Info( one column/Custom Property in the existing database to match and with the excel sheet i have from my internal resource with Site Info on Latitude and Longtitude) , can i somehow use it to write a sql query to add that data using Database…

I will try this out

Does anyone have any suggestions on this ..still looking for answers ?

This below also worked for me too SELECT AVG (AvgResponseTime) AS AvgResponseTime FROM Orion.ResponseTime WHERE NodeID in ( SELECT E0.NodeID FROM Orion.Nodes AS E0 WHERE ( ( E0.[CustomProperties].[x_x_x] = 'abc' ) ) ) AND ObservationTimestamp > addday( -7, GETUTCDATE() )

I have already posted the question for this in a different dashboard . SW version is 2023.2 , i downloaded the latest version of SDK last week , not sure on the version though 

Any help appreciated , SWQL studio seems better option but right now i am unable to connect on it maybe because of version upgrade to 2023 and rest client port changed

The kind of data that I am trying to see can also work for Nodes. Nodes are assigned custom property/tags , so lets say if I want to see the combine Response Time for the last one hour on nodes grouped Custom Property "Layer2_Switches" how is it done ?

CPU seems to be stable for now.

This is currently hapenning on 333 nodes , pollers assigned and interfaces selected

Do I have to run this query under Nodes(view) or Interfaces table ? Also while running this query on these two tables I am getting error 'ToLocal' is not a recognized built-in function name.I am running this in Database manager not MS SQL studio , but I think I can also also run in SQL studio but where to run is my…

thank you for your response

Hi Cherly , i do not found any log file under Solarwinds\Log\Orions but instead found a log file under Rabbit MQ , which is a huge file and in which i was not able to find "death by thousand cuts". Am I looking at the wrong location ? Nobody from support reached out to me specifically on CPU case , i will open a new case…

Hi Guys , I created Orion Insights reports and after going through it I found following Critical points on it 1 . RAM used by w3wp.exe is 1043 MBs , I had Application pool settings changed earlier already for time interval so not sure why is still consuming this much of RAM on recommendation by TAC. 2. 2 Alert Actions…

I am going to do this now as well to see.

I also checked license details under Admin > details > License Details , all the modules are on the same version 

Hi Thank you for your responses ...maybe I spoke too quick on the CPU part , today we are experiencing the same slowness and CPU staying high when accessing the Solarwinds console ..i tried checking Solarwinds version but it appears all polling engines are on version 2023.1 and since when i did upgrade on this Solarwinds…

An update on this , after the engineer did some more troubleshooting last Thursday we were able to run the NCM jobs successfully and the CPU on the main Orion server seemed stabilized for now , but then after this we are see new kinds of error on Solarwinds Portal , such as warnings on License expiring soon ( although its…

Also not entirely sure how can i send you my account information privately here on Thwack:)

Hi Cheryl ,Thank you for responding ! Case number is 01337384 . Please also note that this case was started as with the issue that NCM job was stuck on Post processing where we observed CPU going high , after repairing Solarwinds on one of our APE's , this seemed to have been resolved..but too quick to say on that if…