Tuesday, October 8, 2013

SCCM report for Distribution point last refresh time and last status time

The following SCCM report provides SCCM package ID, Source site Last refresh time, Active status and last status time;
*****************************************************************
SELECT     v_DistributionPoint.PackageID AS [Package ID],  
           v_DistributionPoint.SourceSite AS [Source Site],     
           v_DistributionPoint.LastRefreshTime AS [Last Refresh
           Time], v_DistributionPoint.IsActive AS Active,    
           v_DistributionStatus.LastStatusTime AS [Last Status time]
FROM       v_DistributionPoint
CROSS JOIN v_DistributionStatus


*******************************************************
More SCCM custom reports can be found here

No comments:

Post a Comment