Seashore · Solutions Architect · ✭✭✭✭✭

Currently latest version is 2023.2.1

Not entirely sure I understand you correct but here is a query that gives you all nodes that are not found in vmware/hyperv/nutanix but are Windows or Linux SELECT n.Nodeid ,N.Caption ,N.vendor ,N.MachineType FROM Orion.Nodes as N LEFT OUTER JOIN Orion.VIM.Virtualmachines as V ON N.nodeid=V.NodeID WHERE V.NodeID IS NULL…

Make sure that all your polling engines and the database have the same timezone, otherwise it might get messy. Most datetimes are in utc in the database, but not all.....

Hi, the trick is to get snmp working. Then monitoring with SolarWinds can be done, either with UnDP's or other tools. Haven't done anything with z/OS but with as/400. Not sure if they have any resemblance. (not my area at all) Then we had to add a snmp agent from COMTEK.

To use the in SAM built in "Windows service monitor" you need to specify each service name. Another option is to create a powershell script that gives you info about all SQL services, but then you will not get all the extra information about the service, like resource usage.

No, that is not possible as far as I know. You can add your own custom queries to DPA monitoring. With queries you can show CPU usage per database but per user, haven't seen that.

Hi, if you have Asset Inventory enabled on your monitored servers you can create a report in SolarWinds on what servers that is installed on.

How about doing something like this:

I would say, no you can't. But you probably can create a custom SQL/SWQL variable that fixes this but with a lot of coding. The variables depend on where you "stand". If you are alerting on a node, you point out the path to the target from the node. If you are alerting on an application, you point out the path to the…

Using "normal" report features, no SolarWinds don't have that feature. You could probably accomplish that by creating a fancy SWQL query that adds that info already in the query result.

I'm actually having the same issue. Running 2023.1. But here it's a couple of reports with two SWQL queries. When opening the reports in GUI it just hangs. If I remove one query the report opens fast. I also today found that if I schedule the full report it also works fine. The SWQL's runs in less than 10 sec in SWQL…

We had this issue also, same error in event log and constant crashes of InformationService. Update of .net solved our issues.

Try this one: WHERE MessageDateTime BETWEEN DATETRUNC('day', AddDay(-1,GETUTCDATE())) AND DATETRUNC('DAY',GETUTCDATE())Seems like it's the "-1" you used that is the issue. 

Try this: SELECT ControllerID, SSID, MAC, Channel, WirelessType FROM Orion.Wireless.Rogue

Hi You got two options (at least) You can create a custom SWQL alert, writing what you just did in SWQL Or you can create an alert rule with "advanced options"/"Complex conditions". There you can specify multiple sections with what you want:

Hi, yes if you want to monitor https availability and certificate you can monitor them through SAM, without adding them as nodes in orion. If you want to monitor the IIS services and/or the Appinsight for IIS you need to have the node monitored. 

Hi, I haven't seen that one before. Sounds like a bug. If upgrading to latest dpa version doesn't help I suggest opening a support ticket.

No, using all licenses does not corrupt the database. What happens if there are no licenses left is that new components that are added does not work and gives an error stating that they are unlicensed. The licensed components still work.

Are you using the "Oracle User Experiance Monitor" Component in SAM? If so, what driver type are you using then?

Hi Did some testing here: So you see part of your code here. [Text4] gives the same result as you have. either you do as in [Text2] or [Text5]. The main thing is to remove the ".0" you have added. Hope that works for you. (Next time, please add the code not only as picture, easier to test then. You can "insert"/"code" and…

Some times the web interface has issues updating the groups. Try a IIS reset and see if the groups show up correctly.

Hi 1. Not sure but have a look at this. first thing I found using google search: https://documentation.solarwinds.com/en/success_center/orionplatform/content/install-scalability-engine.htm 2. I think you need icmp ping also bidirectional. If you have a Additional Web server you will need some ports there as well 3. Go to…

No I think you are correct @"marcrobinson". Just a backup restore that can save those files now.

Regarding transaction logs: If you are running your db in "full recovery mode" you have to take log backups to truncate the logs. Depending on disk size and activity I suggest you take log backups every hour or so. If you have the database in "simple recovery mode" (recommended by solarwinds (for some reason)) you don't…

Some of them are mentioned on the page above. Some others Orion will tell you it'self in the "My Orion deployment/Deployment health" page. But mostly it's normal procedures. 

Yes, both Windows Failover Cluster and Availability Groups are supported

You should probably call support for this one. C:\ProgramData\SolarWinds\Logs\Orion\ConfigurationWizard.log might give you some more insights, but Support is suggested. You payed for it so use it :-)

When upgrading to 2022.3/4, all old stuff was uninstalled and the folders emptied. I think this means that all custom files, like the unmanage jobs, are gone. The new path to the jobs seems to be something like "C:\Program Files (x86)\SolarWinds\Orion\Jobs", depending on where you installed your files.

Yes, ICMP for up/down etc, and snmp for the rest. That's for NPM. (Other products like SAM use other protocols also)

By default Orion uses icmp ping, not snmp, to monitor if the node is up or down. Can you ping the node from the orion box? You can change this so that Orion uses snmp on this node to monitor up and down. (Do a "list resources" on the node and change "status and response time" to snmp instead)