SCCM

Preload Package Tool for Configuration Manager 2007

by

https://download.microsoft.com/download/d/e/d/ded78c6e-59a4-43ee-b601-6527be7bd881/PreloadPkgOnSite.exe  Overview The Preload Package Tool (PreloadPkgOnSite.exe) is used to manually install compressed copies of software distribution package source files on Configuration Manager 2007 sites. After package source files are installed, a status message is sent up the site hierarchy indicating the presence of the new package source files. This avoids sites higher in the … Read more

How To Check If A BITS Enabled Distribution Point Is Up And Running like how we check MP

by

To check if a Management Point is up and running we have the mplist and mpcert http URLs that we can open in Internet Explorer.  We don’t have such URLs to test if a Distribution Point (DP) is up. Management Point and Distribution Point servers are very different roles.  The Management Point is a conduit … Read more

During OSD, format first partition only

by

Our helpdesk asked me to make a task sequence that can be used on computers with more than one partition. In this case, I had to make sure that the operating system will install only on first partition and will not touch the data on other partitions. To achieve this, I copied another TS and … Read more

Upgrade Configuration Manager client from SMS 2003

by

Create a report that counts all client versions. (This is optional, just for information purposes). Report query is: SELECT TOP (100) PERCENT Client_Version0 AS [ConfigMgr client version], COUNT(Client_Version0) AS Total FROM dbo.v_R_System GROUP BY Client_Version0, Client0 HAVING (Client0 = 1) ORDER BY Total DESC, [ConfigMgr client version] Create a collection (“Older Clients” for example) with … Read more

Deploy Office 2007 SP2 with ConfigMgr 2007

by

As Microsoft recently released Service Pack 2 for Office 2007 suite, it is a good idea to add the update files to the package so it it can be deploy during the installation. So, first of all we have to download the SP2 executable file from here: https://www.microsoft.com/downloads/details.aspx?FamilyID=b444bf18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en (see additional information bellow). Then, using a … Read more

Create a collection with systems without Adobe Reader 9

by

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_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion not like “%Server%” and SMS_G_System_COMPUTER_SYSTEM.Name not in (select distinct SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “%Adobe Reader 9%”)