sum_giais

I just showed you how Here's more info - https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions Do you have SWQL Studio? Give it a go...

Have you tried testing SWQL studio from another system? [quote userid="296001" url="~/products/the-orion-platform/f/orion-sdk/100096/why-my-admin-account-returns-empty-results-when-querying-the-db-in-swql-studio/316319"]The account is part of an administrators group. [/quote]Could you elaborate on that? E.g. is the account…

 @"LeBeauUK" is right. You could use this as a starter SWQL query. SELECT TOP 1000 rt.DateTime ,rt.NodeID ,rt.Availability FROM Orion.ResponseTime AS rt ORDER BY rt.DateTime DESC Though I must say - I always aim for 100% uptime... but you my friend @"giovana.prado" have achieved 100,000% uptime. Kudos to your hard work!…

Try removing the quotes on the '2', ContainerID is an integer. SELECT n.Caption AS [Node Name] , n.Status , n.StatusDescription AS [Status Description] , n.DetailsURL AS [Node Details URL] , n.MachineType AS [Vendor Name] , n.VendorInfo.Icon AS [System Vendor Icon] , n.CPULoad AS [CPULoad] , n.ResponseTime AS [Response…

Perhaps helpful - the disappeared and reappeared events seem to corelate to the responding property on volumes perhaps. That would make it a super easy alert. Double check with this query if you like: SELECT v.Node.Caption AS [Node] ,v.Caption AS [Volume] ,v.Responding FROM Orion.Volumes AS v

You could try these: ${N=SwisEntity;M=MAC} --- this should be the interfaces MAC address ${N=SwisEntity;M=PhysicalAddress} --- this is likely the same as the MAC variable above ${N=SwisEntity;M=InterfaceID} --- this is the unique identifier of the interface in SolarWinds I use this in alerts on…

The dates in the database are UTC. To convert to local time use the TOLOCAL() function like so: TOLOCAL(EndTime.EventTime) AS [EventTime]

To test logging in with your AD account manually in SWQL Studio, simply select "Orion (v3)" and login just like you would the web ui

@"ldelt" are you still seeing this issue? Where is SWQL Studio installed ? Same server as the SolarWinds Platform or a separate server? How exactly is the account you're logged into the machine with SWQL studio on, configured with access to your SolarWinds Platform (as others mentioned, SAML is only for web authentication,…

Has support directed you in anyway to rebuild the website and/or run the configuration wizard? I'd run through these steps in this order... but that error you show about "Data loss imminent" seems to point to something very wrong in the database. What's it show for more details there? Does it link to a KB at all? It's…

Hi there @"jimmy_mccubbins" , There's 2 issues I see when you're combining them. 1) Using an INNER JOIN - this should be a LEFT JOIN 2) Counting with * - need to specify exactly what you want to count since there's multiple datasets Try this: select Nodes.Caption, Nodes.N01_NODE_TYPE, IP_Address,…

Hi there @"richard.dahl" , You'd need to go into your NCM settings and edit the Firmware Upgrade Template you're using, by going to Settings -> All Settings -> NCM Settings -> Firmware Upgrade Templates. From there, find the appropriate Firmware Upgrade Template and edit it. NOTE: I've never used the "Verify Upgrade…

When setting up HA for an APE you need to install the software by selecting "High Availability - Backup server for additional polling engines (HA)". Once the installer is finished and the configuration wizard is completed on your backup server, you can go to your Web UI to establish the HA pools configuration…

Have you tried restarting the solarwinds agent on the node?

Hi there @"rodeyd" , Looks like there was a curly brace in the wrong place at the end of the Write-Output, causing the foreach loop to end at that. Try this: $credential = Get-Credential $swis = Connect-Swis -Hostname localhost -Cred $credential $query = @" SELECT n.Caption ,n.Uri FROM Orion.Nodes AS n WHERE n.Caption LIKE…

fyi @"kpina" and @"KMSigma.SWI" 

It's not that simple as I mentioned in my prior comment. The existing query, doesn't include any timestamp properties at all, so it needs to be re-written.

Are you asking with regard to modern dashboards or classic views? The original out of the box names would be what it is when you add/create it by default. You could go to your messages center (Alerts & Activity -> Messages Center), in the SolarWinds Platform (https://solarwinds_platform/orion/netperfmon/orionmessages.aspx)…

Here's an example of removing nodes with SwisPowershell (https://www.powershellgallery.com/packages/SwisPowerShell) Couple things you'll need to change. You'll need to figure out your scope, so the query will need to be changed for your environment, e.g. how you'll select just those 200 nodes you intend on removing.…

The query would need to be re-written to include Orion.ResponseTime data which has timestamps of the response time history of the nodes, either by joining it in, or by selecting it instead of Orion.Nodes. Either way it brings many changes to the query... I suggest taking a look at the documentation, and SWQL Studio to do…

Ah my apologies you're right, the component requires the node polling method to be SNMP. So looks like you would have to create another node monitored with SNMP potentially to do this.

What sort of data do you need to collect out of the snmp agent for the application? Could use a SAM SNMP component monitor in an application which could be assigned to the WMI managed node, would need to figure out exactly which OID's to monitor. documentation.solarwinds.com/.../sam-snmp-monitor-sw3302.htm

Get SWQL Studio...

Get SWQL Studio, it will tell you all that, see screenshots below. https://github.com/solarwinds/OrionSDK/releases Or you can look at the schema docs as @"stevenstadel" mentioned: solarwinds.github.io/.../ This may be useful too, as you can query entity metadata via SWQL as well.…

Hi there @"KMNRuser" , For Nodes here would be the rough process -- you'll have to branch out and figure out for other entities like interfaces, volumes, applications etc. Note this is NOT tested explicitly as below, but I have used this method to populate custom data into custom properties via alerts. The custom…

My bad I completely missed your note that it was already disabled. Sounds like a bug then 

Adding some quick clarification on this. The default N (5 by default) is the amount of Firmware Upgrade Operations (not to be confused with NCM "Jobs") that can run in tandem, which is a global setting that can be changed in Settings -> All Settings -> NCM Settings -> Upgrade Settings, adjust the "Maximum number of…

I talk a little bit about that here. There's ways to gather that data but the audit log is rotating. So custom properties could be one way to store those dates. The query I put in the thread linked below is only for nodes, but could be converted to look at other entities too.…

A couple things I'd check is that the pollers you're creating are actually enabled. Enabled is one of the properties on Orion.Pollers, I usually set it explicitly to true or false to be sure. Next you could set these UTC timestamp values (to something like 2 minutes in the future) in the Orion.Nodes properties NextPoll…

To start with... WMI uses ephemeral ports which windows dynamically grabs ports out of system pre-defined allocated ranges on-demand. thwack.solarwinds.com/.../441106 learn.microsoft.com/.../service-overview-and-network-port-requirements