CREATE VIEW dts_dtasset_view ( object_id,
                           label,
                asset_host_name,
                asset_host_uuid,
                asset_primary_mac_address,
                asset_primary_network_address,
                asset_usage_list,
                asset_source_uuid,
                asset_ip_address,
                asset_primary_subnet_mask,
                                   asset_class_id             /* new column */
                             )
    AS
    SELECT ca_discovered_hardware.dis_hw_uuid,
           ca_discovered_hardware.label,
           ca_discovered_hardware.host_name,
           ca_discovered_hardware.host_uuid,
           ca_discovered_hardware.primary_mac_address,
           ca_discovered_hardware.primary_network_address,
           ca_discovered_hardware.usage_list,
           ca_discovered_hardware.asset_source_uuid,
           ca_agent.ip_address,
                   ca_discovered_hardware.primary_subnet_mask,
                   ca_discovered_hardware.class_id
    FROM ( ca_discovered_hardware LEFT OUTER JOIN ca_agent ON ca_discovered_hardware.dis_hw_uuid = ca_agent.object_uuid)
GO
GRANT SELECT ON  [dbo].[dts_dtasset_view] TO [ams_group]
GRANT SELECT ON  [dbo].[dts_dtasset_view] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[dts_dtasset_view] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[dts_dtasset_view] TO [upmuser_group]
GO