
68
Sentinel 6.1 Rapid Deployment Reference Guide
no
vd
ocx
(e
n)
13
Ma
y 20
09
6.1.20 ASSET_HOSTNAME_RPT_V
View references ASSET_HOSTNAME table that stores information about alternate host names for
assets.
6.1.21 ASSET_IP_RPT_V
View references ASSET_IP table that stores information about alternate IP addresses for assets.
6.1.22 ASSET_LOCATION_RPT_V
View references ASSET_LOC table that stores information about asset locations.
Column Name
Datatype
Comment
ASSET_HOSTNAME_ID
uuid
Asset alternate hostname identifier
PHYSICAL_ASSET_ID
uuid
Physical asset identifier
HOST_NAME
character varying(255)
Host name
CUST_ID
bigint
Customer identifier
DATE_CREATED
timestamp with time zone
Date the entry was created
DATE_MODIFIED
timestamp with time zone
Date the entry was modified
CREATED_BY
integer
User who created object
MODIFIED_BY
integer
User who last modified object
Column Name
Datatype
Comment
ASSET_IP_ID
uuid
Asset alternate IP identifier
PHYSICAL_ASSET_ID
uuid
Physical asset identifier
IP_ADDRESS
integer
Asset IP address
CUST_ID
bigint
Customer identifier
DATE_CREATED
timestamp with time zone
Date the entry was created
DATE_MODIFIED
timestamp with time zone
Date the entry was modified
CREATED_BY
integer
User who created object
MODIFIED_BY
integer
User who last modified object
Column Name
Datatype
Comment
LOCATION_ID
bigint
Location identifier
CUST_ID
bigint
Customer identifier
BUILDING_NAME
character varying(255)
Building name
ADDRESS_LINE_1
character varying(255)
Address line 1
Summary of Contents for Sentinel Rapid Deployment 6.1
Page 4: ...4 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 24: ...24 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 36: ...36 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 50: ...50 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 54: ...54 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 120: ...120 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 124: ...124 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 132: ...132 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 136: ...136 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...