ConfigMgr : OSD : How To Create a Bootable USB Windows 7 Build Disk

Prerequisites The following are required to build the Windows 7 USB Media: Windows 7 Machine USB Removable Drive   Step by Step: How to prepare the USB The USB device must be prepared prior to generate the stand alone media. On a Windows 7 PC, Insert the USB device and launch the command line in … Continue reading ConfigMgr : OSD : How To Create a Bootable USB Windows 7 Build Disk

Advertisements

ConfigMgr : Creating queries, collections and reports for Window Server 2008 Core in System Center Configuration Manager 2007

System Center Configuration Manager 2007 SP2 allows client installation on Windows Server 2008 Core systems* but it does not differentiate between Windows Server 2008 and Windows Server 2008 Core machines in either queries, collections or reports. * Configuration Manager 2007 SP2 Supported Configurations: http://technet.microsoft.com/en-us/library/ee344146.aspx To determine which SKU a particular machine is running, you can use … Continue reading ConfigMgr : Creating queries, collections and reports for Window Server 2008 Core in System Center Configuration Manager 2007

ConfigMgr : OSD : Build failure Troubleshooting and Logs gathering

During the Build process if you encounter any issues you can perform further investigation with the below mandatory information Machine model Error code with snapshot Error stage with snapshot (may be hiding behind the Task Sequence error window) Single system failure OR multiple systems failures Build Failure Logs (as described below) Mention if any HW component … Continue reading ConfigMgr : OSD : Build failure Troubleshooting and Logs gathering

ConfigMgr Guide : Holistic Standardization and Fine Tuning

This is one guide that will take your SCCM skills and environment to a whole new level ! This would give you good insight into your infra and also let you understand how the enterprise class Microsoft Suite is behaving under the hood. The guide has also been implemented in several real world production environments … Continue reading ConfigMgr Guide : Holistic Standardization and Fine Tuning

SCCM Troubleshooting : Ironing out Patching for ConfigMgr 2007 (upto 95% compliance)

This guide will take you through troubleshooting guides, tips, tricks and tools to achieve 95%+ compliance in your environment and maximum coverage. The guide assumes the following environmental conditions:   Microsoft System Center Configuration Manager 2007 R3 WSUS 3.0 SP2 used as base for Software Updates Windows Client endpoints Three tier SCCM hierarchy   - … Continue reading SCCM Troubleshooting : Ironing out Patching for ConfigMgr 2007 (upto 95% compliance)

SCCM SQL Query : SQL Query for Locations and Boundaries

Download SQL Query   The Query : select sys1.Name, sys1.DefaultSiteCode, (select SUBSTRING(sys2.ServerNALPath, CHARINDEX('\\', sys2.ServerNALPath) + 2, CHARINDEX('"]', sys2.ServerNALPath) - CHARINDEX('\\', sys2.ServerNALPath) - 3 ) + CASE sys2.Flags WHEN '1' Then ' (Slow)' WHEN '0' THEN '' END + '; ' as 'data()' from vSMS_BoundaryGroupSiteSystems as sys2 where sys1.GroupID=sys2.GroupID for XML path('')) as 'Site System', (select … Continue reading SCCM SQL Query : SQL Query for Locations and Boundaries

SCCM SQL Query : Find Lync Versions

select  distinct v_R_System.User_Name0,v_r_system.Name0,v_R_System.Active0,v_Add_Remove_Programs.DisplayName0,v_Add_Remove_Programs.TimeStamp,v_Add_Remove_Programs.InstallDate0,v_Add_Remove_Programs.Version0from v_Add_Remove_Programsinner join v_R_System on v_Add_Remove_Programs.ResourceID = v_R_System.ResourceIDwhere v_Add_Remove_Programs.DisplayName0 like 'Microsoft Lync 2010'

SCCM SQL Query : Computers with Pending Restart or other Update Enforcement States

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_UpdateComplianceStatus ON SMS_UpdateComplianceStatus.machineid=sms_r_system.resourceid WHERE SMS_UpdateComplianceStatus.LastEnforcementMessageID = 9There are several other enforcement states you can use instead by changing the number after ‘LastEnforcementMessage ID =’ at the end of the query.1 – Enforcement started3 – Waiting for another installation to complete6 – General failure8 – … Continue reading SCCM SQL Query : Computers with Pending Restart or other Update Enforcement States