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',…
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…

In SCCM 2007 ,to initiate machine policy /hardware inventory and other actions on client,we use vb script/wmic/Powershell/Right click Tools and other tools like Client center,collection commander etc.Some organizations do not like to install any of these tools.In that cases,we have only option of using scripts. to achive it The most common Script that is used…
SCCM Configmgr 2012 Clients failed to download Content using Custom Port “Error sending DAV request. HTTP code 600”

Testing the basic Functions of Newly Build Configuration Manager 2012 primary and Secondary Sites by its SCCM clients to see if they work or not. Have installed Configuration manager client on windows 7,windows 8 and server OS .Created Configmgr 2007 toolkit V2 package,distributed to DP’s and deployed to these machines. Did Machine Policy on the…