Symantec Management Platform (Notification Server)

Hello,
please, anyone knows how to easily troubleshoot which files in package are not replicated?
When some files in package are not "up2date" agent log contains only message "Time stamps on 2 files do not match the snapshot, download these files again". But how to know which 2 files?
We have package with thousands of files (snapshot file is about 500 kB) so it is not so easy to verify file by file... Is there any other way? Another log file, snaphot files to compare or somethink like that?
Thanks for any idea ...

Hi,

This will give package server status:

ORDER BY vi.[Name], ps.[Status]
SELECT DISTINCT v.Server,
SUM(v.[# Ready]) + SUM(v.[# Not Ready]) AS [# Packages],
STR( SUM(v.[Disk Space-Mb]), 10, 2) AS [Disk Space-Mb],
SUM(v.[# Ready]) AS [# Ready],
SUM(v.[# Not Ready]) AS [# Not Ready],
SUM(v.[# Invalid Packages]) AS [# Invalid Packages]
FROM v_packagestatus v
GROUP by v.Server


And this the full outstanding packages details:

SELECT
vi.[Name] AS 'Package Server'
,ps.[Status] AS 'Status'
,pack.[Package Version]
,ps.[PackageId] AS 'Package Guid'
,pack.[Name] AS 'Package Name'
FROM SWDPackageServer ps
JOIN vItem vi ON vi.[guid] = ps.[PkgSvrId]
JOIN SWDPackage pack ON pack.[PackageId] = ps.[PackageId]
AND pack.[_Latest] = 1
WHERE ps.[Status] != 'Ready'

ORDER BY vi.[Name], ps.[Status]