CREATE VIEW wvManagedPC AS Select m.name,m.label,m.address,m.status_no,m.hidden,m.propagate_status,m.severity,m.posted,m.acknowledge,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.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.address_type,m.class_name,m.alarmset_name,m.autoarrange_type,m.weight,r.* from tng_managedobject m, wtManagedPC r where m.uuid = r.uuid
GO
GRANT SELECT ON [dbo].[wvManagedPC] TO [uniadmin]
GRANT SELECT ON [dbo].[wvManagedPC] TO [uniuser]
GRANT SELECT ON [dbo].[wvManagedPC] TO [wvadmin]
GRANT SELECT ON [dbo].[wvManagedPC] TO [wvuser]
GO
[dbo].[wvManagedPC]