Level: Major

Purpose: Notify operations when an ExteNet INOC user changes their user account profile/visibility.

Scenario: A INOC user has changed their account to allow them access to additional areas of the IDMS suite. INOC users should have the following permissions:

• Profile: NOC (where visibility_profile_uuid = '824fec12-5487-430b-9a2f-e5eb38caa434')
• Visibility: ExteNet (where business_profile_uuid = '785580bb-9c2a-422e-b0f9-f531ef76a9e6')

Resolution: Restore profile to NOC & visibility to Extenet. If any INOC user has upgraded to an Admin profile this needs to be brought to the attention of Anthony or Loughlin.

Manual Action Steps: Query to return profile & visibility of User/s causing alert.

select 
    ap.username,
	concat(first_name, ' ', last_name) as name,
    ap.email_address,
    bp.name as profile,
	vp.name as visibility
from
    userprofile.app_user ap
	join userprofile.visibility_profile vp
	on vp.uuid = ap.visibility_profile_uuid
	join userprofile.business_profile bp
	on bp.uuid = ap.business_profile_uuid
where
    ap.email_address like '%inoc%'
        and (ap.visibility_profile_uuid != '824fec12-5487-430b-9a2f-e5eb38caa434'
        or ap.business_profile_uuid != '785580bb-9c2a-422e-b0f9-f531ef76a9e6');

Auto Clear: Will clear when all INOC users have NOC profile & ExteNet visibility.