The below is a Query that shows
Laptops than run Windows XP , without SP3 installed and KB893357 missing!
select distinct SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ("8","9","10","14") and SMS_G_System_OPERATING_SYSTEM.Caption like "Microsoft Windows XP%" and SMS_G_System_OPERATING_SYSTEM.CSDVersion != "Service Pack 3" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Update for Windows XP (KB893357)"
Of course you can amend queries to fit your need , just posted this one as a reference.
Subscribe to:
Post Comments (Atom)
Posts
If you have a plan and you use the information in this article, you should be able to sell your laptop fast. I needed to sell my laptop fast and I used this information to help me. business laptop 17 inch
ReplyDelete