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
Category: ConfigMgr
Failed to extend the Active Directory Schema
Usually, extending the Active Directory schema is the last step I do when installing SCCM. This time, while installing SCCM in a virtual machine, you have to provide a path to a folder with SCCM updates or download these updates from the internet. Working in a virtual machine with a “Local only” network adapter, I … Continue reading Failed to extend the Active Directory Schema
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
Update proxy settings used by Software Updates role in SCCM 2007
Few months ago I had an interesting problem at a client site that took me a while to resolve. So I want to post it here, maybe it will help others… After a successful upgrade from SMS 2003 to SCCM 2007 SP1, I configured software update point, synchronized with Microsoft update to get the list … Continue reading Update proxy settings used by Software Updates role in SCCM 2007
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
How Microsoft IT is using Configuration Manager 2007
Do you know how Microsoft IT manages thousands of servers worldwide in multiple countries for a large number of departments and customers using SCCM 2007? If no, then you should listen to this 30 minutes podcast: Microsoft IT Business Case for System Center Configuration Manager 2007 in a Data Center. And here is the full … Continue reading How Microsoft IT is using Configuration Manager 2007
“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”