Create a collection with all x64 systems

As I have some free time, I’m testing different things with SCCM, mainly in creating different collections that I might need. Bellow you can find the query that will show you all x64 systems, client and server operating systems. 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 … Continue reading Create a collection with all x64 systems

Create a collection with all mobile (laptops, notebooks, portable) systems

Someone just asked how to create a collection with all laptop computers? Well, if there is a good naming convention on site, this query will be easy to make. But, otherwise, we need to use chassis type value because, for example, laptops and notebooks are not the same things according to Microsoft. The full list … Continue reading Create a collection with all mobile (laptops, notebooks, portable) systems

Troubleshooting Task Sequences in SCCM

I don’t do this usually, but this time this is really interesting. I want to recommend a very good blog post written by Kenneth Van Surksum about troubleshooting Task Sequences in Configuration Manager. Find it here http://www.techlog.org/archive/2009/03/01/troubleshooting_task_sequences. He talks about the smsts.log file, where to find it during installation and what tool you can use … Continue reading Troubleshooting Task Sequences in SCCM

Create a collection with systems without Adobe Reader 9

Recently, I needed a collection with all computers that do not have Adobe Reader 9 installed. I created a collection with this query: SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "%Adobe Reader 9%". Everything was fine except the fact that my computer was also listed, despite the fact that I have Adobe Reader 9 installed. Well, I’m not an … Continue reading Create a collection with systems without Adobe Reader 9

Setup Windows and ConfigMgr – 0x80004005

Suppose you have created a task sequence, advertised it and booted from task sequence media or however you want; if you receive the following error: “Task Sequence: <TS name> has failed with the error code (0x80004005). For more information, please contact your system administrator or helpdesk operator.” at Setup Windows and ConfigMgr step you might … Continue reading Setup Windows and ConfigMgr – 0x80004005

SCCM 2007 description of all log files

Another very good resource I just found! The description of all log files in ConfigMgr 2007. See bellow an example and follow the link for the full post: http://technet.microsoft.com/en-us/library/bb892800.aspx. Management Point Log Files If management points are installed in the site hierarchy, management point log files are stored in the SMS_CCMLOGS folder on the management … Continue reading SCCM 2007 description of all log files

“The ConfigMgr Provider reported an error”

Today I came across an interesting problem in ConfigMgr while creating a Windows Vista image of reference computer. And again, ConfigMgr 2007 displays the error with not much intuitive help. I’m using Microsoft Deployment Toolkit 2008 with ConfigMgr 2007 when I need to deploy an operating system. At the end of the imported Task Sequence, … Continue reading “The ConfigMgr Provider reported an error”