Querying for a successful package transfer for a package (Message ID 8210 in srvmsgs.dll)

declare @PackageID varchar (8) = 'XYZ01625'

select
  m.Time
, CONVERT (NVARCHAR, DATEADD (HH, DATEDIFF (hh, GETUTCDATE (), GETDATE ()), m.Time), 22) LocalStandardTime
, case Severity
  when 0x40000000 then 'Informational'
  when 0x80000000 then 'Warning'
  when 0xC0000000 then 'Error'
  else ' ' 
  end Severity
, 'Package Transfer Manager has successfully updated the package '
  + m.InsString1 + ', Version ' + m.InsString2 + ' on distribution point ' + m.InsString3 + '.' StatusMessage
from v_StatMsgWithInsStrings m
inner join v_StatMsgModuleNames smmn on m.ModuleName = smmn.ModuleName
inner join v_StatMsgAttributes  pkat on m.RecordID = pkat.RecordID and m.Time = pkat.AttributeTime and pkat.AttributeID = 400
inner join v_StatMsgAttributes  dpat on m.RecordID = dpat.RecordID and m.Time = dpat.AttributeTime and dpat.AttributeID = 404
where
    pkat.AttributeValue = @PackageID
and m.MessageID = 8210
order by m.Time

Leave a comment