Stuff
public text v1 · immutable select
GMTTIME as 'DateTime'
,replace(
replace(
replace(
replace(
replace(
replace(Description,'%SourceComputers%',cast(SourceComputers as nvarchar(255))),
'%AffectedComputerNames%',cast(AffectedComputerNames as nvarchar(255))),
'%AdditionalInformation%',cast(AdditionalInformation as nvarchar(255))),
'%AffectedObjects%',cast(AffectedObjects as nvarchar(255))),
'%AffectedComputerIPs%',cast(AffectedComputerIPs as nvarchar(255))),
'%ThreatName%',cast(ThreatName as nvarchar(255)))
as 'description'
from ServerEvents, EventFilterDesc
where ServerEvents.EventID = EventFilterDesc.EventID
and eventfilterdesc.language = '0409'
order by GMTTime desc