SCCM Configmgr 2012 Report Application Deployment results for specific application for specific OU

Started rolling out MS office 2013 to Users few weeks ago.For this ,created collection to get computers with MS office 2010 ,created application for MS office 2013 upgrade and deploy to collection .This collection consists of computers from different departments,business units etc. Colleague of mine asked me if there is way to get report for…

When you are doing Migration from SCCM 2007 to SCCM 2012,you may want to remove some of the drivers which are no longer needed . This report list all the drivers which are part of any driver package so you can take action on them before you migrate to SCCM Configmgr 2012. Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c82cc16a-06b7-49ae-ac11-2f6399047b6a…

Status of Specific Advertisement can get from Default available report but what if you want to find the status of specific advertisement with its LastAcceptanceStatusTime greater or less than X days. Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/30e4dbda-982b-43dc-8665-8dd142925d4f DECLARE  @olddate datetime         ,@NullVal datetime SET @olddate = DATEADD(day,-5, GETUTCDATE()) select adv.AdvertisementName 'Application', sys.Name0 'System', LastAcceptanceStateName 'Acceptance', sts.LastAcceptanceStatusTime 'AcceptTime_GMT', sts.LastStatusMessageIDName…

Having multiple sites and checking the status of WSUS synchronization on all servers tedious job and child sites must sync with its parent sites to ensure right compliance levels from clients. This report will give you the status of WSUS server with Right content version. When SCCM sync with Microsoft Updates,Content version will get increment…

long ago have posted report on computers with SCCM report for Last logged on computer name with application installed or not and SCCM report display computers with IPaddress based on Application/software this report gives you computers with ip address and last logged on username from a given collection : select A.Name0,c.IPAddress0 as 'IP ADDRESS',E.UserName0 as…

    SELECT b.Netbios_Name0, b.User_Name0, CASE WHEN a.FileVersion LIKE '11.%' THEN 'Office 2003' WHEN a.FileVersion LIKE '12.%' THEN 'Office 2007' WHEN a.FileVersion LIKE '14.%' THEN 'Office 2010' ELSE 'Udda Version' END AS 'Office Version', a.FileName, a.FileVersion, a.FilePath FROM v_GS_SoftwareFile a JOIN v_R_System b ON a.ResourceID = b.ResourceID JOIN v_RA_System_SystemOUName c ON a.ResourceID = c.ResourceID WHERE…

Long back i posted report  http://eskonr.com/2009/12/sccm-report-for-computers-asset-information-including-sn-number-and-model-name/ to get computer information like computer name,Serial number,Processor,Physical memory,service Pack,computer model etc In this post ,i have modified the report little bit from previous post to add more fields that gives you lot more information about the computer . It is  very simple and straight forward report that just use…