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:
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.