[dbo].[e2e_apm_ServerSummary

[dbo].[e2e_apm_ServerSummary_dayV]

(local) > mdb > Views > dbo.e2e_apm_ServerSummary_dayV

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:20 AM Wednesday, March 07, 2007
Last Modified	11:10:20 AM Wednesday, March 07, 2007

Columns

Name
SERVER
COMPLETED
CANCELLED
EXCEPTION
TStamp
SERVERID

Permissions

Type	Action	Owning Principal
Grant	Select	apmadmin

SQL Script

create view e2e_apm_ServerSummary_dayV 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_day r ON s.server_id = r.server_id

GO
GRANT SELECT ON [dbo].[e2e_apm_ServerSummary_dayV] TO [apmadmin]
GO

Uses

[dbo].[e2e_apm_resp_data_day]
[dbo].[e2e_apm_server]
dbo