[dbo].[wvWireless_Domain]
CREATE VIEW wvWireless_Domain AS Select m.name,m.label,m.address, m.status_no,m.hidden,m.propagate_status,m.severity,m.posted, m.acknowledge,m.alarmset_name,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,m.address_type,m.interface_type,m.autoarrange_type,r.* from tng_managedobject m, wtWireless_Domain r where m.uuid = r.uuid
GO
