Generate a report for All Computers with Windows XP Service Pack 1 installed
Hi All, I am a newbie to SCCM and trying to generate a report of all machines that have:- Windows XP Service Pack 1 installed on themCan someone please guide me as to how i set this report up and what the SQL would need to look like for this to work?I tried to set up a report before but had no idea on what i was doing and didnt get too far in the report wizard.Thanks all
December 8th, 2009 7:40am

Hi, Try to use this query: select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceId, SMS_R_System.NetbiosName from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion like "%Workstation 5.1.2600 serice pack 1 build 2600"
Free Windows Admin Tool Kit Click here and download it now
December 8th, 2009 12:03pm

Try the report "Count operating systems and service packs"you can then click on Sp1 machines and see who has it. This will run the "Computers with a specific operating system and service pack" report.http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com
December 8th, 2009 4:47pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics