SCCM 2007

VBSCRIPT Initiate the software updates cycle

by

  VBScript to Initiate the software updates cycle         ' Set the required variables.     actionNameToRun = "Software Updates Assignments Evaluation Cycle"     ' Create a CPAppletMgr instance.    Dim oCPAppletMgr    Set oCPAppletMgr = CreateObject("CPApplet.CPAppletMgr")     ' Get the available ClientActions object.    Dim oClientActions    Set oClientActions = oCPAppletMgr.GetClientActions()     ' Loop through the available … Read more

How to Check the Windows Update Agent Version on Clients

by

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

by

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

by

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

Retrieve Machines IP Address, Default Gateway And MAC Address

by

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

SCCM 2007 Intelligently about the product

by

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

by

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