I have a query below to pull the Web-RT information and display in
SSRS. One of my colleges advised that I could use a function in NetIQ
to do that. I tried using fnXMLSplitSchemaFromData but have not had
much luck. Is there a function I can call to convert the XML data to
plain test or HTML?
________________

--Get UTC Time
declare @UTCtd AS datetime
set @UTCtd = getutcdate()

--Get Today's Date and Time
declare @TodayTD AS datetime

set @TodayTD = GETDATE()

--Get Time Zone Informaiton
declare @TimeDif as int
set @TimeDif = DATEDIFF(hh, getutcdate(), getdate())

select TOP 100
Event.Status,
Event.EventID,
Event.KPName,
Event.MachineObjID as ObjID,
Event.Severity,
Event.MachineName as Name,
Event.EventMsg,
fnXMLSplitSchemaFromData (EventDetail.AgentMSglong) as AgentMSglong,
DATEADD (HH,@TimeDif,dbo.fnSQLDateTime (Event.LastOccurTime)) as
LastOccurTime,
DATEADD (HH,@TimeDif,dbo.fnSQLDateTime (Event.ModificationTime)) as
ModificationTime,
DATEDIFF(DD, @TodayTD, (DATEADD (MI,@TimeDif,dbo.fnSQLDateTime
(Event.LastOccurTime)))) as EventAge
from
Event with (NOLOCK)
Join EventDetail WITH (NOLOCK) on Event.EventID = EventDetail.EventID
where
Event.MachineName like 'ServerName'
and
Event.Severity < 21
and
KPName like 'KPname'
and
DATEDIFF(DD, @TodayTD, (DATEADD (MI,@TimeDif,dbo.fnSQLDateTime
(Event.LastOccurTime)))) > -1

order by Event.LastOccurTime DESC


--
abel5405
------------------------------------------------------------------------
abel5405's Profile: https://forums.netiq.com/member.php?userid=5035
View this thread: https://forums.netiq.com/showthread.php?t=54578