Create collection with all Windows XP SP 1-2-3 systems

To create a collection with all Windows XP SP1 systems, use the query bellow: select 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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption like "%Windows XP%" and SMS_G_System_OPERATING_SYSTEM.CSDVersion = "Service Pack 1" Similarly, to create a collection with all Windows XP SP2 systems, just change the Service Pack version number: select … Continue reading Create collection with all Windows XP SP 1-2-3 systems

How to create a Windows XP SP3 Target Computer in Configuration Manager 2007 SP1 R2

This post assumes you have created a reference computer and captured an image of it as described in the previous post. Import and configure a task sequence to deploy the target computer After the task sequence to deploy the reference computer (Home-XPSP3-Ref01) finishes, a captured image of the reference computer is stored in \Home-SCCMCaptures$Home-XPSP3-Ref01.wim. Now, … Continue reading How to create a Windows XP SP3 Target Computer in Configuration Manager 2007 SP1 R2

How to create a Windows XP SP3 Reference Machine using Configuration Manager 2007 SP1 R2

In this post, I will show how to deploy Windows XP SP3 (the easiest and least customizable way) in a virtual environment (Virtual PC 2005 SP1) step-by-step. This post is inspired from “Quick Start Guide for Microsoft System Center Configuration Manager 2007” document. In this post, I will create a reference machine with Windows XP … Continue reading How to create a Windows XP SP3 Reference Machine using Configuration Manager 2007 SP1 R2

All .mp3 files on Desktop and My Documents folder

Want to know if your users store mp3 files on Desktop or My Documents folders? Add .mp3 file type to Software Inventory Client Agent properties Navigate to Site Database – Site Management – Site Name – Site Settings – Client Agents and double click Software Inventory Client Agent Select Inventory Collection tab Click the new … Continue reading All .mp3 files on Desktop and My Documents folder