|John Nelson's Articles|
Two important changes that will speed up CM inbox processing
12/15/2009 - System Center Configuration Manager
We've recently migrated from SMS 2003 to CM 2007 SP2 with R2, and something we noticed is that DDR processing for certain things seems to be slower in CM than it was in SMS 2003, 30-40/min instead of 200-300
Operations Manager - Computers showing as "Not Monitored"
9/25/2009 - System Center Operations Manager
When looking at a list of agent-managed machines you notice the "Windows Operating System" column shows some or all machines as "Not Monitored", but the agent is HEALTHY.
SQL for SMS/ConfigMgr Tip - Distribute data evenly from 1 SQL file to multiple SQL files
9/17/2009 - SQL Server
When you first install an application like SMS or ConfigManager, the underlying SQL database is sitting in one data file. Now, depending on who you ask, for performance reasons they recommend a DB file to CPU ratio somewhere between 1:4 and 1:1.
Outlook - How do I empty the Sync Issues\Local Failures folder in Outlook?
7/28/2009 - Microsoft Office
So your mailbox at work keeps filling up and you get these messages from your Exchange admin saying you need to clean up your mailbox. Problem is, even though you have 50MB of space (or whatever) you don't have 50MB of emails in your mailbox.
SMS/ConfigMgr - Create status MIFs using batch script with no dependencies
1/14/2009 - SMS 2003
In a past position, I've tried to use a utility from the Back Office Resource Kit called ismif32.exe to create status MIFs for those programs that aren't MSI-based or don't have the ability to create status mifs. The problem I've had is that it just didn't always work.
Calculate a client's subnet mask when defining subnet boundaries (using BITWISE AND & in SQL)
10/30/2008 - SQL Server
I was recently pointed to Jeff Gilbert's blog where he has an article on determining a client's subnet mask and using them in subnet boundaries.
WQL - Using the bracket wildcard to match a range of version numbers (MNSCUG)
10/22/2008 - SMS 2003
I mentioned the notion of using LIKE and the bracket wildcard  to match a range of version numbers (which incidentally works for versions, IP Addresses, IP Subnets, etc.) instead of using greater than or less than because of the way WQL/SQL does a dictionary sort.
SMS 2003 - What do those C054 columns mean in reports? (Localized Name Lookup)
10/6/2008 - SMS 2003
If you look at certain pre-canned reports that come with SMS 2003, you'll notice some of them have weird column names like C054, but show up in the report output as "Operating System".
SMS 2003 - Query to pull logged on user records from all sources
8/29/2008 - SMS 2003
I was trolling the forums lately on MyITForm.com and was reading some conversations about logged on user records. It made me think of all the sources where you could get that information.
SQL/WQL Tip - How to escape special SQL/WQL wildcard characters like % _
8/27/2008 - SQL Server
You've written a SQL query or a WQL query (like an SMS/CM collection query) and you need to look for a string that has a percent % or underscore _ in it. The problem is, those characters are special wildcard characters to SQL/WQL.