Community
Questions Library
Docs
Blog
Events
Swag
Github
Slack
JupiterOne
Discussions
Release Notes
Contact Us
Example Data Security J1QL Queries - AskJ1 Community
<main> <article class="userContent"> <h2 data-id="show-all-resources-without-a-data-classification-tag">Show all resources without a data classification tag {}?</h2> <pre class="code codeBlock" spellcheck="false" tabindex="0">Find (Host|DataStore) with classification = undefined </pre> <p>Returns a count instead:</p> <pre class="code codeBlock" spellcheck="false" tabindex="0">Find (Host|DataStore) with classification = undefined as e return count(e) </pre> <h2 data-id="show-all-resources-without-a-data-classification-tag-in-vpc-with-tag">Show all resources without a data classification tag in VPC with tag {}?</h2> <p>Filter by a tag on the VPC:</p> <pre class="code codeBlock" spellcheck="false" tabindex="0">Find (Host|DataStore|Workload) with classification = undefined that relates to aws_vpc with tag.{tagName} = '{tagValue}' </pre> <p>Filter by vpcId or name:</p> <pre class="code codeBlock" spellcheck="false" tabindex="0">Find (Host|DataStore|Workload) with classification = undefined that relates to aws_vpc with vpcId='{vpcId}' or name='{name}' </pre> <h2 data-id="what-are-all-the-resources-without-encryption-with-data-security-tag-restricted">What are all the resources without encryption with data security tag '{restricted}'?</h2> <pre class="code codeBlock" spellcheck="false" tabindex="0">Find DataStore with encrypted!=true and classification='restricted' </pre> <p>Sometimes it is also interesting to find unencrypted data that is non-public:</p> <pre class="code codeBlock" spellcheck="false" tabindex="0">Find DataStore with encrypted!=true and classification!='Public' </pre> </article> </main>