SMS 2.0 Query DST Patches?

[viziony]

Hi Guys,

Just wondering how I would running a query that would tell me if the DST Patch was installed on all the Windows XP machines here in the office?

KB931836 and KB933360

Basically my question is, how do I create a query that will find hotfixes and patches from Microsoft?

 

[viziony]

I am just wondering if i can find machines w/o the name "tzchange.exe" to verify if there are systems within our company w/o the dst patch.

Answer :

I used the canned query called "Filename Query"



Here is the code for the query :

select distinct sys.Name, sys.SMSAssignedSites, sys.OperatingSystemNameandVersion, sys.ResourceDomainORWorkgroup, sys.LastLogonUserName, sys.IPAddresses, sys.IPSubnets, sys.ResourceId, sys.ResourceType, sys.AgentTime from SMS_G_System_SoftwareFile as swfile inner join SMS_R_System as sys on sys.ResourceId = swfile.ResourceID where swfile.FileName = ##PRM:SMS_G_System_SoftwareFile.FileName##

 

[viziony]

I guess I really didn't answer myself.

I would like to query the systems w/o the TzChange.exe file within windows/system32 directory. How would I go about doing that? Which objects and criterias would I select?

 

[tbrennans]

it would be a sub-select query/collection, here is a good article on it

http://www.myitforum.com/articles/1/view.asp?id=179