This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Need help with audit of monitored devices

sotherls over 10 years ago

I am reaching out to the Thwack community for help. I need to audit our servers to see if they are properly being monitored and by this I mean what is checked (against what isn't checked). For example, under the Nodes/Default.aspx page it lists all of the nodes. When I click on the '+' key it expands and shows what Orion says it is being collected (with the exception of Topology or Hardware Health). I want to see if anyone has an idea on how I can develop a report (outside of Orion) on this. Node, Node status, Health (if checked or an option), Topology (if checked or an option), Physical, Virtual, All volumes, Volume statuses I know I can do this one server at a time but I figured the data MUST be in the database somewhere. Also, I see from time to time a volume will be 'orphaned'. By that I mean it shows up in the list but when you do a List Resources you see that the volume has a different serial number (label). Can this be identified? Thoughts, ideas? NPM 10.3.1

0 bluefunelemental over 10 years ago

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.
Cancel
Vote Up 0 Vote Down

Cancel
0 sotherls over 10 years ago in reply to bluefunelemental

Sorry, just saw your reply. I can't PM you as your email is private.
Cancel
Vote Up 0 Vote Down

Cancel
0 bluefunelemental over 10 years ago in reply to sotherls

Just sent a friend request but I'm not sure us kitesurfers are allowed to befriend windsurfers
Cancel
Vote Up 0 Vote Down

Cancel
0 sotherls over 10 years ago in reply to bluefunelemental

Hey don't hate! As long as we are movin gon the water - right?
Cancel
Vote Up 0 Vote Down

Cancel
0 bluefunelemental over 10 years ago in reply 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.
Cancel
Vote Up 0 Vote Down

Cancel
0 sotherls over 10 years ago in reply 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....
Cancel
Vote Up 0 Vote Down

Cancel