I need a SQL Query to Extract data for all the reports which have security settings set to accounts by employee names(Usernames) and also the account status (disabled/deactivated/active).
Goals:
1) Differentiate Username(Login) Accounts from Group Accounts. ( Both hold roles in the security configuration)
2) Finding if the User Account is Active or Inactive