We have a number SCCM Reporting Services subscriptions for our automated reporting. Yesterday I had a former team member’s ID removed from SCCM access and today most of the automated reports did not run. When a report subscription is created
SCCM 2012 User Device Affinity and Windows XP
Referencing the Microsoft TechNet article titled How to Manage User Device Affinity in Configuration Manager @ http://technet.microsoft.com/en-us/library/gg699365.aspx How to configure the site to automatically create user device affinities Use the following procedure to enable your Configuration Manager site to automatically
SQL 2012, BIDS, and SSDT
With SQL Server 2012 Business Intelligence Development Studio is replaced with SQL Server Data Tools. BIDS = Business Intelligence Development Studio SSDT = SQL Server Data Tools (http://msdn.com/data/tools.aspx) If you customize SQL Reporting Services reports for SCCM 2007 or ConfigMgr
SCCM 2012 SP1 refresh / KB2801987
The original ISO for Microsoft System Center 2012 Configuration Manager SP1 contained a nasty little bug that prevented the ConfigMgr client from installing. The problem was that the authenticode signature for MicrosoftPolicyPlatformSetup.msi, a required component of the client agent, was
SCCM Report of Operating Systems and Types
Based on Sherry Kissinger’s blog http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx here is the summary report for a list of Processors, OS Type, OS Name, and Computer count. select pr.datawidth0 [Processor bits] , pr.addresswidth0 [OS bits] , sys.Operating_system_Name_and0 [OS Name] ,count(sys.resourceid) [Computers] from v_r_system sys
SCCM 2012 SP1 downloads
In preparing to install ConfigMgr 2012 SP1 here is the list of files/applications to download: Updated 2013-01-16
SCCM and BranchCache
Configuring BranchCache on the SCCM Distribution Point On the Distribution Point properties, enable “Allow clients to transfer content from this distribution point using BITS, HTTP, and HTTPS” In Server Manager install the BranchCache Feature configure the Windows Firewall
SCCM Unused Packages
This is a t-sql query to help find Packages which you are no longer using so they can be properly organized/categorized/deleted. Thanks to John Nelson (Number 2) and Christjan Schumann for doing the heavy lifting. I only put the two