How to Check the Windows Update Agent Version on Clients

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

Daily activity related VBScripts from Myitforum

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

ALL SQL Queries

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

SCCM 2007 Intelligently about the product

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

Windows Deployment Services / RIS / OSD

Windows Deployment Services The Windows Automated Installation Kit (WAIK) contains an update for Windows Server 2003 Service Pack 1 (SP1) Remote Installation Services (RIS) servers that enables the new Windows Deployment Services technology that will be part of Longhorn server for the deployment of WIM images over the network. The update contains components similar to … Read more

SCCM 2007 / ConfigMgr Client Troubleshooter Tool Download

Introducing – the ConfigMgr Client Troubleshooter! If you attended Angie Stahl’s presentation at MMS, you caught a sneak peak of the ConfigMgr Client Troubleshooter. The troubleshooter is an html application, which makes it fairly portable, and all the code can be viewed using your favorite text editor. Use the troubleshooter to help you diagnose ConfigMgr … Read more

Sccm 2007 client agent deployment using Software updates

Sccm 2007 has a new client deployment method called Software update point based client installation. The idea behind Software update point based client installation is to publish the Sccm 2007 client as a critical update, and hence its name is installed from the Software update point. Most of you will probably now that Software Update … Read more

SCCM 2007 Fallback Status Point (FSP)

FunctionThe Fallback Status Point is a new Site System role in Configmgr 2007 that serves 2 purposes.The initial goal of the Fallback Status Point is to serve as a contact point for Configmgr 2007 clients in native security mode that cannot contact their Management Point because of certificate problems. As we will see in Chapter … Read more