Setup Prerequisite Checks The Configuration Manager 2007 setup prerequisite check helps you determine what you have to do in order to prepare your environment to install or upgrade a Configuration Manager 2007 primary site, secondary site, or Configuration Manager console. The prerequisite checker notifies you of any warnings or errors … Read more
Setup Prerequisite Checks The Configuration Manager 2007 setup prerequisite check helps you determine what you have to do in order to prepare your environment to install or upgrade a Configuration Manager 2007 primary site, secondary site, or Configuration Manager console. The prerequisite checker notifies you of any warnings or errors … Read more
How to Move the SMS Provider The SMS Provider is a component of Configuration Manager 2007 primary sites and is used by Configuration Manager consoles to access site database information from the SQL Server hosting the site database. The SMS Provider is a dynamic-link library file (smsprov.dll) and is installed or moved by running Configuration Manager … Read more
To display the WUA version on client computers using a SQL query Create a query statement that retrieves client computers and the Windows Update Agent version, such as the following sample query statement: SELECT v_R_System.Netbios_Name0, v_GS_WINDOWSUPDATEAGENTVERSIO.Version0 FROM v_GS_WINDOWSUPDATEAGENTVERSIO INNER JOIN v_R_System ON v_GS_WINDOWSUPDATEAGENTVERSIO.ResourceID = v_R_System.ResourceID WHERE v_GS_WINDOWSUPDATEAGENTVERSIO.Version0 <> 'ISNULL' ORDER BY v_GS_WINDOWSUPDATEAGENTVERSIO.Version0 To verify the … Read more
VBS Script To Ping A Remote Machine Until The Command Window Is Closed. 3 VBS Script To Ping A Remote Machine Until The Command Window Is Closed Here you will find a VBS script that will allow you to ping a remote machine continuously (Ping –t) until you close the command window. The script can … Read more
SQL Query To Retrieve Advanced Clients Assigned Site Code And Client Version This SQL Query will allow you to list the assigned site code and client version numbers for your advanced client resources. SQL Query: Select SD.Name0 'Machine Name', SC.SMS_Assigned_Sites0 'Assigned Site', SD.Client_Version0 Version From v_R_System SD Join v_RA_System_SmsAssignedSites SC on … Read more
SQL Query To Retrieve Machines IP Address, Default Gateway And MAC Address To retrieve the IP address; Default Gateway and the Mac address for your SMS discovered resources. This query has added logic that will enable you to filter out those machines that do not have a specified Default Gateway set as well as those … Read more
Welcome to an era of technology where a single application can manage your entire organizations infrastructure. Whether your organization is based on a single campus or distributed throughout the world, System Center Configuration Manager (SCCM) 2007 has the mechanics to provide your company with the tools needed to distribute software, operating systems, security updates, collect … Read more
I) New Features1. Desired configuration management The ability to define granular computer configurations within your organization and compare and report compliance or noncompliance among your managed computers2. Network Access Protection (NAP) for Configuration Manager The ability to leverage Windows Server NAP to identify and remediate managed clients using Configuration Management features such as software updates3. … Read more
