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