SSRS Reports – Page 14 – All about Microsoft Endpoint Manager

SCCM Configmgr SSRS SQL report Status of All Packages with Targeted Installed Compliance %

Posted on September 10, 2013 by Eswar Koneti | 6 Comments | 2,770 Views

Reporting in Configuration Manager 2012 and later, is Replaced with SSRS with more features and little complicated if you have not used to it. In this blog post, we will see how to check the status of the packages with their distribution status. To know the Status of content (Packages) ,you can look at monitoring…

SCCM 2012 Migration Report Packages not using UNC Path

Posted on July 30, 2013 by Eswar Koneti | 0 Comments | 339 Views

Are you Migrating your Existing SCCM /Configuration Manager Infrastructure to Configuration manager 2012 ,if so, You will have to look at your Packages whether they UNC path or Local Drive Path since Migration of Packages using Local Drive(Non UNC) can not done. Before you Migrate the Packages from CM07,you will have to ensure all of…

SCCM Report for Optional and Mandatory Advertisements

Posted on May 3, 2013 by Eswar Koneti | 0 Comments | 2,589 Views

SQL Code used in SCCM Reporting to get list of Advertisements that are Mandatory! select adv.AdvertisementName as [Adv Name], adv.PresentTime as DistributionDate, pkg.Name as PackageName, pgm.ProgramName, coll.Name as CollectioName, adv.AdvertisementID from v_Advertisement adv join v_Package pkg on adv.PackageID=pkg.PackageID join v_Program pgm on adv.PackageID=pgm.PackageID and adv.ProgramName=pgm.ProgramName join v_Collection coll on adv.CollectionID=coll.CollectionID join v_ClientAdvertisementStatus stat on adv.AdvertisementID=stat.AdvertisementID…

SCCM Configmgr 2012 distribution Content status Message IDs and State Message IDs

Posted on January 15, 2013 by Eswar Koneti | 2 Comments | 6,921 Views

The way SCCM Configmgr 2012 object information stored is changed from CM07 with respect to tables/views. In SCCM Configmgr 2012,Status of content stored in dbo.vSMS_DistributionDPStatus view.This view basically contains information about packageID,content status,objectTypeID like what type of package is it(boot image or package/Application etc) and status message ID. These status Message IDs and State Message…