Comments
-
Hello! There's nothing wrong with your database, probably just some issues with IPAM and SWQL. If you are trying to get a hold of the used IP addresses, you should be querying the IPAM.IPNode entity with a WHERE Status=1, something like the following: SELECT IpNodeId, SubnetId, IPOrdinal, IPAddress, IPAddressN, IPMapped,…
-
Hello! See the following links in terms ox *nix memory calculation: Re: Linux Memory Utilization Monitors and You Help! Linux ate my RAM! After reading both of the above articles you should be in a better position to decide which method suits best your needs for memory monitoring.
-
The SolarWinds agents are able to only monitor the server they're installed against. Think of it as a different polling protocol (vs SNMP for Linux or vs WMI for Windows servers). If you need to monitor remote networks where your application server does not have access to (or is simply not routed) you would require either…
-
As far as I can tell there are no more tables involved in topology, maybe something not entirely right with the SQL query? Can you find the missing entry in the [SolarWindsOrion].[dbo].[TopologyConnections] table without the JOINs ?
-
Try to switch to Agent-based monitoring, at least as a troubleshooting step. The Agent worker logs are much easier to read too and isolate any issues/failures with polling
-
That looks great! When should we wait for the modified mainlayout.css then?
-
Hi, You will need to lookup IP Addresses values from the NodeIPAddresses table, and match them with the NodeID and InterfaceIndex from the Interfaces table. Try this: SELECTNodes.City AS City, Nodes.Address_all, Nodes.Caption AS Node_Name, IfName AS IfName, Nodes.MachineType AS Machine_Type, Interfaces.InterfaceSpeed AS…
-
Hi, Such report is possible by using custom SWQL query, as NTA does not store its data in the SQL Database. SELECT TOP 100 FBIP.SourceIP, FBIP.Port, FBIP.DestinationIP, FBIP.IngressInterface.Index AS [Input Interface], FBIP.EgressInterface.Index AS [Output Interface] FROM Orion.NetFlow.FlowsByIP AS FBIP Apologies for not…
-
As far as I know, there isn't a way to change the self-signed certificate from the SWIS API service. Trying to install the cert on the application server would be a good point to start.
-
Hi, you can still create this report using the web-reporting engine: 1. Create new report, select "custom table" on the "add content" window 2. see screenshot below for selection method: 3.Select NodeID and Caption from the "Add Column" window, then navigate all the way down to "Response Time History" to add the…
-
Hello, There's a working example in this post Orion API via PHP about using PHP with the REST endpoint of SolarWinds Information Service (SWIS). There's a wiki here: Home · solarwinds/OrionSDK Wiki · GitHub with REST sample requests and responses too: REST · solarwinds/OrionSDK Wiki · GitHub Should give you a good start,…
-
Hello! Could you explain in more detail what are you trying to achieve? Retrieve records from SolarWinds and update fields in another application? the opposite? Is it one-way or two-way sync?
-
Hi, Something like that? SELECT NodeID, Caption, ChangeTimeZone(LastBoot,'+05:00') as LastBoot_5FROM Orion.Nodes There are some helpful examples here: Orion SWQL, Thwack! Now I got it Antonis Athanasiou Prosperon - UK SolarWinds Partners Installation | Consultancy | Training | Licenses
