I have an app that will refresh the specified files. Also have a report to find them. When it says "'UNKNOWN MESSAGE ID'" Then you need to go to the status area and figure out what that means.
select Replace(DPS.Name,'.<YOUR-DOMAIN>,'') AS [Server], DPS.PackageID As [PkgID], P.Name AS [PackageName], MessageCategory, CASE MessageID When 2301 Then 'Processing content on site server' When 2303 Then 'Successfully distributed content' When 2330 Then 'Successfully distributed content' When 2357 Then 'Distributing Content' When 2380 Then 'Processing content' When 2383 Then 'Package is not present or corrupt.' When 2384 Then 'Successfully processed content on distribution point' WHEN 2385 Then 'Missing File: ' + InsString3 when 2391 Then 'Failed to connect to remote distribution point' when 2397 Then 'Content was distributed to distribution point' When 8208 Then 'Content hash is invalid' When 8211 Then 'Failed to update package' When 8212 Then 'Cannot find source to download from' When 9507 Then 'Downloading content from source distribution point' When 9508 Then 'Downloading content from source distribution point' When 9509 Then 'Downloading content from source distribution point' Else 'UNKNOWN MESSAGE ID' End As [Message], MessageID, DPS.MessageSeverity >From CM_CEN.dbo.VSMS_DistributionDPStatus DPS Left Join CM_CEN.dbo.v_Package P on P.PackageID = DPS.PackageID Where DPS.MessageID NOT IN(2301,2303,2330,2357,2380,2384,2397,9507,9508,9509 ) Or MessageCategory IN(116) On Tue, Jun 17, 2014 at 11:40 AM, Cliff Hobbs <[email protected]> wrote: > Hi all, > > > > before I attempt to reinvent the wheel, I was just wondering if anyone had > already created a Report in ConfigMgr 2012 to show any DPs where Content > Validation has failed and the affected Packages/ Apps? > > > > Many thanks and kind regards, > > Cliff > > > > > >
