-
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
-
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
-
Re: Polling Windows Server Service pack level
byronaMar 31, 2010 10:39 AM (in response to DaveStraley)
1 of 1 people found this helpfulI 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
-
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. :)
-
Re: Polling Windows Server Service pack level
byronaMar 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.
-
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.
-
Re: Polling Windows Server Service pack level
byronaMar 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>%'-
Re: Polling Windows Server Service pack level
byronaMar 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.
-
-
-
-
-
-
-