i_like_eggs · Just an egg · ✭✭✭✭✭

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…

HI.. You can probably do this so many different ways with view limitations, sql and Swql.. because i like the query route ill show you would you could do, or what i would do in this scenario First create an Alert custom property, i have one called 'ResponsibleTeam' then select the alert you want your customer to see,…

yo, quick question why are you looking for the same thing twice? try using the OR. there are some ncm compliance gurus that will pick this up no dought lol

you could try this: SWQL TILE QUERY SELECT v.Status, n.InstanceSiteId,np.n_type FROM Orion.Nodes (nolock=true) n INNER JOIN orion.volumes (nolock=true) as v on v.nodeid = n.nodeid INNER JOIN Orion.NodesCustomProperties (nolock=true) as np on np.nodeid = n.nodeid WHERE np.xxx = 'xxx' SWQL ASSET EXPLORER QUERY SELECT Status,…

thinking you could run SQL server component monitors against the other SQL database to return a static from the other orions database.. Then again might be worth writing something that will communicate over SWIS information service and just declaring the ip addresses when executing the script, I'm thinking this could be…

Yo, Do you need a report to show only nodes monitored by ICMP? Or is it a report that shows nodes that are monitored via WMI that has null CPU? Or a report to show nodes that have CPU, memory but is in an unknown state? cheers

Are you installing the EOC on the same box as the sql server? if not you will have to check that the firewalls TCP port 17777 open also the solarwinds servers will need 17777 open to both inbound and outbound traffic

njoylif​ thanks for that information i will propose the the first one to my manager and i cant help but want to know what the SQL looks like would you be kind enough to share?, i did think maybe create a CASE statement when one CP is X then change Y and so on. i am relevantly new to SQL but not backing down from it

I was trying this myself. you should be able to 'Edit Location' after manually placing the group on the map, i did notice that when using google chrome the longitude and latitude weren't saving. i then tired in Internet Explorer and work out ok..

This document should help Cutting Down On Alerting Noise: Guest Post From Support

You will find with SolarWinds. The data that is being polled by default for Error's and Discard's are the following OID's: Errors and DiscardsifInDiscards1.3.6.1.2.1.2.2.1.13Errors and DiscardsifInErrors1.3.6.1.2.1.2.2.1.14Errors and DiscardsifOutDiscards1.3.6.1.2.1.2.2.1.19Errors and…

You could check the account you are using to sync the front end to the back, the account might need additional access. This article gives you more information on the roles you need such as the 'sysadmin': Success Center​ unless you are using sa then you will have all the permissions.. 

HI mprobus​, i had this report that has helped me to find vm's that are missing from monitoring, hope this helps you REPORT ON VMS NOT MANAGED BY ORION

This Topology Calculator is what is looking up Layer 2 and Layer 3 topologies based on discovery protocol such as CDP and LLDP (L2). you can in fact check this information on the SQL Box you can see the Source Node, destination node and the link they use and what Layer type is used. select * from TopologyConnections You…