-
Looking for Okta users with no JAMF enrolled devices please
Can you provide an example query showing Okta users with no JAMF enrolled devices please?
-
Query to find all public IPs in our AWS infrastructure, including EC2s, load balancers & API gateway
I want to use a JupiterOne query to find all public IPs in our AWS infrastructure. These public IPs this could be on EC2s, but they could also be on load balancers or API gateways.
-
How do I understand the deployment status of assets using J1QL?
I’m trying to search by filtering the property extensionAttribute.Deployment status, but it fails as it has a space. How do you escape the space in the name of the property?
-
Query to see if an AWS Security Group is referencing a particular subnet?
Is it possible to use a JupiterOne query to see if an AWS Security Group is referencing a particular subnet?
-
Can I do a "group by" for my JupiterOne query results?
Can I do a "group by" for my JupiterOne query results? I’d like to find all datastores and count them by a tag using "group by".
-
My query isn't working - understanding the age for AWS access keys
I would like to understand the age of my AWS access keys for AWS IAM users to understand key management practices. More specifically, I am trying to write a J1QL query to find AWS access keys created soon after the account was created. I tried FIND aws_iam_access_key AS k0
THAT RELATES TO aws_iam_user AS u0 WHERE…
-
Query for Elastic IPs from our Network Address Translation (NAT) gateways across all AWS accounts
Is there a quick JupiterOne query that I can run to get all of the Elastic IPs from our Network Address Translation (NAT) gateways across all AWS accounts?
-
What are the differences between database and datastore?
What are the difference between a"Database" and "Datastore" in JupiterOne's asset inventory?
-
How do I check the "freshness" of asset properties and data?
How do I check the "freshness" of asset properties and data?
-
"How do I know how many entities, or assets, are in my JupiterOne account for each integration?
How do I know how many entities, or assets, are in my JupiterOne account for each integration? More specifically, is it possible to view billable entity count by integration?