Views [dbo].[e2e_apm_ServerSummary_dayV]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:20 AM Wednesday, March 07, 2007
Last Modified11:10:20 AM Wednesday, March 07, 2007
Columns
Name
SERVER
COMPLETED
CANCELLED
EXCEPTION
TStamp
SERVERID
Permissions
TypeActionOwning Principal
GrantSelectapmadmin
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