8 Replies Latest reply on Mar 31, 2010 4:52 PM by byrona

Polling Windows Server Service pack level

DaveStraley Mar 26, 2010 4:30 PM

We have about 800 servers in our infistructor and they are currently being monitored by Orion NPM and APM. What I would like is a way to poll the servers to find what Service Pack level they are running. Either a custom report or even better for it to be displayed in the Node details page. This would also be usefull for our Sys admins to find out what SP level our SQL servers are at. Any help on this would be greatly appreciated.

On a side note our Windows Server 2008 R2 boxes are showing up as "NT servers" Is this not in the Orion DB yet?

Cheers

Re: Polling Windows Server Service pack level

MarieB Mar 30, 2010 12:05 PM (in response to DaveStraley)

Hi Dave--
If I understand what you are saying, it looks like you will have to locate the OID for the Service Pack number for all the types of servers you are polling. Then you can build a customer poller to poll the servers. Is this what you are trying to do?
For the Windows Server R2 issue, this is known issue that Orion 9.5.1 shows Windows 2008 R2 as Windows NT. Development is working on fixing this for the next If you're curious as to what we're working on....
M
Like Show 0 Likes(0)

Actions
- Re: Polling Windows Server Service pack level
  
  DaveStraley Mar 31, 2010 10:19 AM (in response to MarieB)
  
  Either a custom poller or if its something that Orion grabs anyway and is located somewhere in the DB that would be good too. It would just be nice to have a report saying which servers are at Windows 2003 SP2 or Windows 203 SP1. Same with Microsoft SQL 2005/2008.
  
  Cheers
  Dave
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Polling Windows Server Service pack level
    
    byrona Mar 31, 2010 10:39 AM (in response to DaveStraley)
    
    I just uploaded one of my UnDP templates that I use to poll installed software. Once you do this you will have a list of all installed software packages for each system stored in your database. This allows you to run queries against specific packages.
    Unfortunately I am not very good at SQL so I can't help much with the query part but this should help get you part of the way there.
    Hope this helps...
    Installed Software Poller
    Installed Software Poller
    1 of 1 people found this helpful
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: Polling Windows Server Service pack level
      
      DaveStraley Mar 31, 2010 1:46 PM (in response to byrona)
      
      Awesome poller by the way. Little more info than what I was looking for but something I can work with for the time being. What I was hoping for was something that just said "windows 2003 SP1" or "Windows 2000 SP4". Guess I was hoping for too much. :)
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: Polling Windows Server Service pack level
        
        byrona Mar 31, 2010 2:32 PM (in response to DaveStraley)
        
        Thanks! I just created it yesterday to try and solve some software tracking issues.
        I realize it wasn't exactly what you were looking for but I figured something was better than nothing. If you have APM you may be able to write a script that collects the service pack information via WMI.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Polling Windows Server Service pack level
        
        DaveStraley Mar 31, 2010 2:50 PM (in response to byrona)
        
        We do have APM, but we just got it so I have not had much chance to play around with the custom setups for it. We have Orion APM and NTA.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Polling Windows Server Service pack level
        
        byrona Mar 31, 2010 4:42 PM (in response to DaveStraley)
        
        Here is the SQL query to isolate a list of systems with a specific application name. Just replace <Application Name> with the name of the application you want to search for on all of your systems and replace <Custom Poller ID> with the Poller ID of the custom poller that you created.
        SELECT Nodes.Caption, CustomPollerAssignment.AssignmentName, CustomPollerStatus.Status
        FROM Nodes Inner Join CustomPollerAssignment ON Nodes.NodeID = CustomPollerAssignment.NodeID
        Inner Join CustomPollerStatus ON CustomPollerStatus.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID
        WHERE CustomPollerAssignment.CustomPollerID = '<Custom Poller ID>'
        AND CustomPollerStatus.Status LIKE '%<Application Name>%'
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Polling Windows Server Service pack level
        
        byrona Mar 31, 2010 4:52 PM (in response to byrona)
        
        Ok, had to make a modification to the post to be accurate. You can get the Custom Poller ID by looking in the CustomPollers table in the database.
        
        Like Show 0 Likes(0)
        
        Actions

Go to original post