Tuesday, October 28, 2008

MMS 2008 Hands on DVD

This is ironic because I received the DVDs already LOL
Dear MMS 2008 Attendee,

We are pleased to inform you that additional collateral has been created and is being sent to you. The MMS 2008 Hands-on Lab Walkthrough DVD contains video recordings of the most popular Hands-on Lab topics offered during the event with an audio commentary, allowing you to review the labs with a step-by-step commentary explaining the key procedures covered. In addition, the DVD contains soft copies of the Hands-on Lab manuals used at the event.

This e-mail serves as confirmation that your MMS 2008 Hands-on Lab Walkthrough DVD set has been shipped and you should be receiving it within 1-2 weeks (International locations may take longer). The DVD set has been sent via the U.S. Postal Service to the address included with your registration information.

If you do not receive your DVD set within the specified time, please e-mail MMS2008HOL@paragongroup.com for further assistance.

Thanks again for your participation in MMS 2008!

Saturday, October 25, 2008

Add computer to a collection

I have vbscript on this blog that will give you the ability to add a computer to a collection but it command line based. I have created a HTA file that has 2 parts.

1. Allows the user to right click on a collection and add multiple computers
2. Allow the user to right click on a computer in a collection or query and add it to multiple collections

The output list is limited to 50 currently but you can change it per your enviroment. Also I am pulling System Resource from "All computers" collection. I am sure this could be modified to add groups and OUs and such.

Here is the link to look at the code and download the program

I have some ideas to improve it so I might be posting those changes here.

Sunday, October 19, 2008

ODBC Report

I have create a MOF extension for SCCM
You will find it here http://www.sccm-tools.com/tools/other/other-ODBCMOF.html on my sccm tools website.

Report Right click tool

Here is an SCCM console extension that could also be used for SMS if changed for the MMC GUID system.

The Tool is designed to allow the admin to run any of the reports. All that is needed is the reporting point server name, the report ID and the values that need to be passed.


Report.vbs sms-serve1 170 MachineName ##Sub:name##

Currently I have it set for the individual computer and collection GUIDS. This can be added and set to run for almost any one of the guids. Instead of trying to post all the code here I will give you a link to my sccm tools website and you can download the code from there.


Right click tool order

What order do the xml files for console extensions execute?

Well they run in alphabetical order. So if you want to add a seperator above and below you tools then you need to make them as say 1.xml and zz.xml

Create the XML line to ready.

Wednesday, October 8, 2008

Exclusions based on a Group or OU

All the computers that are only in the A and not the A & B?
Computer 1 Group A
Computer 2 Group B
Computer 3 Group A+B
Computer 4 Group A+B

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_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 where SMS_R_System.SystemOUName = "Group B" ) and SMS_R_System.SystemOUName = "Group A"

Cross link on my blog to other exclusions


Monday, October 6, 2008

Helping others with SCCM Errors

I work for The Texas A&M University System Offices (TAMUS) in College Station, TX. We have many universities and Agencies that report directly to us. The closest is Texas A&M University (TAMU), just down the road. Since we are so close we tend to help each other not only in IT but other projects. When I was hired by TAMUS in 2005 I was asked if I could learn SMS 2003 and manage their systems. Well not only did I learn but I became somewhat of the the regional expert and even presented at MMS 2008. I routinely help IT admins at TAMU as they implement SMS/SCCM as well as if they have it implemented and they would like some help with some part of the application.

I recieved an email today from one of the IT admins that had tested SCCM 2007 and was now moving to the actual installation phase. On his Windows 2008 Site server box he attempted to install SCCM 2007 SP1 on a Domain computer only to have an error (Domain Membership)... his computer "needed to be part of a domain."

So I started with some general questions and it struck me that possibly the firewall was on between the systems and it couldn't determine the domain it was on. After having him reconfigure his firewall on the SQL box and the Site server it was able to install. Now we are working to move him into Native mode. Since I was the first to move to SCCM I had already work with the Enterprise group to configure the Certificates for Native and Out of Band Mangement point. I think right now there are about 4 or 5 SCCM servers and 2 SMS servers left over at TAMU. It has been my goal for the last couple of years to get the community of SMS/SCCM IT people together so everyone can learn about it and see how to implement it. I even had them watch my MMS 2008 presentation before I left to give me pointers. In the next 1 or 2 years the campus will modify its AD structure pulling all the domains in to a single domain with departmental OUs and that means a change of how we utilize SCCM. I would hope by that time we can all work together on the single SCCM structure and bring all the computers together. Talk about a challange. Thank you for allowing me to assist you with SMS/SCCM. For every problem we work on, I learn something and I hope they learn something as well.