Recent Posts

0
Comments

Off Topic: Ditch the plastic chairmat...replace it with the last chair mat you'll ever own. by jnelson

Disclaimer: I'm not a salesman or representative for any company that makes or sells chair mats. Don't try to contact me for any reason to tell...
0
Comments

ConfigMgr 2007 - Two important changes that will speed up CM inbox processing by jnelson

BACKGROUND 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...
1
Comments

ConfigMgr 2007 SP2 Status Message - Table and View by jnelson

BACKGROUND In a previous article I posted an excel workbook that contained all of the status messages for ConfigMgr 2007 SP2 and their meanings. That's...
4
Comments

ConfigMgr 2007 SP2 Status Message Documentation by jnelson

!!!! UPDATE !!!! I've created a table and view containing this data so you can use it in your reports without having to look up what messageIDs like...
1
Comments

ConfigMgr - Definition of the ObjectType field in vSMS_Folders and vFolderMembers by jnelson

If you're digging through the CM database and you're looking for folders or the items within folders, you're going to want to look at the views...
0
Comments

ConfigMgr - Query to find all CM folders and show where they are in the console by jnelson

In response to a forum post, I've decided to write a quick article on getting folders from CM (and showing subfolder structure) and showing what kinds...
0
Comments

SMS/ConfigMgr - Showing expired advertisements and the collections to which they're assigned by jnelson

THE PROBLEM So, some time has passed since you've implemented SMS or ConfigManager and you've got teams of people deploying ads left and right...
1
Comments

ConfigMgr/SMS - Query to enumerate the ProgramFlags (from v_Program) by jnelson

I know you've looked at the ProgramFlags field from v_Program and wondered what the heck those crazy numbers mean. Well, each bit (it's a 32-bit...
0
Comments

ConfigMgr - SRS Reporting - Use the "Format" Property To Format Numbers With Comma Separators by jnelson

THE PROBLEM You've written a SQL Reporting Services report (SRS) that displays large numbers (4 digits or higher). The problem is, end-users don't...
0
Comments

SMS/ConfigMgr - SQL Function to Convert Integer8 (from Active Directory) to Datetime/Local Time by jnelson

INTEGER8... It's possible you're pulling a value from Active Directory for discovery like LastLogonTimeStamp which stores it's value as something...
0
Comments

SMS/ConfigMgr - Refresh/Recompile Views to Keep MetaData in Sync by jnelson

THE ISSUE SMS & ConfigManager (Microsoft Systems Management Server & Microsoft System Center Configuration Manager) are wonderful at dealing with...
0
Comments

Operations Manager - Computers showing as "Not Monitored" by jnelson

SYMPTOM When looking at a list of agent-managed machines you notice the "Windows Operating System" column shows some or all machines as "Not...
Filed under:
1
Comments

SQL for SMS/ConfigMgr Tip - Distribute data evenly from 1 SQL file to multiple SQL files by jnelson

BACKGROUND When you first install an application like SMS or ConfigManager, the underlying SQL database is sitting in one data file. Now, depending on...
0
Comments

Outlook - How do I empty the Sync Issues\Local Failures folder in Outlook? by jnelson

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...
3
Comments

ConfigMgr 2007 - Where is v_GS_COMPUTER_SYSTEM_PRODUCT in CM? I think it's missing! by jnelson

If you're building reports in Configuration Manager 2007 like you did in SMS 2003, you may be looking for the view: V_GS_COMPUTER_SYSTEM_PRODUCT I...
More Posts Next page »
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems