Resilient One liners


Author(s): Anonymous | Created: 16 April 2019 | Last modified: 29 March 2024
Tested on: -

Resilient One-Liners

List of organizations and its users:

  • Login as resadmin
    # sudo su - postgres -c "psql co3 -c 'select monapp.orgs.org_id,org_name,org_enabled, monapp.principals.principal_id, principal_name,muser_display_name,muser_is_external from monapp.musers_orgs,monapp.orgs,monapp.musers,monapp.principals where principal_id = monapp.musers.muser_id and monapp.musers.muser_id = monapp.musers_orgs.muser_id and monapp.musers_orgs.org_id = monapp.orgs.org_id order by org_id, principal_id'"