Determine Server Placement for Internet-Based Client Management – IBC

by

All server placement references below refer to a primary site only; secondary sites do not support Internet-based client management. Server Placement for Sites that Do Not Need to Also Manage Intranet Client If the Configuration Manager 2007 site does not need to support both Internet clients and intranet clients, Scenarios 1 and 2 in the … Read more

SQL Tutorial – SELECT Statement

by

SQL Tutorial SELECT Statement — Extended Query Capabilities This subsection details the remaining features of SELECT statements. The basics are at SELECT Statement Basics. The extended features are grouped as follows: Sorting Query Results — using the ORDER BY clause Expressions — in the SELECT clause and WHERE clause Literal — self-defining values Function Call … Read more

Free Training on Wise Packaging

by

https://www.appdeploy.com/video/index.asp   AppDeploy Training Videos provide point and click instructions to describe and illustrate Windows Installer, application deployment and other desktop administration topics. New AppDeploy Webinar Now Available! The latest in a series of AppDeploy webinars is now available on-demand. The topic is “Windows Vista SP1 for Administrators” and it covers Windows Vista adoption, mitigation … Read more

1E Free Tools – SMS / ConfigMgr 2007

by

Program Clone Wizard The Program Clone Wizard is an MMC snap-in for the Administrator Console. It extends the right mouse click menu for a single SMS/ConfigMgr Program allowing you to run a simple wizard which duplicates the Program and sets it to run using Nomad Enterprise. Date: 16 Aug 2006   Size: 234 Kb Program Clone … Read more

1E Free Tools for ConfigMgr 2007

by

ConfigMgr tools Advanced Task Sequence Environment Tool The TSEnv2.exe is a command line tool that lets administrators manipulate the Microsoft 2007 task sequence environment. It allows them to get, set, list and dump all variables within the OSD Task Sequence environment. This tool also allows changes to ‘read only’ variables that cannot be changed with … Read more

MMS 2011 SPONSORS & EXHIBITORS

by

MMS 2011 SPONSORS & EXHIBITORS We would like to thank the following sponsors and exhibitors for their part in making MMS 2011 a success. Table of Contents Platinum Sponsors Dell develops and delivers a comprehensive portfolio of IT services and solutions that reduce IT complexity and lower costs. We take a holistic view of each … Read more

Patching Related End to end – Collections and reports :-

by

Below is for a compliance report based on SQL declare @CollectID AS  varchar(8)SET @CollectID= ‘SMS0001’ declare @CollectionListID AS  varchar(90)SET @CollectionListID=’ScopeId_5432f432-F885-4A98-B666-5432134122/AuthList_F15C63EA-B655-4940-A250-654323fd432′ declare @CI_ID int; select @CI_ID=CI_ID from v_ConfigurationItems where CIType_ID=9 and CI_UniqueID=@CollectionListID declare @CollCount int, @NumClients int; select @CollCount = count(*), @NumClients=isnull(sum(cast(IsClient as int)), 0) from v_ClientCollectionMembers ccm where ccm.CollectionID=@CollectID select     CollectionName=vc.Name,    ‘Update List’=al.Title,    Status=sn.StateName,    … Read more