Views [dbo].[wvVMO_Linux]
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
manage_vm
vm_priority
vm_cpu_usage_upper_limit
vm_cpu_usage_lower_limit
memory_manage_vm
memory_vm_priority
cpu_vm_priority
cpu_coefficient
memory_coefficient
capacity_utilization
dro_vm_utility_deployed
dro_vm_utility_running
vmserver_name
vmserver_type
display_name
config_file
vm_id
ip_address
os_type
total_memory
uptime
power_status
heart_beat
current_cpu
cpu_warn_threshold
cpu_critical_threshold
current_memory
memory_warn_threshold
memory_critical_threshold
available_memory
VPM_Property1
VPM_Property2
VPM_Property3
VPM_Property4
VPM_Property5
VPM_Property6
VPM_Property7
VPM_Property8
VPM_Property9
VPM_Property10
VMServer_ID
DatacenterName
VC_ServerName
ClusterName
DatacenterIndex
ClusterIndex
ParentsIDList
SQL Script
CREATE VIEW wvVMO_Linux 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 r where m.uuid = r.uuid
GO
Uses