Views [dbo].[wvDRO_Starfire]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:17 AM Wednesday, March 07, 2007
Last Modified5:40:53 PM Monday, May 04, 2009
Columns
Name
name
label
address
address_type
status_no
hidden
propagate_status
severity
posted
acknowledge
alarmset_name
autoarrange_type
date_ins
date_modify
code_page
admin_status
DSM_Server
propagated_status_no
propagated_sev
DSM_Address
license_machine_type
create_bpv
override_imagelarge
override_imagesmall
override_imagedecal
override_imagetintbool
override_model
background_image
weight
weighted_severity
Max_Sev
user_reclass
Asset_uuid
source_repository
dnsname
last_seen_time
AMSServer
EMServer
class_name
uuid
platform_name
platform_type
dro_server_host
drsl
drslg
scl
sclg
manage_platform
log_level
log_file_size
console_message_level
main_ssp_name
dro_port
cpu_weight_coefficient
la_weight_coefficient
real_memory_weight_coefficient
analysis_interval
poll_interval
domain_usage_upper_limit
domain_usage_lower_limit
cur_capacity
io1
io2
io3
io4
io1_min
io1_max
io1_coef
io2_min
io2_max
io2_coef
io3_min
io3_max
io3_coef
io4_min
io4_max
io4_coef
disk1
disk2
disk1_min
disk1_max
disk1_coef
disk2_min
disk2_max
disk2_coef
mem2
mem3
mem2_min
mem2_max
mem2_coef
mem3_min
mem3_max
mem3_coef
cpu2
cpu2_min
cpu2_max
cpu2_coef
net1
net2
net1_min
net1_max
net1_coef
net2_min
net2_max
net2_coef
VPM_Property1
VPM_Property2
VPM_Property3
VPM_Property4
VPM_Property5
VPM_Property6
VPM_Property7
VPM_Property8
VPM_Property9
VPM_Property10
SQL Script
CREATE VIEW wvDRO_Starfire AS Select m.name,m.label,m.address,m.address_type,m.status_no,m.hidden,m.propagate_status,m.severity,m.posted,m.acknowledge,m.alarmset_name,m.autoarrange_type,m.date_ins,m.date_modify,m.code_page,m.admin_status,m.DSM_Server,m.propagated_status_no,m.propagated_sev,m.DSM_Address,m.license_machine_type,m.create_bpv,m.override_imagelarge,m.override_imagesmall,m.override_imagedecal,m.override_imagetintbool,m.override_model,m.background_image,m.weight,m.weighted_severity,m.Max_Sev,m.user_reclass,m.Asset_uuid,m.source_repository,m.dnsname,m.last_seen_time,m.AMSServer,m.EMServer,m.class_name,r.* from  tng_managedobject m,  wtDRO_Starfire r where m.uuid = r.uuid
GO
Uses