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
sccm 2007
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 Client Count per AD Site
SELECT R.AD_Site_Name0, Count(SMS_Installed_Sites0) AS 'Count'From v_R_System R JOIN v_RA_System_SMSInstalledSites SIS ON R.ResourceID = SIS.ResourceIDGroup By R.AD_Site_Name0
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
SCCM SQL Query : Sql query for machines joined after a date
select distinct * from v_R_System where Creation_Date0 > '2014-12-01 06:22:10.000' and Resource_Domain_OR_Workgr0 = 'domainname' and Obsolete0 not like 1