[dbo].[ca_logical_asset

Property	Value
Row Count	1834
Created	11:08:06 AM Wednesday, March 07, 2007
Last Modified	9:08:09 PM Friday, December 05, 2008

	Name	Data Type	Collation	Max Length (Bytes)	Default
$Cluster Primary Key XPKca_logical_asset_property: dns_name\mac_address\logical_asset_uuid$ $Indexes ca_logical_asset_property_idx_02: dns_name\delete_time\exclude_registration$	dns_name	nvarchar(100)	SQL_Latin1_General_CP1_CI_AS	200
$Cluster Primary Key XPKca_logical_asset_property: dns_name\mac_address\logical_asset_uuid$ $Indexes ca_logical_asset_property_idx_01: mac_address\delete_time\exclude_registration$	mac_address	nvarchar(64)	SQL_Latin1_General_CP1_CI_AS	128
$Cluster Primary Key XPKca_logical_asset_property: dns_name\mac_address\logical_asset_uuid$ $Indexes ca_logical_asset_property_idx_03: logical_asset_uuid\exclude_registration$	logical_asset_uuid	binary(16)		16
	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_property_idx_02: dns_name\delete_time\exclude_registration$ $Indexes ca_logical_asset_property_idx_03: logical_asset_uuid\exclude_registration$ $Indexes ca_logical_asset_property_idx_01: mac_address\delete_time\exclude_registration$	exclude_registration	int		4
$Indexes ca_logical_asset_property_idx_02: dns_name\delete_time\exclude_registration$ $Indexes ca_logical_asset_property_idx_01: mac_address\delete_time\exclude_registration$	delete_time	int		4

	Name	Columns
$Cluster Primary Key XPKca_logical_asset_property: dns_name\mac_address\logical_asset_uuid$	XPKca_logical_asset_property	dns_name, mac_address, logical_asset_uuid
	ca_logical_asset_property_idx_01	mac_address, delete_time, exclude_registration
	ca_logical_asset_property_idx_02	dns_name, delete_time, exclude_registration
	ca_logical_asset_property_idx_03	logical_asset_uuid, exclude_registration

Name	Columns
$ca_lo_r0000067700000000	logical_asset_uuid->[dbo].[ca_logical_asset].[logical_asset_uuid]

Type	Action	Owning Principal
Grant	Delete	uapmbatch
Grant	Insert	uapmbatch
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Delete	uapmbatch_group
Grant	Insert	uapmbatch_group
Grant	Delete	uapmadmin
Grant	Insert	uapmadmin
Grant	Delete	ca_itrm_group
Grant	Insert	ca_itrm_group
Grant	Delete	regadmin
Grant	Insert	regadmin
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	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

SQL Script

CREATE TABLE [dbo].[ca_logical_asset_property]
(
[dns_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[mac_address] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[logical_asset_uuid] [binary] (16) NOT 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__231F2AE2] DEFAULT ((0)),
[exclude_registration] [int] NULL,
[delete_time] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_logical_asset_property] ADD CONSTRAINT [XPKca_logical_asset_property] PRIMARY KEY CLUSTERED ([dns_name], [mac_address], [logical_asset_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ca_logical_asset_property_idx_02] ON [dbo].[ca_logical_asset_property] ([dns_name], [delete_time], [exclude_registration]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ca_logical_asset_property_idx_03] ON [dbo].[ca_logical_asset_property] ([logical_asset_uuid], [exclude_registration]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ca_logical_asset_property_idx_01] ON [dbo].[ca_logical_asset_property] ([mac_address], [delete_time], [exclude_registration]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_logical_asset_property] ADD CONSTRAINT [$ca_lo_r0000067700000000] FOREIGN KEY ([logical_asset_uuid]) REFERENCES [dbo].[ca_logical_asset] ([logical_asset_uuid])
GO
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [aiadmin]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_logical_asset_property] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_logical_asset_property] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_logical_asset_property] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [regadmin]
GRANT INSERT ON  [dbo].[ca_logical_asset_property] TO [regadmin]
GRANT DELETE ON  [dbo].[ca_logical_asset_property] TO [regadmin]
GRANT UPDATE ON  [dbo].[ca_logical_asset_property] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [swcmadmin]
GRANT INSERT ON  [dbo].[ca_logical_asset_property] TO [swcmadmin]
GRANT DELETE ON  [dbo].[ca_logical_asset_property] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[ca_logical_asset_property] TO [swcmadmin]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [uapmadmin]
GRANT INSERT ON  [dbo].[ca_logical_asset_property] TO [uapmadmin]
GRANT DELETE ON  [dbo].[ca_logical_asset_property] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[ca_logical_asset_property] TO [uapmadmin]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[ca_logical_asset_property] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[ca_logical_asset_property] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[ca_logical_asset_property] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [uapmbatch]
GRANT INSERT ON  [dbo].[ca_logical_asset_property] TO [uapmbatch]
GRANT DELETE ON  [dbo].[ca_logical_asset_property] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[ca_logical_asset_property] TO [uapmbatch]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[ca_logical_asset_property] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[ca_logical_asset_property] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[ca_logical_asset_property] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [uapmreporting]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [uapmreporting_group]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [ucmadmin]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [ucmuser]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [uniadmin]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [uniuser]
GRANT SELECT ON  [dbo].[ca_logical_asset_property] TO [upmuser_group]
GO