SCCM Configmgr report:Inventory for Webcam Devices ?

Inventory report for laptops who have webcam feature ? You can use this report both on SCCM 2007 and Configmgr 2012 Environment. select cs.name0 [Computer name], cs.username0 [Last loggedin User], os.Caption0 [OS],os.InstallDate0 [OS Installed Date], cs.Manufacturer0,cs.Model0 , WS.LastHWScan [Reported Date to SCCM] from v_GS_COMPUTER_SYSTEM cs,v_GS_SYSTEM_ENCLOSURE se,v_GS_OPERATING_SYSTEM OS,  v_GS_WORKSTATION_STATUS WS where cs.ResourceID=se.ResourceID and cs.ResourceID=OS.ResourceID and cs.ResourceID=WS.ResourceID…
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',…

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 report Count Status of packages on All Distribution Points

In my previous report,we saw complete information about Pending packages,installed packages,Targeted but not installed,total packages targeted to DP http://eskonr.com/2012/08/sccm-report-count-of-packages-available-on-distribution-points/ In todays report,we go with count of all packages information at one glance to identify and Fix total number of Packages Distributed out of which how many are installed,Pending Packages. select dbo.v_SystemResourceList.Servername as "Server Name", (select…

Sometimes I find Difficult to locate specific site from the Hierarchy(mostly if you are in large environment with many nodes) until you know where they attached to. I use the report data most of the times as reference to locate where the site resides based in its reporting site (primary) and primary site reporting to…

Today I was looking at Packages to see how many packages are created without any distribution Points added. This might help you in identifying whether these packages are really needed to be in SCCM or archive them. This below report will help you in achieving this. select PackageID,Name,Version,SourceDate from v_Package where PackageID not in (select…

Once you are done with installation/configuration of the sites/Distribution Point,you start distributing the content to it.sometimes you may have to check if the site which you configured has all the content that serve for clients to receive packages. For this,you can compare the newly configured server with already existing server¬† which has all the content…