SCCM 2012 Report for All Active Content Replication with % Completed

Hi All,

We had a requirement to create a report to include the Package transfer details in SCCM 2012 Report.

In SCCM 2012, the logs are really magical and it captures more information then SCCM 2007

When you Open All Active Content Replication report you will come to know how many packages are in Que

But you need to open the status message or Package Transfer log to identify which package is actually getting transfered and how much has been completed.

I have created a report which will include this information in the All Active Content Replication Report which will become handy in your day to day tasks.

You can edit the Default report and click save as and copy paste the below code in the datasheet.

Image

Feel free to let me know if you have any difficulty in getting this report.

SQL Query

———–

select
pkg.Name as C062,
pkg.PackageID,
SUBSTRING(dp.ServerNALPath, CHARINDEX(‘\\’, dp.ServerNALPath) + 2, CHARINDEX(‘”]’, dp.ServerNALPath) – CHARINDEX(‘\\’, dp.ServerNALPath) – 3 ) AS C070,
dp.SiteCode,
dp.LastRefreshTime,
stat.SourceVersion,
stat.LastCopied,
stat.SummaryDate,
(select top 1 msg.InsString3
from v_StatMsgWithInsStrings msg
join v_StatMsgModuleNames modNames on msg.ModuleName = modNames.ModuleName
join v_StatMsgAttributes attpkg on msg.RecordID=attpkg.RecordID and msg.Time=attpkg.AttributeTime
join v_StatMsgAttributes attdp on msg.RecordID=attdp.RecordID and msg.Time=attdp.AttributeTime
where attpkg.AttributeValue =pkg.PackageID and msg.MessageID=’8204′
and msg.InsString2 =SUBSTRING(dp.ServerNALPath, CHARINDEX(‘\\’, dp.ServerNALPath) + 2, CHARINDEX(‘”]’, dp.ServerNALPath) – CHARINDEX(‘\\’, dp.ServerNALPath) – 3 )
order by msg.Time desc) as ‘% Completed’,
stat.InstallStatus
from v_Package pkg
join v_DistributionPoint dp on pkg.PackageID=dp.PackageID
join v_PackageStatusDistPointsSumm stat on dp.ServerNALPath=stat.ServerNALPath
and dp.PackageID=stat.PackageID
where stat.State!=0
order by pkg.Name, dp.SiteCode

———-

 

Advertisements