Seashore · Solutions Architect · ✭✭✭✭✭

Interesting idea but will not work, orion hasn't the credentials for monitoring it with wmi. But node availability is measured just by pinging the node if not an agent. But that might not be opened in firewalls when using agent so will also not work. But yes, there should be some other function for this....

Trying to run this out-of-the-box report at a customer using EnergyWise but the query takes forever.... Cancelling. EDIT: found that this installation has issues with maintenance. Way to much data in details table for energywise so never mind my issues with the report :-)

Not sure what can be in that table, mine is empty and yes I do have AppInsight for IIS on several servers. 144 million rows sounds to much. I would contact support about that. 

I don't think that output is formatted in a way that the API poller can handle. I would suggest you use a power shell script to filter out what you want or make prometheus format the output.

I'd like to know also. Can be very confusing when you have a lot of cores. Feature request?

I am assuming you are using the built in report for that. I took a look at the data source for that report and it looks like the price is hard coded in the report. You can change that yourself by pressing the edit button: Then change the value to what you want.

I don't think I have done that with agents, only snmp/wmi and that works fine. But can understand the issue here. Why don't you start by putting them on "mute" and then change polling engine. When ok again you remove the "mute".

...and NOC view mode with automatic rotation is NOT available YET with modern dashboards :-)

I would see "AccountType=4" more as information and a log. There is no need to clear out that. if the user is no longer a member of the AD-group he/she can't log in anymore.

Hi, You can use below SWQL to get all nodes using snmpv3 and there credentials. There are more columns to add and discover if you need to but here is a start: SELECT N.Caption ,N.SNMPv3Credentials.DisplayName ,N.SNMPv3Credentials.Username ,N.SNMPv3Credentials.RWUsername FROM Orion.Nodes AS N WHERE N.SNMPVersion=3 And this…

Can it be that on the account settings below marked value is sett to "none"? I'm guessing it is when you go to a node details page you get "access denied"

If you go to the SQL server and look at the actual log file itself, how big is it? Who is right? Is it off a lot?

Percent Memory Used: ${N=SwisEntity;M=PercentMemoryUsed} Total amount of memory: ${N=SwisEntity;M=TotalMemory}

NetApp can respond to SNMP-queries. If you have NPM as well I would use UnDP's within NPM for that. But SAM can also ask SNMP-queries and get out some info.

I'm no powershell guru either but I made this some time ago and it worked: $members = @( @{ Name = "Store $site"; Definition = "filter:/Orion.Nodes[CustomProperties.Site=$site]" } So MAYBE if you remove the " ' " in '$SWSite.SiteCode' Or is it that it only reads the first part, only the $SWSite-part, and not the whole…

Also remember, when you set an object in "Maintenance mode" you can either choose "UnManage" or "Mute". When you mute polling continues but alarms will not trigger. With Unmanage polling is paused. Above query does not include "Mute", only "Unmanage"

Ahh, had to read a couple of times :-) It's not the NODE that has been unmanaged but the APPLICATION. You can unmanage on several different levels. Adjusted the query to include "application unmanage" also. SELECT ToLocal(TimeLoggedUtc) AS [DATETIME] ,A.AccountID ,A.AuditEventMessage…

This is not a MS SQL query but a Solarwinds SWQL query. Are you using SWQL Studio to run it? You can also create a report from this query. You may also just remove the "ToLocal" part if it does not work where you try it. Getting started with SWQL Studio:…

Below SWQL will give you all unmanage event last 7 days. There you have user account and nodes. !!You have to have admin access to Orion to get audit info!! SELECT ToLocal(TimeLoggedUtc) AS [DATETIME] ,A.AccountID ,A.AuditEventMessage ,A.DetailsUrl ,A.DisplayName FROM Orion.AuditingEvents AS A WHERE…

Hi, if you leave the critical or warning fields blank they will never be critical or warning. So just erase the "0" you have there.

Create a report with the data you want and export the result to excel. Or use SWQL studio to create a query for all the node and "cut and paste" the result to excel

Hi Within the SAM HTTP and HTTPS component you can choose authentication methods: First use an account with permissions to that website. Second choose the "Authentication mode" what suits your needs. Test them! :-) Hope that helps.

Hi @"WinterPeg80" and welcome to Orion! Below query gives you the number of nodes that are down. Also wrote filters for other node status so you can choose what you want to have. Enable the once you want to use. SELECT Count(N.NodeID) as Numbers FROM Orion.Nodes AS N WHERE --N.Status=1 -- Up N.status=2 -- Down --N.status=9…

Hi, this is the interesting part: [quote userid="281691" url="~/product-forums/solarwinds-backup/f/forum/93461/db-check-error---db-solarwindsorion"]Table error: Object ID 299148111, index ID 1, partition ID 72057927228391424, alloc unit ID 72057594050510848 (type LOB data). The off-row data node at page (1:125497), slot 0,…

Is it the URL-monitors that are unknown? They are checked from the polling engine that the node is assigned to. You could log into that polling engine and manually check that you can reach the URL's from there. But, if the are not reachable they should be down. Not unknown. There is some other issue here. Maybe you should…

On https://github.com/solarwinds/OrionSDK/wiki/PowerShell you can read about how to remove a swis-object. The code is: <span class="pl-c1">Remove-SwisObject</span> <span class="pl-smi">$swis</span> <span class="pl-k">-</span>Uri <span class="pl-s"><span…

Here is an updated link to that article support.solarwinds.com/.../Assign-a-vendor-to-an-ICMP-node

Hi, have you set up "Application owners" as a custom property? If so create a report with a datasource something like this: (I didn't have a CP called "Application_Owners" so I choose another for display)

Audit-info is only available to Admins through SWIS. Maybe if you access the info through SQL instead of SWQL you will get the info. (before only admins could see SQL generated tables in GUI but I think that has changed)

Evening fun, SQL queries..... :-) Composed a query that counts the component cost and take into account the specific cost for the appinsight templates. For some reason I don't get exactly the same number as the license page. But it's pretty close. Might be ok. Import below as a report and see if it looks ok.…