Skip to content
open.securityopen.securityBeta

Enterprise SQL task catalog.

127 public tasks · ISPM-Enterprise-SQL@v1

Tasks

127 tasks

  1. Are there users with access keys that were created during setup but never used?

    aws-access-keys-were-created
    Dormant & stalePlatform-levelMedium
    AWS
  2. Do any active access keys have a creation date older than 90 days?

    aws-active-access-keys-creation
    Dormant & stalePlatform-level
    AWS
  3. Which active access keys are older than 90 days?

    aws-active-access-keys-older
    Dormant & stalePlatform-level
    AWS
  4. Is the AWSSupportAccess AWS managed policy attached to at least one principal (user, group, or role)?

    aws-awssupportaccess-managed-policy-attached
    Privilege & exposurePlatform-level
    AWS
  5. Are there users who do not belong to the common IAM group?

    aws-belong-common-group
    Inventory & visibilityPlatform-levelMedium
    AWS
  6. Do any IAM users have both a console password and one or more active API keys?

    aws-both-console-password-one
    Credential hygienePlatform-levelMedium
    AWS
  7. Which IAM users have console passwords enabled but no MFA?

    aws-console-passwords-but-mfa
    Auth posturePlatform-level
    AWS
  8. Do any customer-managed policies allow a specific service:action on all resources (*)?

    aws-customer-managed-policies-allow-specific
    Privilege & exposurePlatform-level
    AWS
  9. Are there customer-managed policies with no attachments?

    aws-customer-managed-policies-attachments
    Privilege & exposurePlatform-level
    AWS
  10. Do any attached customer-managed policies grant permissions other than sts:AssumeRole?

    aws-customer-managed-policies-grant-permissions
    Privilege & exposurePlatform-level
    AWS
  11. Do any customer-managed IAM policies use NotAction in Allow statements?

    aws-customer-managed-policies-use-notaction
    Privilege & exposurePlatform-level
    AWS
  12. Are there EC2 service roles that are not attached to any running EC2 instances?

    aws-ec2-service-roles-attached
    Privilege & exposurePlatform-levelMedium
    AWS
  13. Do any IAM groups have inline policies attached?

    aws-groups-inline-policies-attached
    Privilege & exposurePlatform-level
    AWS
  14. Is a hardware MFA device enabled on the root account?

    aws-hardware-mfa-device-root
    Auth posturePlatform-level
    AWS
  15. List high-privilege non-human identities by type (AWS execution roles, AWS cross-account roles).

    aws-high-privilege-non-human-identities-type
    Inventory & visibilityPlatform-level
    AWS
  16. Do any human IAM users have policies attached directly (inline or managed)?

    aws-human-policies-attached-directly
    Privilege & exposurePlatform-level
    AWS
  17. Are there users with inline or managed policies attached directly?

    aws-inline-managed-policies-attached
    Privilege & exposurePlatform-level
    AWS
  18. Do any user inline policies allow actions other than sts:AssumeRole?

    aws-inline-policies-allow-actions
    Privilege & exposurePlatform-level
    AWS
  19. Do any inline policies in IAM identities use NotAction with an Allow effect?

    aws-inline-policies-identities-use
    Privilege & exposurePlatform-level
    AWS
  20. Are there any managed policies that allow Action = "*" and Resource = "*"?

    aws-managed-policies-allow-action
    Privilege & exposurePlatform-level
    AWS
  21. Is MFA enabled on the root account?

    aws-mfa-root
    Auth posturePlatform-level
    AWS
  22. Do any users have more than one active access key?

    aws-one-active-access-key
    Auth posturePlatform-level
    AWS
  23. Do all password-enabled IAM users have MFA enabled?

    aws-password-enabled-mfa
    Auth posturePlatform-level
    AWS
  24. Is password expiration enabled in the IAM password policy?

    aws-password-expiration-policy
    Credential hygienePlatform-level
    AWS
  25. Does the account password policy enforce password expiration and set MaxPasswordAge ≤ 90 days?

    aws-password-policy-enforce-expiration
    Credential hygienePlatform-level
    AWS
  26. Does the password policy prevent the reuse of previous passwords?

    aws-password-policy-prevent-reuse
    Credential hygienePlatform-level
    AWS
  27. Is the IAM password policy configured to require at least 14 characters?

    aws-password-policy-require-least
    Credential hygienePlatform-level
    AWS
  28. Does the IAM password policy require at least one lowercase letter?

    aws-password-policy-require-least-2
    Credential hygienePlatform-level
    AWS
  29. Does the password policy require at least one numeric character?

    aws-password-policy-require-least-3
    Credential hygienePlatform-level
    AWS
  30. Does the password policy require at least one special character?

    aws-password-policy-require-least-4
    Credential hygienePlatform-level
    AWS
  31. Does the IAM password policy require at least one uppercase letter?

    aws-password-policy-require-least-5
    Credential hygienePlatform-level
    AWS
  32. Are there any users with passwords or access keys that have not been used in over 90 days and are still enabled?

    aws-passwords-access-keys-used
    Dormant & stalePlatform-levelMedium
    AWS
  33. Do any policies deny user actions on group resources rather than on the users themselves?

    aws-policies-deny-actions-group
    Privilege & exposurePlatform-level
    AWS
  34. Do any IAM roles allow an AWS principal to perform the sts:AssumeRole action without requiring MFA in their trust policies?

    aws-roles-allow-sts-assumerole
    Privilege & exposurePlatform-level
    AWS
  35. Do any IAM roles have inline policies that allow a specific service:action on all resources (*)?

    aws-roles-inline-policies-allow
    Privilege & exposurePlatform-level
    AWS
  36. Do any IAM roles have inline policies attached?

    aws-roles-inline-policies-attached
    Privilege & exposurePlatform-level
    AWS
  37. Which roles have inline policies attached?

    aws-roles-inline-policies-attached-2
    Privilege & exposurePlatform-level
    AWS
  38. Which IAM roles trust external accounts (not in AWS Organizations)?

    aws-roles-trust-external-accounts
    Privilege & exposurePlatform-level
    AWS
  39. Do any IAM roles have trust policies that allow principals from other accounts without requiring MFA or an External ID?

    aws-roles-trust-policies-allow
    Privilege & exposurePlatform-level
    AWS
  40. Are there IAM roles whose trust policies allow any AWS principal (e.g., Principal set to "*")?

    aws-roles-trust-policies-allow-2
    Privilege & exposurePlatform-level
    AWS
  41. Does the root account have any active X.509 certificates?

    aws-root-active-509-certificates
    Auth posturePlatform-level
    AWS
  42. Does the root account have any active access keys?

    aws-root-active-access-keys
    Auth posturePlatform-level
    AWS
  43. Is root MFA enforced?

    aws-root-mfa-enforced
    Auth posturePlatform-level
    AWS
  44. Has the root account been used within the last 90 days?

    aws-root-used-last-90
    Dormant & stalePlatform-level
    AWS
  45. List secrets in AWS per resource and per owner type (root, IAM user, role).

    aws-secrets-resource-owner-type
    Inventory & visibilityPlatform-level
    AWS
  46. Do any service users (identified by membership in a service-user group) have console passwords enabled?

    aws-service-identified-membership-service-user
    Credential hygienePlatform-levelMedium
    AWS
  47. Which users have AWS SSO access but don't have a corresponding employee record in our BambooHR system?

    cross-access-but-don-corresponding
    Cross-vendor explorationCross-platformMedium
    AWS · BambooHR · Okta
  48. According to BambooHR, do any employees classified as contractors, external, or freelancers have AWS SSO account?

    cross-according-employees-classified-contractors
    Cross-vendor explorationCross-platformMedium
    AWS · BambooHR · Okta
  49. Are there any Google Workspace accounts still active for employees who have been terminated?

    cross-accounts-active-employees-terminated
    Lifecycle & offboardingCross-platformHard
    BambooHR · Google Workspace · Okta
  50. Are there any Okta accounts that don't match a current employee or contractor in BambooHR?

    cross-accounts-don-match-current
    Cross-vendor explorationCross-platformMedium
    BambooHR · Okta
  51. List AWS IAM Users who have an active Access Key (Secret) older than 90 days but have never logged into Okta.

    cross-active-access-key-secret
    Dormant & staleCross-platformMedium
    AWS · Okta
  52. Are there any active GitHub accounts for users who have been disabled in Azure AD?

    cross-active-accounts-disabled
    Lifecycle & offboardingCross-platformMedium
    Azure · GitHub
  53. List all users who have an active account in Google Workspace but are synced through Okta.

    cross-active-but-synced-through
    Cross-vendor explorationCross-platformMedium
    Google Workspace · Okta
  54. Which active Okta users who are GitHub organization members have two-factor authentication disabled on GitHub, broken down by their organization role (MEMBER vs ADMIN)?

    cross-active-organization-members-two-factor
    Auth postureCross-platformMedium
    GitHub · Okta
  55. Which active Okta users that also have an AWS IAM Identity Store identity have no phishing-resistant MFA factor enrolled?

    cross-active-phishing-resistant-mfa-factor
    Auth postureCross-platformHard
    AWS · Okta
  56. Which active Okta users are provisioned in AWS Identity Store, hold ADMIN permission on at least one GitHub repository, and have a Google Workspace administrator role?

    cross-active-provisioned-identity-store
    Privilege & exposureCross-platformHard
    AWS · GitHub · Google Workspace · Okta
  57. Which active Google Workspace users have role assignments, and do they have a matching Okta identity (including Okta status)?

    cross-active-role-assignments-matching
    Cross-vendor explorationCross-platformHard
    Google Workspace · Okta
  58. Who has admin access in Mongo that wasn't provisioned through Okta?

    cross-admin-access-wasn-provisioned
    Cross-vendor explorationCross-platformMedium
    MongoDB Atlas · Okta
  59. Which AWS SSO users with admin-level access have an inactive or missing Okta account?

    cross-admin-level-access-inactive-missing
    Cross-vendor explorationCross-platformHard
    AWS · Okta
  60. Which Google Workspace administrators also hold a primitive Owner or Editor role in GCP?

    cross-administrators-also-hold-primitive
    Privilege & exposureCross-platformMedium
    GCP · Google Workspace
  61. Who are the Google Workspace admins that aren't listed as admins in Okta?

    cross-admins-aren-listed
    Cross-vendor explorationCross-platformHard
    Google Workspace · Okta
  62. Who are the Azure AD admins that aren't listed as admins in Okta?

    cross-admins-aren-listed-2
    Cross-vendor explorationCross-platformHard
    Azure · Okta
  63. Can anyone without MFA can access our production systems S3 Buckets or AWS Databases?

    cross-anyone-without-mfa-access
    Auth postureCross-platformHard
    AWS · Okta
  64. Are there any AWS IAM credentials whose owning IAM user cannot be traced back to an active BambooHR employee through Okta?

    cross-credentials-owning-cannot-traced
    Cross-vendor explorationCross-platformHard
    AWS · BambooHR · Okta
  65. Are there any users that are deactivated in Okta but still active in AWS?

    cross-deactivated-but-active
    Lifecycle & offboardingCross-platformHard
    AWS · Okta
  66. Are there deprovisioned users in Okta with admin access in GitHub?

    cross-deprovisioned-admin-access
    Lifecycle & offboardingCross-platformHard
    GitHub · Okta
  67. Are there any disabled Okta users who still have active Google Workspace accounts?

    cross-disabled-active-accounts
    Lifecycle & offboardingCross-platformMedium
    Google Workspace · Okta
  68. Which former employees still own Google Workspace documents (private or shared drives) after their termination?

    cross-documents-owned-longer-working
    Lifecycle & offboardingCross-platformHard
    BambooHR · Google Workspace
  69. Which employees have active admin role assignments in Okta and what is their department in BambooHR?

    cross-employees-active-admin-role
    Inventory & visibilityCross-platformHard
    BambooHR · Okta
  70. Which employees marked as terminated in BambooHR have authored commits in GitHub after their recorded termination date?

    cross-employees-marked-terminated-authored
    Lifecycle & offboardingCross-platformMedium
    BambooHR · GitHub
  71. Which users exist in both EntraID and GWS but don't have 2SV enforced in Google Workspace?

    cross-exist-both-entraid-but
    Auth postureCross-platformMedium
    Azure · Google Workspace
  72. Are there any external email addresses with access to any shared GWS files that are not managed through Okta?

    cross-external-email-addresses-access
    Cross-vendor explorationCross-platformMedium
    Google Workspace · Okta
  73. Which GitHub organization members without MFA enabled also have AWS admin-level permissions or MongoDB Atlas admin roles (ORG_OWNER, ORG_BILLING_ADMIN, GROUP_OWNER)?

    cross-find-without-mfa-identify
    Cross-vendor explorationCross-platformHard
    AWS · GitHub · MongoDB Atlas
  74. Which AWS SSO users haven't logged into Okta in 90 days but are still active in Okta?

    cross-haven-logged-90-days
    Dormant & staleCross-platformMedium
    AWS · Okta
  75. Which users haven't used GWS for 90 days but still listed as active in Okta?

    cross-haven-used-90-days
    Dormant & staleCross-platformMedium
    Google Workspace · Okta
  76. List high-privilege human identities by type (AWS IAM, Okta).

    cross-high-privilege-human-identities-type
    Inventory & visibilityCross-platformMedium
    AWS · Okta
  77. Show me users who left the company but still have GitHub access.

    cross-left-company-but-access
    Lifecycle & offboardingCross-platformMedium
    BambooHR · GitHub
  78. Are any marketing or finance users granted write access to our code base?

    cross-marketing-finance-granted-write
    Privilege & exposureCross-platformHard
    BambooHR · GitHub
  79. Which Okta users have the most publicly accessible files in Google Workspace?

    cross-most-publicly-accessible-files
    Privilege & exposureCross-platformHard
    Google Workspace · Okta
  80. Do any non-IT or non-R&D employees have super admin access to Google Workspace?

    cross-non-it-non-r-employees-super
    Privilege & exposureCross-platformMedium
    BambooHR · Google Workspace
  81. Do any offboarded employees still have active AWS accounts?

    cross-offboarded-employees-active-accounts
    Lifecycle & offboardingCross-platformHard
    AWS · BambooHR
  82. Are there any GitHub org members with no matching BambooHR employee record?

    cross-org-members-matching-employee
    Cross-vendor explorationCross-platformMedium
    BambooHR · GitHub
  83. Are there any GitHub org members not provisioned through Okta?

    cross-org-members-provisioned-through
    Cross-vendor explorationCross-platformMedium
    GitHub · Okta
  84. Which GitHub organization members have no corresponding identity in Azure AD?

    cross-organization-members-corresponding-identity
    Cross-vendor explorationCross-platformMedium
    Azure · GitHub
  85. Which GitHub organization members hold GCP primitive roles (Owner or Editor), and what is their GitHub role?

    cross-organization-members-hold-primitive
    Privilege & exposureCross-platformMedium
    GCP · GitHub
  86. Which GitHub organization members with two-factor authentication disabled also hold direct user-level IAM role bindings in GCP, and what privileged roles do they have?

    cross-organization-members-two-factor-authentication
    Privilege & exposureCross-platformMedium
    GCP · GitHub
  87. Which GitHub users are Organization Owners but do not have a corresponding active account in Okta?

    cross-organization-owners-but-corresponding
    Cross-vendor explorationCross-platformMedium
    GitHub · Okta
  88. Which Google Workspace users with GCP IAM permissions can bypass MFA?

    cross-permissions-bypass-mfa
    Auth postureCross-platformMedium
    GCP · Google Workspace
  89. Which Azure AD users registered only with weak MFA methods (SMS or phone call) are also GitHub organization members?

    cross-registered-only-weak-mfa
    Auth postureCross-platformHard
    Azure · GitHub · Okta
  90. List all Super Admins (for periodic review).

    cross-super-admins-periodic-review
    Inventory & visibilityCross-platformMedium
    Google Workspace · Okta
  91. Are there any MongoDB Atlas users who are terminated in BambooHR or deactivated in Okta?

    cross-terminated-deactivated
    Lifecycle & offboardingCross-platformHard
    BambooHR · MongoDB Atlas · Okta
  92. Which terminated employees still have AWS SSO access?

    cross-terminated-employees-access
    Lifecycle & offboardingCross-platformHard
    AWS · BambooHR · Okta
  93. Are there any terminated employees who have both an active Google Workspace account and direct user-level IAM role bindings in our GCP projects?

    cross-terminated-employees-both-active
    Lifecycle & offboardingCross-platformHard
    BambooHR · Google Workspace
  94. Which terminated employees have not been fully offboarded from all connected systems (Okta, Google Workspace, Azure AD, or AWS SSO)?

    cross-terminated-employees-fully-offboarded
    Lifecycle & offboardingCross-platformHard
    AWS · Azure · BambooHR · Google Workspace · Okta
  95. Do any terminated employees own publicly accessible files in their Google Drive personal storage?

    cross-terminated-employees-own-publicly
    Lifecycle & offboardingCross-platformHard
    BambooHR · Google Workspace
  96. Which terminated external workers (non-Osbench Labs employees) in BambooHR still have an active Okta account or GitHub organization membership?

    cross-terminated-external-workers-non-osbench
    Lifecycle & offboardingCross-platformHard
    BambooHR · GitHub · Okta
  97. Which terminated users still have read permissions to any shared GWS documents not owned by them?

    cross-terminated-read-permissions-shared
    Lifecycle & offboardingCross-platformMedium
    BambooHR · Google Workspace
  98. Which terminated users still have write permissions to any shared GWS documents not owned by them?

    cross-terminated-write-permissions-shared
    Lifecycle & offboardingCross-platformMedium
    BambooHR · Google Workspace
  99. Which Google Workspace admin users are missing 2-Step Verification?

    gws-admin-missing-2-step-verification
    Auth posturePlatform-level
    Google Workspace
  100. Are all domains configured to restrict third-party applications and disallow less-secure apps?

    gws-domains-restrict-third-party-applications
    Auth posturePlatform-level
    Google Workspace
  101. Are Google Workspace domains configured with Single Sign-On ensuring that post-SSO verification is enabled for the primary SSO profile?

    gws-domains-single-sign-on-ensuring
    Auth posturePlatform-levelMedium
    Google Workspace
  102. Are all users labeled as sensitive enrolled in Google's Advanced Protection Program?

    gws-labeled-sensitive-enrolled-advanced
    Auth posturePlatform-level
    Google Workspace
  103. Are there any users whose MFA method is configured as SMS or voice call?

    gws-mfa-method-sms-voice
    Auth posturePlatform-level
    Google Workspace
  104. Is the minimum password length configured to 15 characters or more?

    gws-minimum-password-length-15
    Credential hygienePlatform-level
    Google Workspace
  105. Is the minimum password length at least 12 characters?

    gws-minimum-password-length-least
    Credential hygienePlatform-level
    Google Workspace
  106. Is the new user 2-Step Verification enrollment period configured between 1 and 7 days for each organization unit?

    gws-new-2-step-verification-enrollment
    Auth posturePlatform-level
    Google Workspace
  107. Is the number of Google Workspace Super Admin users between 2 and 8 inclusive?

    gws-number-super-admin-inclusive
    Privilege & exposurePlatform-levelMedium
    Google Workspace
  108. Are password expiration policies disabled for all organizational units?

    gws-password-expiration-policies-disabled
    Credential hygienePlatform-level
    Google Workspace
  109. Is the password policy configured to be enforced at the next sign-in for all organizational units?

    gws-password-policy-enforced-next
    Credential hygienePlatform-level
    Google Workspace
  110. Is password reuse disabled for all organizational units?

    gws-password-reuse-disabled
    Credential hygienePlatform-level
    Google Workspace
  111. Do all privileged accounts (Super Admins and other high-privilege roles) authenticate with Google credentials and use phishing-resistant MFA?

    gws-privileged-accounts-super-admins
    Auth posturePlatform-level
    Google Workspace
  112. Are account recovery options disabled for all users who are not Super Admins?

    gws-recovery-options-disabled-super
    Auth posturePlatform-level
    Google Workspace
  113. Are self-service account recovery options disabled for users assigned the Super Admin role?

    gws-self-service-recovery-options-disabled
    Auth posturePlatform-levelHard
    Google Workspace
  114. Which Okta users are active but have not signed in for over 90 days?

    okta-active-but-signed-90
    Dormant & stalePlatform-level
    Okta
  115. Are there any active users who are no longer members of any group assigned through an Application or IdP?

    okta-active-longer-members-group
    Dormant & stalePlatform-levelHard
    Okta
  116. Which active Okta users have not signed in for more than 90 days?

    okta-active-signed-90-days
    Dormant & stalePlatform-level
    Okta
  117. Which applications' default access rules do not require MFA?

    okta-applications-default-access-rules
    Auth posturePlatform-level
    Okta
  118. Which applications have mfa_required set to FALSE or NULL?

    okta-applications-mfa-required-false
    Auth posturePlatform-level
    Okta
  119. Which Okta connections lack signed and encrypted SAML assertions?

    okta-connections-lack-signed-encrypted
    Auth posturePlatform-level
    Okta
  120. Do any identity providers (IdPs) lack signed or encrypted SAML assertions?

    okta-identity-providers-idps-lack
    Auth posturePlatform-level
    Okta
  121. Are any legacy authentication factors (SMS, voice, email, OTP) enabled?

    okta-legacy-authentication-factors-sms
    Auth posturePlatform-level
    Okta
  122. Are MFA policies missing phishing-resistant authenticators?

    okta-mfa-policies-missing-phishing-resistant
    Auth posturePlatform-levelMedium
    Okta
  123. Does the password policy enforce a minimum length of at least 12 characters and require uppercase letters, lowercase letters, numbers and symbols?

    okta-password-policy-enforce-minimum
    Credential hygienePlatform-level
    Okta
  124. Which sign-on policies exceed a 120-minute session lifetime?

    okta-sign-on-policies-exceed-120-minute
    Auth posturePlatform-level
    Okta
  125. Which sign-on policies have a reauthentication interval greater than 480 minutes (8 hours) or have no reauthentication interval set?

    okta-sign-on-policies-reauthentication-interval
    Auth posturePlatform-level
    Okta
  126. Are there any sign-on policies where the maximum session lifetime (max_session_lifetime_minutes) exceeds 120 minutes (2 hours)?

    okta-sign-on-policies-where-maximum
    Auth posturePlatform-level
    Okta
  127. Are there any sign-on policies where require_mfa_each_signin is FALSE or NULL?

    okta-sign-on-policies-where-require
    Auth posturePlatform-level
    Okta