[dbo].[e2e_apm_ClientSummary

[dbo].[e2e_apm_ClientSummary_hourV]

(local) > mdb > Views > dbo.e2e_apm_ClientSummary_hourV

Properties
Columns
Permissions
SQL Script
Uses

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

Columns

Name
CLIENT
COMPLETED
CANCELLED
EXCEPTION
TStamp
CLIENTID

Permissions

Type	Action	Owning Principal
Grant	Select	apmadmin

SQL Script

create view e2e_apm_ClientSummary_hourV AS SELECT c.client_name AS CLIENT, r.num_complete AS COMPLETED, r.num_cancelled AS CANCELLED, r.num_exception AS EXCEPTION, r.start_datetime AS TStamp, r.client_id AS CLIENTID FROM e2e_apm_client c INNER JOIN e2e_apm_resp_data_hour r ON c.client_id = r.client_id

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

Uses

[dbo].[e2e_apm_client]
[dbo].[e2e_apm_resp_data_hour]
dbo