May 30, 2007 at 10:39 pm
How do I list all processes running &/or operating system patches being applied, changes in Anti-virus settings etc on the server using query analyser in SQL Server 2000?
June 1, 2007 at 9:51 am
You know, I really hate IE for eating posts!
Anyway, second try at a reply. I don't think that what you want to do is an easy task. You want to inspect parts of the operating system from an application level, and I don't think that information is entirely available. This is especially true with the anti-virus info as no two vendors are going to have it available in the same way.
I think that if you had SQL 2005 that you might be able to do it through CLR, but I really don't know anything about CLR programming and what it can read at the OS level.
You might be able to get service pack/patch info on the server. In the Windows directory, every patch creates an uninstall directory named $NtUninstallKB810217$ or something like it, you might be able to read that directory through an extended stored procedure. The KB# portion refers to the Microsoft Knowledge Base article that the patch applies to. Of course, if the system admins deleted these directories, then your task just got a lot harder.
Good luck! I hope that someone else might post something more helpful.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
June 3, 2007 at 9:54 pm
This sounds more like an OS-level issue, not a SQL Server issue. There are two products you could try, might shed some light on things:
Belarc Advisor http://www.belarc.com/free_download.html can show all the installed software, patches, product keys etc. very useful.
Microsoft's Sysinternals http://www.microsoft.com/technet/sysinternals/default.mspx especially the Process Explorer which gives much more detail than Task Manager.
Hope that helps.
June 4, 2007 at 5:29 am
the sqldiag utility will certainly give you info on OS patch levels
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply