Jeff Gilbert's Web blog at myITforum.com

This posting is provided "AS IS" with no warranties, and confers no rights :-)

Browse by Tags

All Tags » SMS 2003 » Configuration Manager 2007 (RSS)
Subselect queries the easy way
Questions about how to use subselect queries seem to come up a lot, and I can never find a good example to use when I go looking for a subselect query. I found this example from Curtis Sawin (a senior...

Posted Tuesday, July 22, 2008 8:17 AM by jgilbert | with no comments

Wondering if SMS 2003 SP3 or Configuration Manager 2007 Supports Vista SP1 or Windows Server 2008 Clients?
Wonder no more! The updated SMS 2003 SP3 Supported Configurations document has been updated to reflect support for both Windows Vista SP1 and Windows Server 2008 clients. The Configuration Manager 2007...

Posted Friday, June 27, 2008 11:00 PM by jgilbert | with no comments

Dude, where’s my SMS_SiteSystemToSQLConnection group?
A fairly common question I seem to keep running across from SMS 2003 admins that have upgraded to Configuration Manager is: "What happened to the SMS_SiteSystemToSQLConnection group on my Configuration...

Posted Thursday, January 17, 2008 10:42 PM by jgilbert | with no comments

How to Create the All Windows Vista Systems Collection the Easy Way
Some of you may have noticed that when you open up the Configuration Manager console, and view the default collections, that there isn't an All Windows Vista Systems collection there. There are some...

Posted Friday, December 14, 2007 8:05 PM by jgilbert | with no comments

Upgrading SQL for SMS Sites
In order to upgrade an SMS 2003 SP2 or SP3 site to Configuration Manager 2007 the site database must be at the SQL Server 2005 SP2 level. Upgrading SQL Server can be a daunting prospect for a lot of SMS...

Posted Saturday, November 17, 2007 6:13 PM by jgilbert | 4 comment(s)

Common Asset Intelligence Questions and Answers
Here are some common questions and answers from the Asset Intelligence TechNet Forum: What's new in SCCM 2007 wrt Asset Intelligence Coming Soon: Asset Intelligence 1.5 Exchange 2007 not shown in license...

Posted Wednesday, October 17, 2007 9:08 PM by jgilbert | 2 comment(s)

Upgrading SMS 2003 sites with the evaluation version of Configuration Manager 2007 is not supported and just won't work.
This question seems to be coming up a lot lately so I figured that I would make this post to try and help settle the issue some. While the evaluation version of Configuration Manager 2007 is fully functional...

Posted Friday, September 21, 2007 6:41 PM by jgilbert | with no comments

About the #Pragma Deleteclass command
The #pragma deleteclass command is used in SMS/Configuration Manager hardware inventory modification to delete class information from WMI repositories. There are a couple of instances where this command...

Posted Saturday, August 25, 2007 5:38 PM by jgilbert | with no comments

Capacity Planning for Configuration Manager 2007
As with other tools released with SMS, you should only use tools that are either designed, or supported, for the specific product version you are installing. The Capacity Planning tool released for SMS...

Posted Friday, August 24, 2007 10:40 PM by jgilbert | 2 comment(s)

How to determine a client's subnet mask when defining IP subnet boundaries
Lately a lot of people seem to be having some troubles in determining the appropriate subnet mask to use in site boundaries to assign clients when using IP subnet type boundaries (SMS site boundaries and...

Posted Tuesday, August 21, 2007 5:39 PM by jgilbert | 4 comment(s)

Enabling workgroup clients to locate SMS and ConfigMgr site systems using LMHOSTS files
SMS 2003 or Configuration Manager Workgroup clients must be able to locate a server locator point for site assignment and their default management point in order to be managed. Because workgroup clients...

Posted Thursday, August 16, 2007 10:33 PM by jgilbert | with no comments