CREATE VIEW dbo.wvAscendRouter AS SELECT a.name, a.label, a.address, a.class_name, a.interface_type, a.autoarrange_type, a.hidden, a.propagate_status, a.status_no, a.severity, a.tng_delete_flag, a.posted, a.acknowledge, a.ip_address_hex, a.mac_address, a.subnet_mask, a.date_ins, a.date_modify, a.alarmset_name, a.code_page, a.admin_status, a.DSM_Server, a.propagated_status_no, a.propagated_sev, a.DSM_Address, a.license_machine_type, a.create_bpv, a.override_imagelarge, a.override_imagesmall, a.override_imagedecal, a.override_imagetintbool, a.override_model, a.background_image, a.weight, a.weighted_severity, a.Max_Sev, a.user_reclass, a.Asset_uuid, a.source_repository, a.dnsname, a.last_seen_time, AMSServer, EMServer, b.* FROM dbo.tng_managedobject a, dbo.wtAscendRouter b where a.uuid = b.uuid
GO
GRANT SELECT ON [dbo].[wvAscendRouter] TO [uniadmin]
GRANT SELECT ON [dbo].[wvAscendRouter] TO [uniuser]
GRANT SELECT ON [dbo].[wvAscendRouter] TO [wvadmin]
GRANT SELECT ON [dbo].[wvAscendRouter] TO [wvuser]
GO
[dbo].[wvAscendRouter]