[dbo].[CiscoStatsThView]

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:20 AM Wednesday, March 07, 2007
Last Modified	5:37:05 PM Monday, May 04, 2009

Name
server_addr
probe_addr
IntervalDateTime
IntervalDuration
freeMem
bufferElFree
bufferElMiss
bufferFail
bufferNoMem
avgBusy1

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

CREATE view CiscoStatsThView AS SELECT CiscoStats.server_addr, CiscoStats.probe_addr, IntervalDateTime, IntervalDuration, freeMem=freeMem, bufferElFree=bufferElFree, bufferElMiss=case WHEN (bufferElHit + bufferElMiss)= 0 THEN 0 ELSE bufferElMiss/(bufferElHit + bufferElMiss) END, bufferFail=case WHEN IntervalDuration= 0 THEN 0 ELSE bufferFail/IntervalDuration END, bufferNoMem=case WHEN IntervalDuration= 0 THEN 0 ELSE bufferNoMem/IntervalDuration END, avgBusy1=avgBusy1 FROM CiscoStats
GO
GRANT SELECT ON [dbo].[CiscoStatsThView] TO [uniadmin]
GO