Life, Tech and Travel

Private VLANs Overview by Keith Barker

# TOTAL LDAP USER COUNT SELECT count(*) from cwd_user where directory_id = 3; # LDAP ACTIVE USERS SELECT count(*) from cwd_user where directory_id = 3 AND active = 1; # LDAP INACTIVE USERS SELECT count(*) from cwd_user where directory_id = 3 AND active = 0; # INTERNAL ACTIVE USER COUNT SELECT count(*) from cwd_user where directory_id = 1 AND active = 1; # INTERNAL - INACTIVE USER COUNT SELECT count(*) from cwd_user where directory_id = 1 AND active = 0; # DEACTIVATE ALL INTERNAL ACCOUNTS UPDATE cwd_user SET active = 0 WHERE directory_id = 1; # ACTIVE YOUR INTERNAL JIRA ADMIN ACCOUNT "jira-admin" UPDATE cwd_user SET active = 1  where user_name = "jira-admin"; # DEACTIVATE LDAP ACCOUNTS UPDATE cwd_user SET active = 0 WHERE directory_id = 3; # ACTIVATE YOUR JIRA-ADMIN LDAP ACCOUNTS UPDATE cwd_user SET active = 1  where user_name IN ("jlopez", "jsmith");