-
Re: Need help with audit of monitored devices
bluefunelementalDec 12, 2013 11:25 PM (in response to sotherls)
sounds like this will be a large sql join report or several smaller ones. - either way start smaller and combine as you validate them.
I would think a left outer join of nodes and each of the tables you want, interface, apm_hardwareinfo,etc where the right table column is null would work. I did something for your orphan volume issue based on apm component last poll date- pm me for details.
-
Re: Need help with audit of monitored devices
sotherls Dec 18, 2013 9:06 AM (in response to bluefunelemental)Sorry, just saw your reply. I can't PM you as your email is private.
-
Re: Need help with audit of monitored devices
bluefunelementalDec 18, 2013 9:28 AM (in response to sotherls)
Just sent a friend request but I'm not sure us kitesurfers are allowed to befriend windsurfers
-
Re: Need help with audit of monitored devices
sotherls Dec 18, 2013 9:31 AM (in response to bluefunelemental)Hey don't hate! As long as we are movin gon the water - right?
-
Re: Need help with audit of monitored devices
bluefunelementalDec 18, 2013 9:37 AM (in response to sotherls)
I don't look down at windsurfers at all… well technically from 20ft up I have to look down.
Truth is we don't get enough wind in the Chesapeake Bay for as much windsurfing - most all had to switch to keep moving on the water.
-
Re: Need help with audit of monitored devices
sotherls Dec 18, 2013 9:44 AM (in response to bluefunelemental)Heard that. It is all good. Never got the nerve up to take up the kite thing. Looks fun though. You would get a lot of time on the water here in Florida. Water is a little chilly right now but certainly warner than there.
So share what you have learned oh great one....
-
-
-
-
-