Views [dbo].[wvDRO_PLVEthernet]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:13:39 AM Wednesday, March 07, 2007
Last Modified5:40:52 PM Monday, May 04, 2009
Columns
Name
name
label
address
class_name
interface_type
autoarrange_type
hidden
propagate_status
status_no
severity
tng_delete_flag
posted
acknowledge
ip_address_hex
mac_address
subnet_mask
date_ins
date_modify
alarmset_name
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
uuid
Platform_Name
Platform_Type
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
Manage_Platform
Free_Memory
DRSL
DRSLG
Analysis_Interval
Poll_Interval
HMC_Name
Memory_Usage
CPU_Usage
Capacity_PLPAR
Crit_Capacity_Plat_Thresh
Min_Capacity_Plat_Thresh
DebugLevel
Console_Message_Level
LogFileSize
Number_Of_CPUs
Plat_Free_LMBs
Plat_Total_LMBs
SYS_IP_Address
Capacity_On_Demand_CPU_Capable
Capacity_On_Demand_MEM_Capable
OS400_Capable
Micro_LPAR_Capable
Virtual_IO_Server_Capable
LPAR_Property1
LPAR_Property2
LPAR_Property3
LPARName
PortVLAN
AdditionalVLAN
TrunkAdapter
Required
MACAddress
LPARID
SlotNum
EthernetIEEE
VPM_Property1
VPM_Property2
VPM_Property3
VPM_Property4
VPM_Property5
VPM_Property6
VPM_Property7
VPM_Property8
VPM_Property9
VPM_Property10
SQL Script
CREATE VIEW dbo.wvDRO_PLVEthernet AS SELECT a.name, a.label, a.address, a.class_name, a.interface_type, a.autoarrange_type, a.hidden, a.propagate_status, a.status_no, a.severity, a.tng_delete_flag, a.posted, a.acknowledge, a.ip_address_hex, a.mac_address, a.subnet_mask, a.date_ins, a.date_modify, a.alarmset_name, a.code_page, a.admin_status, a.DSM_Server, a.propagated_status_no, a.propagated_sev, a.DSM_Address, a.license_machine_type, a.create_bpv, a.override_imagelarge, a.override_imagesmall, a.override_imagedecal, a.override_imagetintbool, a.override_model, a.background_image, a.weight, a.weighted_severity, a.Max_Sev, a.user_reclass, a.Asset_uuid, a.source_repository, a.dnsname, a.last_seen_time, AMSServer, EMServer, b.* FROM dbo.tng_managedobject a, dbo.wtDRO_PLVEthernet b where a.uuid = b.uuid
GO
Uses