[dbo].[si_arg_dis_asset

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	141
Created	6:13:22 PM Tuesday, May 05, 2009
Last Modified	6:13:22 PM Tuesday, May 05, 2009

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_si_arg_dis_asset_prop: dis_asset_uuid\data_source$	dis_asset_uuid	binary(16)	16
$Cluster Primary Key PK_si_arg_dis_asset_prop: dis_asset_uuid\data_source$	data_source	nvarchar(128)	256
	dis_host_name	nvarchar(255)	510
	dis_serial_number	nvarchar(64)	128
	dis_asset_tag	nvarchar(64)	128
	dis_sys_model	nvarchar(384)	768
	dis_sys_type	nvarchar(384)	768
	dis_sys_vendor	nvarchar(384)	768
	own_asset_uuid	binary(16)	16
	own_asset_name	nvarchar(100)	200
	own_asset_tag	nvarchar(64)	128
	own_alias	nvarchar(30)	60
	own_serial_number	nvarchar(64)	128
	own_host_name	nvarchar(255)	510

	Name	Columns	Unique
$Cluster Primary Key PK_si_arg_dis_asset_prop: dis_asset_uuid\data_source$	PK_si_arg_dis_asset_prop	dis_asset_uuid, data_source

Type	Action	Owning Principal
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Select	aiadmin
Grant	Update	aiadmin
Grant	Select	aipublic

SQL Script

CREATE TABLE [dbo].[si_arg_dis_asset_prop]
(
[dis_asset_uuid] [binary] (16) NOT NULL,
[data_source] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[dis_host_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dis_serial_number] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dis_asset_tag] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dis_sys_model] [nvarchar] (384) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dis_sys_type] [nvarchar] (384) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dis_sys_vendor] [nvarchar] (384) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_asset_uuid] [binary] (16) NULL,
[own_asset_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_asset_tag] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_alias] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_serial_number] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_host_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[si_arg_dis_asset_prop] ADD CONSTRAINT [PK_si_arg_dis_asset_prop] PRIMARY KEY CLUSTERED ([dis_asset_uuid], [data_source]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[si_arg_dis_asset_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_arg_dis_asset_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_arg_dis_asset_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_arg_dis_asset_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_arg_dis_asset_prop] TO [aipublic]
GO