SCCM Package stuck at “Install Pending” state

Last week, someone power cycled one of our secondary site server (also a DP) via the remote management card without shutting down the OS first. At that time, a software update deployment package (total size of 13MB) was being pushed to this site. As result, this particular update package got stuck at “Install Pending” even few days after the reboot. I noticed below error was logged in distmgr.log every few minutes: Cannot update the package server <site server NAL path> for package <package ID>, error = 8 No other errors were found in despool.log or sender.log. I have tried refreshing

Continue reading

SCCM Report: “System Boot Time for Computers in a Specific Collection

This is a report I wrote last week: “System Boot Time for Computers in a Specific Collection”. SQL Statement: [sourcecode language=”SQL”] select  distinct v_R_System_Valid.ResourceID, v_R_System_Valid.Netbios_Name0 AS [Computer Name], V_GS_OPERATING_SYSTEM.LastBootUpTime0 AS [Last Boot Time], v_R_System_Valid.Resource_Domain_OR_Workgr0 AS [Domain/Workgroup], v_Site.SiteCode as [SMS Site Code] from v_R_System_Valid inner join v_GS_OPERATING_SYSTEM on (v_GS_OPERATING_SYSTEM.ResourceID = v_R_System_Valid.ResourceID) inner join v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_R_System_Valid.ResourceID) left  join v_Site on (v_FullCollectionMembership.SiteCode = v_Site.SiteCode) Where v_FullCollectionMembership.CollectionID = @CollectionID Order by v_R_System_Valid.Netbios_Name0 [/sourcecode]   Prompts: Name: CollectionID Prompt Text: Collection Prompt SQL Statement: [sourcecode language=”SQL”] begin if (@__filterwildcard = ”) select v_Collection.CollectionID, v_Collection.Name from v_Collection order by v_Collection.Name else select v_Collection.CollectionID,

Continue reading

SCCM 2012 Beta 2 Installation error "Failed to write string -T8295 to registry on SQL Server"

Today I started installing SCCM 2012 Beta 2 in my test environment. while I was installing the Central Admin Site, the installation wizard got stuck at “Evaluating Setup Environment” step and the following errors were logged in C:\ConfigMgrSetup.log: ERROR: Failed to write string -T8295 to registry on SQL Server ERROR: Failed to write string “-T4199” to registry on SQL Server This is because the SQL Server service is not running under Local System. After I changed the SQL Server service to run under Local System, restarted SQL Server service, the SCCM 2012 setup went successful! This is documented in “Configuration

Continue reading

What’s New in SCCM 2012

Found this article from Technet today: What’s New in Configuration Manager 2012 Lots of exciting new features. Can’t wait for my newly ordered testing PC (Intel i7 with 24GB RAM running Hyper-V 2008 R2) arrives so I can start playing SCCM 2012 Beta 2!

Continue reading

ConfigMgr 2007 Inbox (Outbox) Monitor: Could not complete polling cycle within configured period

Starting few weeks ago, In the SCCM environment which I support, all site servers located in one country started generating status messages similar to below every 15 minutes: SMS Inbox Monitor took 3627 seconds to complete a cycle.  This exceeds its configured interval of 900 seconds by 2727 seconds. These messages are also logged in Site server’s application log. SCOM also detects it and generated warning alerts:   After reviewing inboxmgr.log, I noticed the time stamp for the log entries was 1 hour ahead of the system time. This also happens to the other SCCM log files. I then noticed

Continue reading

SCCM Health Check PowerShell Script Updated to Version 3.3

I have updated the SCCM Health Check Script again. The latest version is now 3.3. Below is what’s been updated since my last post for version 3.1: Fixed the bug where when using DOTNET sending emails to multiple recipients, it only sends to the first recipient from the list. It now zip the txt attachment to zip file before sending it. this is to improve the performance and avoid sending large attachments. Added functionality to check all current active package distribution Able to create exemptions for DNS suffix check. This can be configured in the XML. (this is required at

Continue reading

PowerShell Script to locate SCCM objects in SCCM console

There are many object types in SCCM that supports folders in the console. Even though the object can be easily located using the search function, often we need to find out which folder does a particular object (i.e. package, advertisement, etc) reside.  At work, we use folders to separate objects for different business units and differnet IT service providers. Therefore, there are many times I need to find out where exactly is the object located. I wrote this script today called Locate-SCCMObject.PS1 Syntax: .\Locate-SCCMObject <SCCM Central Site Server> <SCCM Object ID>: Example: Using the script: From SCCM Console: The output

Continue reading

Creating a collection in SCCM for “all SCOM 2007 R2 agents without Cumulative Update 4 installed”

Recently I’ve been working on deploying a SCOM environment to monitor SCCM infrastructure. Initially we used SCCM to deploy SCOM agents out to all SCCM servers as it is our preferred method to deploy any apps. By doing so, SCOM agents are considered “Manually Installed” in SCOM, therefore I cannot simply approve updates in SCOM console and get it pushed out in SCOM. I needed to make a collection for all computers that have SCOM 2007 R2 agents installed but without CU4 so it can be used to deploy CU4 to SCOM agents. Here’s the query: Description: All computers that

Continue reading

Setting SMS_INSTALL_DIR_PATH Environment variable on SCCM site servers for SCOM SCCM management pack

According to the “Configuration Manager 2007 SP2 Management Pack User’s Guide for Operations Manager 2007 R2 and Operations Manager 2007 SP1” (for MP version 6.0.6000.2), An environment variable named “SMS_INSTALL_DIR_PATH” needs to be created on all SCCM site servers. I had to do this on 80+ site servers, so I thought why not do this using a script and let SCCM to push it out to all site servers? Therefore, I wrote a VBScript Set-EnvirVar-For-SCOM.vbs (I didn’t use PowerShell this time because it is easier to push out VBScripts via SCCM). Source Code: [sourcecode language=”vbnet”] Set objWMIService = GetObject("winmgmts:" _

Continue reading

Updated: SCCM Health Check PowerShell Script

I have updated the SCCM Health Check Script that I have originally posted here. Download Version 3.1 Here. Changes: 1. The script can now utilise Powershell Remoting to check inboxes sizes. It requires PS-Remoting to be enabled on all SCCM Site Servers. This dramatically reduced the execution time of the script in a multi-tier environment. In a production environment that I support, it reduced the execution time from 1.5 – 2 hours to around 35 minutes!  You can configure which method to use via XML file. To enable, set <PSRemoting><Value> to Enabled. Or Disabled if you want to use the

Continue reading
%d bloggers like this: