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

3 comments:

  1. We must use time wisely and forever realize that the time is always ripe to do right. See the link below for more info.


    #time
    www.ufgop.org

    ReplyDelete
  2. I read your blog.I thought it was great.. Hope you have a great day. God bless.

    Rica
    www.imarksweb.org

    ReplyDelete
  3. I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article.


    edupdf.org

    ReplyDelete