[dbo].[ca_logical

Property	Value
Row Count	1668
Created	11:08:03 AM Wednesday, March 07, 2007
Last Modified	4:41:12 PM Monday, August 17, 2009

	Name	Data Type	Collation	Max Length (Bytes)	Default
$Indexes ca_logical_asset_idx_02: host_name\asset_uuid\logical_asset_uuid\delete_time\exclude_registration$	logical_asset_uuid	binary(16)		16
$Indexes ca_logical_asset_idx_03: asset_uuid\exclude_registration$ $Indexes ca_logical_asset_idx_02: host_name\asset_uuid\logical_asset_uuid\delete_time\exclude_registration$	asset_uuid	binary(16)		16
$Indexes ca_logical_asset_idx_02: host_name\asset_uuid\logical_asset_uuid\delete_time\exclude_registration$	host_name	nvarchar(255)	SQL_Latin1_General_CP1_CI_AS	510
	creation_user	nvarchar(64)	SQL_Latin1_General_CP1_CS_AS	128
	creation_date	int		4
	last_update_user	nvarchar(64)	SQL_Latin1_General_CP1_CS_AS	128
	last_update_date	int		4
	version_number	int		4	((0))
$Indexes ca_logical_asset_idx_03: asset_uuid\exclude_registration$ $Indexes ca_logical_asset_idx_02: host_name\asset_uuid\logical_asset_uuid\delete_time\exclude_registration$	exclude_registration	int		4
$Indexes ca_logical_asset_idx_02: host_name\asset_uuid\logical_asset_uuid\delete_time\exclude_registration$	delete_time	int		4

	Name	Columns	Unique
	XPKca_logical_asset	logical_asset_uuid
	ca_logical_asset_idx_02	host_name, asset_uuid, logical_asset_uuid, delete_time, exclude_registration
	ca_logical_asset_idx_03	asset_uuid, exclude_registration

Name	ANSI Nulls On	Quoted Identifier On	On
ca_logical_asset_er0			After Insert

Name	Columns
$ca_lo_r0000066e00000000	asset_uuid->[dbo].[ca_asset].[asset_uuid]

Type	Action	Owning Principal
Grant	Delete	ca_itrm_group
Grant	Insert	swcmadmin
Grant	Insert	uapmbatch_group
Grant	Delete	uapmadmin
Grant	Insert	uapmadmin
Grant	Delete	uapmbatch
Grant	Insert	uapmbatch
Grant	Delete	swcmadmin
Grant	Insert	ca_itrm_group
Grant	Delete	regadmin
Grant	Insert	regadmin
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Delete	uapmbatch_group
Grant	Select	aiadmin
Grant	Select	ca_itrm_group
Grant	Update	ca_itrm_group
Grant	Select	regadmin
Grant	Update	regadmin
Grant	Select	service_desk_admin_group
Grant	Select	uapmadmin_group
Grant	Update	uapmadmin_group
Grant	Select	uapmbatch_group
Grant	Update	uapmbatch_group
Grant	Select	uapmreporting_group
Grant	Select	ucmadmin
Grant	Select	ucmuser
Grant	Select	uniadmin
Grant	Select	uniuser
Grant	Select	upmuser_group
Grant	Select	amsgroup
Grant	Select	ca_itrm_group_ams
Grant	Select	uapmadmin
Grant	Update	uapmadmin
Grant	Select	uapmbatch
Grant	Update	uapmbatch
Grant	Select	uapmreporting
Grant	Select	swcmadmin
Grant	Update	swcmadmin
Grant	Select	ams_group

SQL Script

CREATE TABLE [dbo].[ca_logical_asset]
(
[logical_asset_uuid] [binary] (16) NOT NULL,
[asset_uuid] [binary] (16) NULL,
[host_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ca_logica__versi__2042BE37] DEFAULT ((0)),
[exclude_registration] [int] NULL,
[delete_time] [int] NULL
) ON [PRIMARY]
GO
CREATE TRIGGER dbo.ca_logical_asset_er0 ON ca_logical_asset AFTER INSERT AS  DECLARE  @dia_logical_asset_uuid binary(16) SELECT  @dia_logical_asset_uuid=logical_asset_uuid FROM INSERTED  EXECUTE  dbo.ca_logical_asset_t @dia_event_type = 0, @dia_logical_asset_uuid=@dia_logical_asset_uuid
GO
ALTER TABLE [dbo].[ca_logical_asset] ADD CONSTRAINT [XPKca_logical_asset] PRIMARY KEY CLUSTERED ([logical_asset_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ca_logical_asset_idx_03] ON [dbo].[ca_logical_asset] ([asset_uuid], [exclude_registration]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ca_logical_asset_idx_02] ON [dbo].[ca_logical_asset] ([host_name], [asset_uuid], [logical_asset_uuid], [delete_time], [exclude_registration]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_logical_asset] ADD CONSTRAINT [$ca_lo_r0000066e00000000] FOREIGN KEY ([asset_uuid]) REFERENCES [dbo].[ca_asset] ([asset_uuid])
GO
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [aiadmin]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [ams_group]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [amsgroup]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_logical_asset] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_logical_asset] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_logical_asset] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [regadmin]
GRANT INSERT ON  [dbo].[ca_logical_asset] TO [regadmin]
GRANT DELETE ON  [dbo].[ca_logical_asset] TO [regadmin]
GRANT UPDATE ON  [dbo].[ca_logical_asset] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [swcmadmin]
GRANT INSERT ON  [dbo].[ca_logical_asset] TO [swcmadmin]
GRANT DELETE ON  [dbo].[ca_logical_asset] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[ca_logical_asset] TO [swcmadmin]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [uapmadmin]
GRANT INSERT ON  [dbo].[ca_logical_asset] TO [uapmadmin]
GRANT DELETE ON  [dbo].[ca_logical_asset] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[ca_logical_asset] TO [uapmadmin]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[ca_logical_asset] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[ca_logical_asset] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[ca_logical_asset] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [uapmbatch]
GRANT INSERT ON  [dbo].[ca_logical_asset] TO [uapmbatch]
GRANT DELETE ON  [dbo].[ca_logical_asset] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[ca_logical_asset] TO [uapmbatch]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[ca_logical_asset] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[ca_logical_asset] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[ca_logical_asset] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [uapmreporting]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [uapmreporting_group]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [ucmadmin]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [ucmuser]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [uniadmin]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [uniuser]
GRANT SELECT ON  [dbo].[ca_logical_asset] TO [upmuser_group]
GO