[dbo].[wvAvayaAccessPoint]
CREATE VIEW wvAvayaAccessPoint 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_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,m.override_imagelarge,
m.override_imagesmall, m.interface_type,m.subnet_mask,m.ip_address_hex,r.*
from tng_managedobject m, wtavayaaccesspoint r where m.uuid = r.uuid
GO
