SCCM Configmgr SQL Error The SELECT permission was denied on the object database CM_Sitecode-schema-dbo

Running SQL queries directly from SQL server management studio is not safe method until you know what you are doing but it is always Good to use reporting services in Configmgr 2012. when you are running SQL code using SQL management studio,you get error something like below due to insufficient privileges on the selected Database:…
SCCM Configmgr 2012 SSRS Report Package compliance status for all Distribution Points

Simple and useful report for troubleshooting package issues: Package compliance Status report to know what is the success rate of the Applications/Packages/Driver/SUP on the Distribution Points: select UPPER(SUBSTRING(PSD.ServerNALPath,13,CHARINDEX('.', PSd.ServerNALPath) -13)) AS [DP Name],count(*) [Targeted] , count(CASE when PSD.State='0' then '*' END) AS 'Installed', count(CASE when PSD.State not in ('0') then '*' END) AS 'Not Installed',…

Powershell Scripting made things lot more easier in Configuration Manager 2012.You can automate console operations by using Windows PowerShell cmdlets.For list of Configmgr SP1 cmdlets,refer http://technet.microsoft.com/en-us/library/jj821831(v=sc.10).aspx Manually Refresh of the Distribution Points for a specific package in Configmgr 2012 is not easy as it was in CM07. Started using the Powershell script for simple tasks…
SCCM Configmgr 2012 How do I Refresh the Application after change in source Files or source Location

Quick Post: You have created an Application in Configmgr 2012 and distributed to Distribution Points.Later for reason,you have decided to add/change/Update the files to the package source location. In Configmgr 2007,we do this by right click package, Update the package,which will take the changes to All Distributed Sites. In Configmgr 2012,The option is replaced with…
SCCM Configmgr Manage Workgroup Computers for Deployment,Remote tools etc

In my earlier post,we saw how to manage work group computers using SCCM Configmgr 2007. http://www.windows-noob.com/forums/index.php?/topic/2029-managing-workgroup-computers-in-sccm-sms-environment/ In this blog post,we are going to see how to manage workgroup/ DMZ computers using SCCM Configmgr 2012. This procedure involves working with lmhost and host files on workgroup computers. For some reason,i find that ,Technet documentation is not very clear…