Tags: configmgr report

Posted on December 5, 2022 by | 6 Comments | 2,676 Views
The following SQL query can be used to query the list of collections that doesn't have any deployments. you can review the number of collections with no deployments and you can further extend the query to exclude certain folders where you use these exception collections for troubleshooting or other purpose. select Col.Name, col.CollectionID, case when…
Read more »
SCCM Configmgr 2012 Report Application Deployment results for specific application for specific OU

Posted on May 11, 2015 by | 40 Comments | 22,526 Views
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…
Read more »

Posted on January 8, 2013 by | 0 Comments | 1,100 Views
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…
Read more »

Posted on January 7, 2013 by | 0 Comments | 470 Views
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…
Read more »

Posted on November 20, 2012 by | 4 Comments | 2,246 Views
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…
Read more »

Posted on January 30, 2012 by | 13 Comments | 8,147 Views
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…
Read more »

Posted on January 19, 2012 by | 0 Comments | 3,360 Views
    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…
Read more »