Seashore · Solutions Architect · ✭✭✭✭✭

Another way also: Go to Settings/All Settings and then "license details" (URL should be like YourOrionServer/Orion/Admin/Details/ModulesDetailsHost.aspx) Find SAM: "Number of nodes allowed due to license" = Node based license "Allowed Number of Component Monitors" = Component based license

Go to Settings/All Settings and then "license manager" (URL should be like YourOrionServer/.../license-manager) Find your SAM License. If it says something like "Server & Application Monitor SAM1500" you have node based license If it says something like "Server & Application Monitor - ALX" you have component based license…

Are you sure you are using SAM with Node based licensing and not Component based licensing?

Hi I can't run it at all on my labb. Think it's because my messages are note formated in the way yours are. BUT, I get the same error when you run Query 3, think I have seen that before. First I think you want a () around your alertobjects in the where clause. Second, I changed from using the AddDay to just do a…

This query seem to add up. How does it look on your side? Does the number of nodes returned match what orion license page say? Use this as base for your report. SELECT N.Caption ,N.IP_Address ,N.MachineType FROM Orion.Nodes AS N WHERE N.NodeID IN (Select DISTINCT Nodeid FROM Orion.APM.Application) OR N.NodeID IN (SELECT…

Hi Thought that would be an easy one to answer. Thought first that all nodes polled with WMI took a license but that it not the whole truth. Then checked if polled with wmi + agent would be close to truth. Close but not exactly. Also, it depends on what other modules you have: The term "managed node" can be interpreted…

Hi I would start digging into https://github.com/solarwinds/OrionSDK/wiki/REST Then you have the IPAM specifics here: https://github.com/solarwinds/OrionSDK/wiki/IPAM-API

Hi 1. Yes, almost. Some things can be exported/imported like alerts and reports. But statistics, configuration and thresholds will be lost 2. Not that I can think of. I would take out all the nodes IP's from one Orion and do a rediscovery on them on the other Orion server. 

Same to you Jez!!!

Hi, you have to go via the table NCM.Nodes. Like this: SELECT ND.Caption ,EP.EntityName FROM Orion.Nodes AS ND INNER JOIN NCM.Nodes AS NCMND ON ND.NodeID=NCMND.CoreNodeID INNER JOIN NCM.EntityPhysical AS EP ON NCMND.NodeID=EP.NodeID

Ok, do you see volumes on the nodes within Orion? If so do you there have a volume called "Physical Memory"? If not, when you do a list resources on the node do you see something like below? There we have memory on two places: Wonder what memory info we got in orion so we can create the report.

Ok, understand now. But you monitor the servers as nodes, don't you get the total RAM there?

Ehh, They are windows servers but hypervisior say they are RedHat!?! Ok, so it's the VM's you want the report on then, not the nodes? They are different objects in Orion. Do you have VMAN also or just the "basic" virtualization monitoring?

If you can create that check in powershell you can have SAM to do the check for you.

Hi If you are monitoring the nodes already you have that information in Orion so the report is simple. (WMI filters can only be used on Windows machines and only when you query the node itself for info. Not doable or needed here. Is this what you after? If so import below report to your Orion and you have the report.…

Another take on this. Combining KMSigmas query and mine: SELECT [Events].Nodes.Caption AS [Node Name] , [Events].Nodes.CustomProperties.City AS [City] -- Include other Custom Properties using the same format as above , CONCAT('/Orion/images/StatusIcons/Small-', [Events].Nodes.StatusIcon) AS [_IconFor_Node Name] ,…

Hi @"bharris1" Will this query work for you? (SWQL code) SELECT N.Caption ,NN2.Note ,NN2.TimeStamp ,NN2.AccountID FROM ORION.Nodes AS N INNER JOIN (SELECT MAX(nodenoteID) as noteid,nodeid FROM Orion.NodeNotes GROUP BY nodeid ) AS NN1 ON N.NodeID=NN1.NodeID INNER JOIN Orion.NodeNotes AS NN2 ON NN1.Noteid=NN2.NodeNoteID

Ok, so it's not open from Polling Engine to PostgreSQL-server on TCP/5432. Do you have that driver on that server you have the agent?

When you have an agent the check is done from the agent (I think) where the driver might not be installed. With Agentless its ran from the polling agent where I guess you have installed the odbc driver. Change the template not to use agent but be "agentless"

Hi I took the script from @"KMSigma.SWI" above and changed is just a bit, added that the URL is taken from the argument field in the component. Script then goes like this: # Tested with PowerShell 5.1 #region Define Exit Codes # Shamelessly stolen from https://blog.kmsigma.com/2017/09/08/sam-powershell-scripting-template/…

How about this: SELECT n.Caption AS [Node] ,ce0.StringData AS [Subject] ,MAX(ce1.StringData) AS [Issuer] ,MAX(ce2.StringData) AS [Expiration] ,MAX(ce2.AvgNumericData) AS [Days until expire] FROM Orion.APM.Component(nolock=true) c INNER JOIN Orion.APM.CurrentComponentStatus(nolock=true) AS ccs ON c.ComponentID =…

Hi I Think this will work, alerting on nodes that have more than 20 node down events last 48 hours: Create a custom SQL alert with node as base and add below code: INNER JOIN (select Count(Eventid) as nroftimes ,NetworkNode FROM Events Where EventType=1 --Node down AND EventTime>GETUTCDATE()-48 --Events last 48 hours Group…

Hmmmmm, got to be credentials then. 

Hmmm, I wounder if the "test-button" tests all ports necessary... "Trust is good, control is better". I wound do a "Test-netconnection SERVERNAME -port 389" from powershell on your orion server to be sure. 

Check the Settings-table in SQL.

can you reach your domain controller on that ldap port from the Orion server? (I had issues with that at one place)

Ok, something is really not ok then. I would suggest to rebuild the Orion website to start with. support.solarwinds.com/.../Rebuild-the-Orion-Website

Is this for any widget on any summary page? 

If you think of the result like excel, cell A1 is the integer, the statistics. Cell B1 is an optional text value. The rest is ignored.

I have got several feature requests realized in products. When there is hope there is a chance.... ;-)