CREATE VIEW wvDomain AS Select m.name,m.label,m.address,m.address_type,m.class_name,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,r.* from tng_managedobject m, wtDomain r where m.uuid = r.uuid
GO
[dbo].[wvDomain]