Shanmuga · Lead Engineer · ✭✭✭

Here I am requesting to pull the cpu and memory components for the routers and switches from SolarWinds web console report and database table.

Can someone assist please?

Thanks. So they have to fetch the as polled data for one interface and calculate it with utilization in % and use it to their dashbaord? by this way they can get 288 rows for 24 hours data for one interface. Is this ithe only possible way ? I noticed utilization % field in the other table why the product not created such…

I dont want to change to snmp status let it be icmp status. but I need to pull the list of nodes with snmp failing from solarwinds. Please assist any method that I will try. Thanks.

My requirement is to pull the list of devices from SolarWinds which are SNMP connection lost only. I ran the above query output with that node is it has Status as 1 Object subtype as SNMP so it gives worng result that the device is responding with snmp but actually not.

Hi Daran, I verified for that node and it has the ObjectSubType as SNMP and Last Sync as last polled but the device is not responding with SNMP now so this query doesnt satisfy the requirement. When I open the node in the solarwinds GUI and click List resources it says "us-dal-corp-lxcn02.dtcc.com is currently down,…

Thanks. I will try to understand the query and run it so cant we able to get the list from the webconsole.? Also I dont want to change it across 1000 of devices let it be icmp but any possibility to differentiate the icmp status and snmp status of a device in the webconsole I tried the report you mentioned earlier but…

There is a case where one of the device still shows Green and polling method as SNMP under Managed nodes but actually the node lost its snmp connection to the tool so in this case polling method not showing correct result. so please need another way to find out. 

It has the timestamp but with polled timestamp . Even I raised the techsupport case but still awaiting response. 

I verified the table you refered but it doesnt have the timestamp.

They have their SAS tool(external system) where they need to fetch the bps in/out , util % in/out , timestamp, for the specified interface for 24 hours so what tables they need to refer to fetch the data for specified fields. fetching the data from the below table where we dont see the utilization % so we need to know how…

Thanks Daran. So the above listed are views correct? I don't see the tables associated to the view for the utilization so in this case we need to go for the views instead of the table. I checked the utilization view but it doesn't have the timestamp field? They need the utilization % for each interface of each device with…

Hi, Capacity team needs to fetch the interface utilization in % for all the network devices as they will write the code in their tool. They need to pull the utilization % for an interface so we gave this table - [SolarWindsOrion].[dbo].[InterfaceTraffic_CS_cur] but we dont see the util % so the question is in the orion…