Technical support guide

Queries to pull SCCM Package status information on Distribution point

Queries to pull SCCM Package status information on Distribution point 1) Below query will provide the install status (failed,pending,complete) of package and respective count select COUNT(*),InstallStatus from v_PackageStatusDistPointsSumm where PackageID like ‘<PackageID>‘ group by InstallStatus 2) Below query will provide the list of DP’s where package status is completed   select * from v_PackageStatusDistPointsSumm where [...]

List all SCCM views

Have you any time thought of where SCCM views gets stored? Did you faced problem while finding the required SCCM view other than views which are listed in Microsoft document? dbo.v_SchemaViews is the view where you will find all the views which are in SCCM database To pull the list of all views run below [...]

My Wiki on TechNet :SCCM backup procedure

Posted wiki article on SCCM backup procedure, which helps to understand steps involved in SCCM backup (Site server and SQL database on the same server), how many status message gets generated? How many components get backed up? to read more please go through below article http://social.technet.microsoft.com/wiki/contents/articles/8524.sccm-backup-procedure.aspx Incoming search terms:sccm 2007 query archive (1)sccm wiki (1)

Forefront Endpoint Protection (FEP) 2010 Beta and FEP for Servers (FEP-S) CTP – Available on Connect

  Microsoft  announced a release of Forefront Endpoint Protection 2010. This release includes: Forefront Endpoint Protection (FEP) Beta and Forefront Endpoint Protection for Servers (FEP-S) CTP – https://connect.microsoft.com/forefrontsecurity/Downloads/DownloadDetails.aspx?DownloadID=30127. Please download the software. You can also give your feedback through Connect! Forefront Endpoint Protection (FEP) Beta, Microsoft’s System Center Configuration Manager based solution is ready for [...]

Microsoft Deployment Toolkit (MDT) 2010 Update 1

Microsoft Deployment Toolkit (MDT) 2010 Update 1 Brief Description Microsoft Deployment Toolkit (MDT) 2010 Update 1 is the newest version of Microsoft Deployment Toolkit, a Solution Accelerator for operating system and application deployment. MDT 2010 Update 1 supports deployment of Windows 7, Office 2010, and Windows Server 2008 R2 in addition to deployment of Windows [...]

How to reset SMS_Executive thread through Registry

Resetting a SMS_Executive thread through registry helps Config Manager Administrator to accelerate the daily operation. Config Manager Administrator can perform same task by logging into the console and navigating till tool and then start ConfigMgr Service manager. However it takes lot of time to connect to ConfigMgr Service manager. ex. To reset the SMS_COLLECTION_EVALUATOR thread [...]

Config Manager Registries

Below registry key may help while pulling a data through script from registry Where do you will find the SCCM provider location in registry? (X64 bit) HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftSMSSetup | Provider Location Where is the path for SQL Log file (LDF) and data file (MDF) location in registry? MDF file:- HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftSMSSQL Server | Device Path LDF file:- [...]

Create a Robust, Integrated Reporting Solution using SQL Server Reporting Services and System Center Configuration Manager

Reporting is a crucial ability for most organizations—and the ability to provide robust reporting of various Microsoft System Center Configuration Manager (SCCM) functions is no exception. Reporting is a feature that hasn’t changed much over several versions of Systems Management Server and SCCM. With the release of SCCM R2, reporting has undergone one significant change—the [...]

Troubleshoot ConfigMgr 2007

You may refer below links to troubleshoot ConfigMgr 2007 Troubleshooting Tools Troubleshooting Secure Key Exchange Troubleshooting SQL Replication Issues Troubleshooting Configuration Manager Client Deployment Troubleshooting the Configuration Manager Console Troubleshooting Collection Issues Troubleshooting Software Distribution Troubleshooting Software Updates Troubleshooting Operating System Deployment Troubleshooting Reporting Troubleshooting SQL Reporting Services Troubleshooting Desired Configuration Management Troubleshooting Mobile Device [...]

component manifest was not found or it was invalid

You will find this is common problem while installing a SCCM “component manifest was not found or it was invalid” though you have provided path for “updated components” why this is so? If the “update components” are not the latest one then you will face this issue. To solve this issue download the latest component [...]

Moving of SCCM site server from Physical to Virtual

Recently we have to restore SCCM SP2 primary site. Reason being restoring the server is moving of SCCM  server from physical to virtual server.Thought to share experience with you guys.Here we go… Below are the important points which needs to be taken  care before restoring and moving SCCM site server. Make sure you have latest [...]

SCCM package replication facts :- What will happen if you change the “Retry Count” for software distribution Component?

These days I’m working on package replication, One of our SCCM Primary site has 55+  PDP’s. This time, because of some reasons 2 of them went down.Actually both are new protected distribution point. “Number of retry settings was set to ‘100’ and distribution manager was only  retrying package replication only on 2 problem PDp’s.  As [...]

Troubleshoot the issue of Error 500, when accessing SMS/SCCM reports

Last month one of our stake holder facing problem while running SCCM report . He was facing error 500 in internet explorer. when checked the IIS logs find below error is appearing After searching on the web, found SMS 2003 Faq’s http://technet.microsoft.com/en-us/library/cc875797.aspx . However, our servers are installed with SCCM 2007 and IE7. After going [...]

Forefront Endpoint Protection (FEP) on System Center Configuration Manager

Based on customer feedback and market trends, Microsoft has made the strategic decision to build Forefront Endpoint Protection (FEP) on System Center Configuration Manager, Microsoft’s solution to comprehensively assess, deploy, and update servers, clients, and devices.  Please go thorough the link for more details. Thanks and Regards |Abhishek Joshi |www.AbhishekJoshi.com Incoming search terms:configuration manager 2007 [...]