Extract Organization list data in ASDC

[rafinkanisa]

As we'll be re-activating the ASDC, we'll have to review which organization will be deactivated once the re-activated ASDC will be published.

Kindly extract the organization data list which exists in ASDC at the moment. Only extract "Active" users in ASDC

[dodiws]

Query user count group by org_name_status, org_type, org_acronym, organization:

  select 
      org_name_status,
      org_type,
      org_acronym,
      organization,
      count( *)
  from people_profile   
  where 
      username not in ('AnonymousUser','tester')
      and is_active = true
  group by 1,2,3,4
  order by 1,2,3,4,5

Query users with empty organization or org_acronym or org_type or org_name_status:

    select *
    from people_profile 
    where 
        organization is null or trim(organization) = ''
        or org_acronym is null or trim(org_acronym) = ''
        or org_type is null or trim(org_type) = ''
        or org_name_status is null or trim(org_name_status) = ''
        and username not in ('AnonymousUser','tester')
        and is_active = true
    order by organization, username

[rafinkanisa]

Already giving ryan the list. Will be waiting for his feedback of which organization shall be deactivated

[rafinkanisa]

Giving list to Ben and Alex. Waiting for feedback