to find out linked report ID in all reports
SELECT TOP (100) PERCENT ReportID, Name, Category, DrillThroughReportID FROM dbo.v_Report WHERE (NOT (DrillThroughReportID IS NULL)) ORDER BY ReportID
Upgrade Configuration Manager client from SMS 2003
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
How to create a Windows Image (.wim) file
Method one:- With SCCM build and capture Method two : WDS capture Wizard method three: details steps are below Depending on what you need the .wim file for, you can create it manually or automatically. – To manually create a .wim file (capture image) you need a bootable CD with Windows PE (with ImageX.exe included) … Read more
Deploy Office 2007 SP2 with ConfigMgr 2007
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
Install drivers by computer model using WMI query
When using task sequence, you might want to install different driver packages for different computer models. This can be accomplished by using a WMI query. First of all you need to have driver packages for all your computer models and know the exact model name for every computer. To find this, open a command prompt … Read more
Create a collection with systems without Adobe Reader 9
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%”)
Install software using Task Sequence
The TS Looks like this… to install software using a TS, is to have only Install Software steps. This way, you can install multiple software products using one advertisement instead of advertising every package. I use this only when I have an OS installed and I want to install software on it. This is how … Read more
Windows Installer : MSIEXEC Silent Install End to END
The Windows Installer technology uses Msiexec.exe for installing MSI and MSP packages. This tool gives you full control over the installation process, allowing you to set: install options (install, uninstall, administrative install, advertise a product) display options (full, basic or no UI during the installation) restart options (if the machine will be restarted after the … Read more
Before You Begin patching the
Before You Begin/ready for patching Always read the Release Notes for the patch you are about to install. The Release Notes usually contain information on known issues with the patch and specific procedures on how to install them.
Online resources for SCCM training
Online hosted virtual machines : https://www.microsoft.com/systemcenter/configurationmanager/en/us/virtual-labs.aspx Downloadable VHD of with sccm 2007 R2 installed. https://www.microsoft.com/downloads/details.aspx?familyid=E0FADAB7-0620-481D-A8B6-070001727C56&displaylang=en