Seashore · Solutions Architect · ✭✭✭✭✭

So you want us to download this free tool and run it as domain admin.... as part of the Cybersecurity Awareness month... https://thwack.solarwinds.com/t5/Geek-Speak-Blogs/Tips-for-National-Cybersecurity-Awareness-Month/ba-p/606244

Thanks, I will try that out!

Stumbled on that one also. I had to hack some SQL to delete them. (-- A fresh backup is good to have and don't mess with the db if you don't know what you are doing --) Run a "select * from Views" to find the viewid of the view you want to be able to remove. Update below query with correct ViewID to make the view editable.…

Interested! Live in Sweden so for me to go it has to more than an afternoon of meetings and sessions.

An honor to be on "the list" again, thanks. Welcome all new MVPs

Looks like I need new WIFI at home, not sure what sort though.

Hmm, it might be possible now to play with SQL variables. Had some issues before: Add SQL Custom variable in alert to address

Same issue with other alerts like disk alert. At least add the node name to the hoover popup.

I had a windows disk, volume, that reported to be several hundred of terabyte in size. Instead of a couple of hundred GB. Was a issue with the device then. Reboot of the monitored server helped then

With SQL Core based licensing on a virtual environment you can choose to either license the physical core's or the virtual. If you license the physical, you are allowed to run as many virtual core's as you want. But all possible core's has to be licensed. (Have hosts only for SQL servers) Take a look here for MS SQL…

Hi, so you are alerting when [Run Time]<30. And you are sending the variable for run time in the alert and that says that "Run Time=0", right? I can't find that value, run time, in perfstack, so it's probably a single value (don't have a lab at the moment). If you look at that value say 15 min after the alert, is it still…

Cirrus is the old name of NCM (Like Orion is no longer called Orion and SAM not called APM anymore....) Here is a full path for a simple query: YourSolarWinds:17774/.../Query

SELECT F.Node.NodeName ,I.InterfaceName ,F.DestinationHostname ,F.DestinationIP ,SUM(F.TotalBytes) AS TotalBytes ,DATETRUNC('HOUR',F.TimeStamp) AS [HOUR] FROM Orion.Netflow.FlowsByInterface AS F JOIN Orion.NPM.Interfaces AS I ON F.InterfaceID = I.InterfaceID WHERE ( F.DestinationHostname = 'xxx' OR F.DestinationHostname…

Hi With this query you will get all nodes that has a memory usage above 90%: SELECT N.DisplayName ,N.PercentMemoryUsed FROM Orion.Nodes AS N WHERE N.PercentMemoryUsed>90 What could be a better query, depending on your needs, is to show all nodes with memory usage above critical threshold: SELECT N.DisplayName…

Not sure if a NAT connection will work at all. I mean the APE will register it's address in the database but will actually have another one from the Mail Pollers perspective. (Might be that it's only connecting by hostname, if so make sure both parts can connect via hostname. Not FQDN, just hostname)

Yes, looks like an older version of SWQL studio as it tries to connect to port 17777, should be 17774.

Hi You can learn more from these pages: [mention:09c5a629069e46b189951199b458fa8f:6b577b8c04704e209d29b6772bf67243] In your example you should write: SELECT NodeName FROM Orion.Nodes WHERE NodeName LIKE '%NOC%' Skip the "IS" and use ' instead of ". %-sign is the wildcard character. Hope this helps

If you take an average of all the "bad" values and leave out the "good" once, then your availability will look bad. You have to calculate the average first and then remove all the 100-values. Test with adding below after GROUP BY row HAVING SUM([Nodes].ResponseTimeHistory.Availability * [Nodes].ResponseTimeHistory.Weight)…

Sounds like it's time for support to take a look.

Have you tried restarting the APE?

Happy to see your progress! If I understand you correct you want an average availability of all your windows server with that owner. I took your query and made it a subquery of another that makes the average of all the servers: SELECT CONCAT(AVG(Tbl1.Availability), '%') as AvgAvailability FROM parentheses SELECT…

Hi, can this page help? https://github.com/solarwinds/OrionSDK/wiki/Managing-Custom-Properties

The default path for all application monitor logs are: C:\ProgramData\SolarWinds\Logs\APM\ApplicationLogs Then you go to the folder with the application id of your application. 

Can it be that you have to put in a valid node id on this line: WHERE NodeID = @nodeId The node id of the node who's availability you are trying to get.

Hmm, ok. Then I don't know. Maybe something for support then to have a look at.

But I can only see 24 servers, and then there are 24 hosts. Vmware/HypeV-hosts. Are they monitored with agent/WMI? Or can there be snmp-monitored devices in there? 

Hi All monitored values in SolarWinds are aggregated after some time. Defaults are that detailed info is aggregated into hourly data after 7 days. After 30 days hourly data is aggregated into daily values. And after one year, data is removed. (Different types of data might differ from this). These are defaults but can be…

Hmmm, I wrote the full url but it got shortened here.... Trying with some extra spaces that you have to remove.... /Orion /IPAM /subnets.aspx And a picture also :-)

Hi Are you talking about editing through the new GUI? In that case I suggest reverting back to the old GUI, it's still there. Go to YourSWServer/.../subnets.aspx

If the servers are int the group and the application template is assigned to the group, the template will be assigned to each server - eventually.... Sometimes it takes a bit of time. You wrote this post 22hours ago so it should be ok by now though. There is no limitation on this usage, I have applied an application…