[cohesion].[servers_ui

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	62
Created	9:08:38 PM Wednesday, August 20, 2008
Last Modified	2:16:16 PM Monday, September 14, 2009

Name	Data Type	Max Length (Bytes)
service_type	varchar(50)	50
accessprofs	int	4
accessprofs_sort	varchar(90)	90
service_port	int	4
cpuarch	varchar(50)	50
osname	varchar(50)	50
osversion	varchar(90)	90
osfamily	varchar(50)	50
biosver	varchar(100)	100
cpuguid	varchar(100)	100
cpucount	int	4
cpuspeed	int	4
hdcount	int	4
hbacount	int	4
make	varchar(100)	100
model	varchar(100)	100
netmask	varchar(300)	300
ospatchlvl	varchar(100)	100
pmem	int	4
niccount	int	4
serialno	varchar(100)	100
locstorcap	float	8
vmem	int	4
primhba	varchar(50)	50
activity	varchar(50)	50
discprofs	int	4
discprofs_sort	varchar(90)	90
cdstat	varchar(10)	10
refrdate	datetime	8
mgmtprofs	int	4
mgmtprofs_sort	varchar(90)	90
networks	varchar(255)	255
rcstat	varchar(10)	10
svrgrps	varchar(4000)	4000
host_name	varchar(90)	90
host_status	varchar(50)	50
svccount	int	4
cmpcount	int	4
swcbpcats	varchar(90)	90
services	varchar(4000)	4000
discprofmode	varchar(10)	10
mgmtprofmode	varchar(10)	10
accessprofmode	varchar(10)	10
discprofenabled	varchar(10)	10
mgmtprofenabled	varchar(10)	10
accessprofenabled	varchar(10)	10
virtualstatus	varchar(10)	10
physicalhost	varchar(50)	50
virtualization	varchar(50)	50
host_id	int	4
ip_address	varchar(300)	300
ipv4_address	varchar(300)	300
ipv4_address_sort	varchar(50)	50
ipv6_address	varchar(50)	50
ipv6_address_sort	varchar(50)	50
mac_address	varchar(50)	50
cc_agent_yn	int	4
cc_agent_port	int	4
cc_agent_instdir	varchar(255)	255
cc_agent_instdate	datetime	8
cc_agent_version	varchar(90)	90
cc_agent_contact	datetime	8
cluster_yn	int	4
cluster_name	int	4
cluster_name_sort	varchar(90)	90
cluster_tech	varchar(90)	90
isdevice	varchar(10)	10

	Name	Columns	Unique
	PK__servers_ui_table__5F7E2DAC	host_id

SQL Script

CREATE TABLE [cohesion].[servers_ui_table]
(
[service_type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[accessprofs] [int] NULL,
[accessprofs_sort] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[service_port] [int] NULL,
[cpuarch] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[osname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[osversion] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[osfamily] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[biosver] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cpuguid] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cpucount] [int] NULL,
[cpuspeed] [int] NULL,
[hdcount] [int] NULL,
[hbacount] [int] NULL,
[make] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[model] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[netmask] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ospatchlvl] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[pmem] [int] NULL,
[niccount] [int] NULL,
[serialno] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[locstorcap] [float] NULL,
[vmem] [int] NULL,
[primhba] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[activity] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[discprofs] [int] NULL,
[discprofs_sort] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cdstat] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[refrdate] [datetime] NULL,
[mgmtprofs] [int] NULL,
[mgmtprofs_sort] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[networks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rcstat] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[svrgrps] [varchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_status] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[svccount] [int] NULL,
[cmpcount] [int] NULL,
[swcbpcats] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[services] [varchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[discprofmode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mgmtprofmode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[accessprofmode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[discprofenabled] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mgmtprofenabled] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[accessprofenabled] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[virtualstatus] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[physicalhost] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[virtualization] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_id] [int] NOT NULL,
[ip_address] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ipv4_address] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ipv4_address_sort] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ipv6_address] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ipv6_address_sort] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mac_address] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cc_agent_yn] [int] NULL,
[cc_agent_port] [int] NULL,
[cc_agent_instdir] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cc_agent_instdate] [datetime] NULL,
[cc_agent_version] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cc_agent_contact] [datetime] NULL,
[cluster_yn] [int] NULL,
[cluster_name] [int] NULL,
[cluster_name_sort] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cluster_tech] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[isdevice] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[servers_ui_table] ADD CONSTRAINT [PK__servers_ui_table__5F7E2DAC] PRIMARY KEY CLUSTERED ([host_id]) ON [PRIMARY]
GO