SCCM 2012 SSRS report Site Servers and its assigned boundary information

Quick post on the Boundaries and its assigned Site Servers which are nothing but Distribution Points.Simply creating boundaries does not make clients to get connected to DP and download the content. you will have create assign these boundaries to boundary group and boundary group to Site+Content location. Here is report to list all Boundaries and…

In my previous blog post,i talked about how to compare 2 distribution points to see if they both have any applications mismatch.This blog post talks about how to distribute the missing apps to the Distribution Point. I have used basic inbuilt Configmgr powershell commands for this activity,more via here Note:Use the package names as input…

Full details:http://social.technet.microsoft.com/Forums/systemcenter/en-US/82a7862a-fc1c-4c45-9635-ee44489c2673/file-inventory-report-query-by-name-count-and-machineid?forum=configmgrreporting   select cs.Name0 [Computer name],COUNT(*) as [No of Times] from v_GS_SoftwareFile SF,v_GS_COMPUTER_SYSTEM cs where FileName like '%.mdf%' and SF.ResourceID=cs.ResourceID group by cs.Name0 order by 2 desc
Download SCCM Configmgr 2012 R2 SQL Views

Long ago,posted Configmgr SP1 SQL Views in spreadsheet which you can download it via post http://eskonr.com/2013/04/download-sccm-2012-sql-views-documentation/. SQL Views are very useful while working with reports and it saves lot of time in searching the particular information if you are unsure where it resides. SQL Views provides the information help you in creating custom reports, determine…
SCCM Configmgr 2007 Software Updates Stuck at Preparing for Installation Error sending DAV request HTTP code 404 status ‘Resource Not Found’

Second Tuesday of every month called Microsoft patch Day 🙂 Patches get released and configmgr* guys busy in testing ,moving them to production. As usual, I have Downloaded the patches,added to the package,deployed to Distribution Points ,all returned success (Decompressed the PCK successfully).Until here Good. While testing the patches on one of the server,it just…

We have been seeing many hotfixes and Cumulative updates for configmgr 2012 product .For each hotfix /CU level,the client version will get change. As you test and deploy these hotfixes /CU's in your environment ,you are also required to maintain the environment both clients and server client to the same level as your site running.…

With the default report,you can get Count or list of PC’s from domain Eg: Computers in a specific workgroup or domain. If you want to know the count of PC’s with specific role like standalone workstation a.k.a Workgroup computers,member workstation,member server,standalone server etc,use the below report . I use property called DomainRole0 from V_GS_Computer_system view…