CCR Retry Pivot table

May 5, 2012 in SCCM 2007, SMS 2003, System Center Configuration Manager, Troubleshooting by Chris Stauffer

  At MMS 2011 Mike Shultz of MCS Microsoft did a presentation and provided some wonderful tools for troubleshooting. One of the was a way to quickly transverse the CCRRETRY.inbox folder. The attached zip file [...]

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Delicious
  • Digg
  • StumbleUpon
  • Email

Creating a Collection Query From SQL

January 26, 2012 in Reports and Queries, SCCM 2007, SMS 2003, SQL Server, System Center Configuration Manager by Chris Nackers

  Credit to Dave Fuller for which this information is based upon. Creating a collection query that is based upon SQL can be done. It’s a little complicated, but not all that bad once you’ve [...]

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Delicious
  • Digg
  • StumbleUpon
  • Email

ConfigMgr (SCCM) – How to rebuild NAL (network abstraction layer)

January 10, 2012 in SCCM 2007, SMS 2003, System Center Configuration Manager by Anoop C Nair

  I was part of a good discussion in Technet and Sabrina from MS provided the steps to Rebuild NAL. I thought of documenting it so that it would be helpful to resolve DP replication [...]

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Delicious
  • Digg
  • StumbleUpon
  • Email

Advanced reporting against Add/Remove Programs (ARP), filtering and appending data – Part 2

December 30, 2011 in Reports and Queries, SCCM 2007, SMS 2003, SQL Server, System Center Configuration Manager by Chris Nackers

  I’m not a SQL expert by any means, so if you see something that isn’t quite right, well i already said I’m not a SQL expert This process involves custom tables and modifying your [...]

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Delicious
  • Digg
  • StumbleUpon
  • Email

Finding the OU of a system in SMS/ConfigMgr

December 29, 2011 in SCCM 2007, SMS 2003, System Center Configuration Manager by Chris Nackers

  Alex Semibratov started up a blog and has a nice post on how to find the actual OU of a computer. If you have ever looked at the information you will notice you get [...]

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Delicious
  • Digg
  • StumbleUpon
  • Email

Advanced reporting against Add/Remove Programs (ARP), filtering and appending data

December 26, 2011 in Reports and Queries, SCCM 2007, SMS 2003, SQL Server, System Center Configuration Manager by Chris Nackers

  I’m not a SQL expert by any means, so if you see something that isn’t quite right, well i already said I’m not a SQL expert This process involves custom tables and modifying your [...]

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Delicious
  • Digg
  • StumbleUpon
  • Email

Migrating SMS 2003 sms_def.mof customizations to ConfigMgr 2007

December 8, 2011 in SCCM 2007, SMS 2003, System Center Configuration Manager by Chris Nackers

  I had a question when moving my mof customizations to ConfigMgr, what goes where? Sherry Kissinger replied back and I wanted to post it for others as well. the sections that start with #pragma [...]

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Delicious
  • Digg
  • StumbleUpon
  • Email

SQL query to identify missing SMS/ConfigMgr boundaries

December 7, 2011 in Reports and Queries, SCCM 2007, SMS 2003, SQL Server, System Center Configuration Manager by Chris Nackers

  This came up on the MSSMS list from myitforum. Here is the final result of the collaboration. Here is a SQL query you can use to help identify missing boundaries for clients that are [...]

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Delicious
  • Digg
  • StumbleUpon
  • Email

SCCM and SMS 2003 in same AD environment

November 22, 2011 in SCCM 2007, SMS 2003, System Center Configuration Manager by Chris Nackers

  Posting this info, so i can remember where i put it and so that others can find it helpful. This info is from a response on the myITforum email list, i asked what people [...]

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Delicious
  • Digg
  • StumbleUpon
  • Email

Scheduling A Weekly Defrag Through SMS/ConfigMgr

November 9, 2011 in SCCM 2007, SMS 2003, System Center Configuration Manager by Chris Nackers

  Without any third party tools here is a simple way to create a weekly defrag task on your client workstations. This is specific for Windows XP, although you could create something similar for Vista [...]

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Delicious
  • Digg
  • StumbleUpon
  • Email