Views [dbo].[wvVMO_Linux_HostOS]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:18 AM Wednesday, March 07, 2007
Last Modified5:41:32 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
vmserver_name
vmserver_type
os_type
vmserver_build
major_version
minor_version
ca_product_version
current_cpu
cpu_warn_threshold
cpu_critical_threshold
number_of_cpu
current_memory
available_memory
total_memory
memory_warn_threshold
memory_critical_threshold
disk_htl
network_adapter
total_vm_cpu
total_vm_cpu_warn_thres
total_vm_cpu_critical_thres
total_cpu
total_cpu_warn_thres
total_cpu_critical_thres
total_vm_mem
total_vm_mem_warn_thres
total_vm_mem_crit_thres
total_console_mem
total_console_mem_warn_thres
total_console_mem_crit_thres
total_server_memory
total_server_mem_warn_thres
total_server_mem_crit_thres
total_server_mem
get_auth_name
set_auth_name
host_memory_usage_upper_limit
vm_memory_usage_upper_limit
host_cpu_usage_upper_limit
vm_cpu_usage_upper_limit
manage_platform
cpu_manage_platform
log_level
log_file_size
console_message_level
vsl
vslg
logical_cpu
analysis_interval
poll_interval
vm_cpu_usage_lower_limit
host_cpu_usage_lower_limit
vm_memory_usage_lower_limit
host_memory_usage_lower_limit
vm_priority
num_of_used_cpu
cpu_coefficient
memory_coefficient
capacity_utilization
min_number_of_cpu
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
managemigration
serversetname
VPM_Property1
VPM_Property2
VPM_Property3
VPM_Property4
VPM_Property5
VPM_Property6
VPM_Property7
VPM_Property8
VPM_Property9
VPM_Property10
DatacenterName
VC_ServerName
ClusterName
DatacenterIndex
ClusterIndex
VMotionEnabled
SQL Script
CREATE VIEW wvVMO_Linux_HostOS 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,  wtVMO_Linux_HostOS r where m.uuid = r.uuid
GO
Uses