[dbo].[wvIBM_Access_Point]
CREATE VIEW wvIBM_Access_Point 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, wtIBM_Access_Point r where m.uuid = r.uuid
GO
