/* ************************** 14396 end **************/



/* ************************** 14470 begin **************/
/* New view to get the correct sd status */
create view usd_v_target_status
as
select agt.object_uuid,
            object_status = case                  
            /* NOTE: THE FOLLOWING CASE ORDER IS IMPORTANT AND MUST NOT BE CHANGED
            Not installed */
            when agtc.agent_comp_id is NULL then 0x10000000
            /* Other locks from usd_target */
            when (tgt.locks & 0x87 > 0) then tgt.locks & 0x87
            /* Pre-registered */
            when (last_run_date is NULL or last_run_date < 0) then 0x20000000
            /* Operational */
            else 0
        end
from ca_agent agt left join usd_target tgt on agt.object_uuid  = tgt.objectid left outer join ca_agent_component agtc on agt.object_uuid = agtc.object_uuid and (agtc.agent_comp_id = 40 or agtc.agent_comp_id = 46)
where agt.agent_type IN (1,4)
GO
GRANT SELECT ON  [dbo].[usd_v_target_status] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_target_status] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_target_status] TO [ca_itrm_group_ams]
GO