[dbo].[e2e_apm_ServerSummary

[dbo].[e2e_apm_ServerSummary_hourV]

(local) > mdb > Views > dbo.e2e_apm_ServerSummary_hourV

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	12:32:09 PM Sunday, December 05, 2010
Last Modified	12:32:09 PM Sunday, December 05, 2010

Columns

Name
SERVER
COMPLETED
CANCELLED
EXCEPTION
TStamp
SERVERID

Permissions

Type	Action	Owning Principal
Grant	Select	apmadmin

SQL Script

create view e2e_apm_ServerSummary_hourV AS SELECT s.server_name AS SERVER, r.num_complete AS COMPLETED, r.num_cancelled AS CANCELLED, r.num_exception AS EXCEPTION, r.start_datetime AS TStamp, r.server_id AS SERVERID FROM e2e_apm_server s INNER JOIN e2e_apm_resp_data_hour r ON s.server_id = r.server_id
GO
GRANT SELECT ON [dbo].[e2e_apm_ServerSummary_hourV] TO [apmadmin]
GO

Uses

[dbo].[e2e_apm_resp_data_hour]
[dbo].[e2e_apm_server]
dbo