I have a customer with some issue on a server, and has it happened a fair few software updates did not replicate for a while, and now we are struggling to get the PS to be fully synchronized in a low bandwidth environment where network blockouts are in place from 0900-1900.
In the process we crafted a SQL query to highlight how much data has to be replicated to Package Servers.
Here is the SQL query I crafted:
select pa.name, pk.name, count(*) as 'Package to replicate', cast(pk.[Package Size] / (1024.0*1024.0) as decimal(6,2)) as 'Package size in MiB', cast(pk.[Package Size] / (1024.0*1024.0) as decimal(6,2)) * count(*) as 'MiB to replicate'
from ResourceAssociation ra
join Item ch -- Software Update
on ra.ChildResourceGuid = ch.Guid
join Item pa -- Software Bulletin
on ra.ParentResourceGuid = pa.Guid
join ResourceAssociation ra2
on ch.guid = ra2.parentresourceguid
join Item it2
on ra2.childresourceguid = it2...