i_like_eggs · Just an egg · ✭✭✭✭✭

HI, familyofcrowes​ xtraspecialj​ did you manage to find anything more on this? i am about to open a support case because i am getting slimier issues. cheers, Dan

IPAM dosent seem to hold the information you are looking for, the information is on the nodes you can in fact with SQL poll the data from the nodes if they have serial numbers and join onto IPAM records by IP address although this is not the best way to do things but can be done, or there maybe another way that i dont know…

excellent work friend

nice job philip.robinson​. you could also look at this from another perspective and create a resource that will act as a timer, something like node will re manged in 30 days or will be un-muted in 30 days or 7 days,could also have an informational email based on the query to informer number of devices that will re manged…

HI Orion, please paste the following Query to search for the Volume types were can filter by to show in the report: select distinct volumetype,VolumeTypeID from volumes output: paste back here lets see what we can do.

thank you for downloading it looks like you dont have the custom property 'customer' what i have done is removed the column name 'n_customer' so you will get something like this: i have attached the file for you named Volumesummaryreportnocustomer.xml

Thank you for pointing that out i have updated the screenshots now Missed the section 'Transfer status' you are correct selecting the trasfer status. Would be hella useful if it would just pop up when Show commands are executed. yea the outputs not formatted i hope this is something SolarWinds will make neat in the future…

hehe your welcome

hey, apologizes for the delay try this out, here's what your looking for: Select o.Caption AS [NODE], o.detailsurl as [_linkfor_NODE], o.IOSVersion, Serial, o.machinetype FROM Cirrus.Nodes n INNER JOIN Cirrus.EntityPhysical s ON n.nodeid = s.nodeid INNER JOIN Orion.Nodes o ON o.nodeid = n.corenodeid WHERE EntityClass IN…

Hey, the information in this table is being polled from the ncm job inventory. Do you have serial numbers on custom properties or are you after serial numbers of servers etc?

lol you could also break the events down into the event types looks cool as an stacked graph Here is the code: select convert(date,e.EventTime) ,Sum(case when e.NetObjectType = 'N' then 1 ELSE 0 END) AS [Node] ,Sum(case when e.netobjecttype = 'V' then 1 ELSE 0 END) AS [Volume] ,Sum(case when e.NetObjectType = 'I' then 1…

Hey, Heres a graph for ncm status. tweeking the code slightly might also be useful for your view select Convert(date,nc.LastInventory) AS [Date] ,sum(case when nc.LoginStatus like 'Connection Refused by%' then 1 else 0 END) AS [Connections Refrused] ,sum(case when nc.LoginStatus like 'Connectivity issues, %'then 1 else 0…

The first section of this is using a Custom Query resource - SWQL The second is using Custom charts SQL as a data series, it would be useful to know the grouping used in the charts i always have problems with grouping or could be a Component monitor using Custom object charts with the SAM module running SQL user…

A-A-A-Awesome

ohhhhhwqwklndvndflvs.. once i finish this LLD im installing that badboy... can i install straight from EOC 2.0? thank you

YOU DA MAN!

HI Guys, any idea when 2.1 will be available? 

yo, thanks for the prompt response it just seems that the swql queries custom query resources wont take the query but will give me the headers without the query. the input the output it seems to work for custom table using the same query is there a preferred syntax like the asset explorer ?

very helpful information. although, can you run Custom Query resources in the EOC v2 to retrieve SWQL outputs and then use the 'search' function? 

Sup, I have a question regarding this my poller checker mine must be a few years old now and i haven't actually updated it so brings a few questions how does the poller checker maintain itself lol. so MIBs changing so how do i make sure the poller checker is up-to-date. now i thought about it dose the poller check use the…

HI, thank you for the report done some tweeking to only pull the last 7 days and filter by a custom property value needed something to get downtime for interface. good starting point two thumbs up SELECT * FROM ( SELECT Nodes.StatusLED, Nodes.Caption, Nodes.NodeID, StartTime.Message, --added convert so i can group by days…

my pleasure that did cross my mind.. perhaps if i re-versed the logic and polled from ncm_nodes then the nodes table then made the joins... na that wouldn't work... Because the query is checking for null values from the nodes table and ncm_nodes table and based on ncm nodeid it would return a value based on any vendor and…

when you start i can help out

Hey, you basically need to create a SQL server agent job, create 3 custom properties and the SQL job will update the custom properties on a specified node then, using the NetAtles drag the node that is updating the custom properties from the SQL job place it on the map then your pretty much done. its a little fiddly not…

nice job, i used this concept for a customer

hey, would you be able to post your output from these queries? i wonder if its 'description' select * from NPM_VRFs where NodeID = '378' select * from NPM_VRFInterfaces_View where NodeID = '378'

hehe. that is the best time nice and early Sunday morning 'SQL Sundays' , i managed to watch Chelsea in the afternoon which we dont have to talk about lol. i re uploaded a new script with the vrf.Name just below.. SELECT NPM_RoutingNeighbor_V.NodeID ,'Down.gif' AS 'ICON-STAT' ,NPM_RoutingNeighbor_V.NeighborID…

Hey, greg.remer​ Some light Sunday morning coding lol.. unfortunately i dont have any VRF information but could you try this? id be curious to know the output SELECT NPM_RoutingNeighbor_V.NodeID ,'Down.gif' AS 'ICON-STAT' ,NPM_RoutingNeighbor_V.NeighborID ,Nodes.Caption AS 'NODE' ,Nodes.IP_Address AS 'IP'…

That’s that theory out the window lol. but I’d be curious to know of these cases '800495, 806580, 767988, 785976' which were resolved off the back of the upgrade and if any experiences problems after? Maybe check the Database and see if this node is still orphaned in the database? This would be an additional step to take…

HI sja​ This sounds slimier to something i experience i am on NPM 11.5.2, when i delete an interface or Volume i still get alerts for that interface or Volume which is odd. by the looks of it this is a bug that is 'Fixed' in NPM 11.5.3 (which i have not upgraded to just yet) Here are the NPM 11.5.3 release notes NPM 11.5.3…