All pastes #618029 Raw Edit

Stuff

public text v1 · immutable
·published 2007-07-13 18:11 UTC
rendered paste body
 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