6 Replies Latest reply on Dec 18, 2013 9:44 AM by sotherls

Need help with audit of monitored devices

sotherls Dec 12, 2013 8:12 AM

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

Re: Need help with audit of monitored devices

bluefunelemental Dec 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.
Like Show 0 Likes(0)

Actions
- 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.
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Need help with audit of monitored devices
    
    bluefunelemental Dec 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
    
    Like Show 0 Likes(0)
    
    Actions
    - 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?
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: Need help with audit of monitored devices
        
        bluefunelemental Dec 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.
        
        Like Show 0 Likes(0)
        
        Actions
        
        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....
        
        Like Show 0 Likes(0)
        
        Actions

Go to original post