Table: prismacloud_resource - Query Prisma Cloud resources using SQL

The prismacloud_resource table in Steampipe provides you with information about resources within Prisma Cloud. This table allows security engineers, cloud administrators, and compliance officers to query resource-specific details, including the resource's name, ID, description, and associated metadata. You can utilize this table to gather insights on resources, such as their modification history, associated members, and types. The schema outlines various attributes of the Prisma Cloud resource, including the resource ID, name, and last modification details.

Table Usage Guide

The prismacloud_resource table in Steampipe provides detailed information about resources within Prisma Cloud. This table allows you to query details such as the resource's name, ID, description, and modification history, enabling you to effectively manage and audit your resources.

Examples

Basic info

Retrieve basic information about Prisma Cloud resources, such as resource ID, name, type, and description. This query helps you to understand the overall configuration and details of your resources.

select
  id,
  name,
  resource_list_type,
  description
from
  prismacloud_resource;

select
  id,
  name,
  resource_list_type,
  description
from
  prismacloud_resource;

List of resources modified by a specific user

Get a list of all resources that were last modified by a specific user. This is useful for tracking changes made by administrators or team members.

select
  id,
  name,
  last_modified_by,
  last_modified_ts
from
  prismacloud_resource
where
  last_modified_by = 'admin_user';

select
  id,
  name,
  last_modified_by,
  last_modified_ts
from
  prismacloud_resource
where
  last_modified_by = 'admin_user';

Resources with specific types

Identify resources of a specific type. This helps in organizing and managing different categories of resources within Prisma Cloud.

select
  id,
  name,
  resource_list_type
from
  prismacloud_resource
where
  resource_list_type = 'compute';

select
  id,
  name,
  resource_list_type
from
  prismacloud_resource
where
  resource_list_type = 'compute';

Resources without a description

Identify resources that are missing a description to ensure all assets are well-documented.

select
  id,
  name,
  description
from
  prismacloud_resource
where
  description is null
  or description = '';

select
  id,
  name,
  description
from
  prismacloud_resource
where
  description is null
  or description = '';

Get members associated with each resource

Retrieve details about members associated with each resource. This can help in understanding who has access to which resources.

select
  id,
  name,
  members
from
  prismacloud_resource;

select
  id,
  name,
  members
from
  prismacloud_resource;

Count of resources by type

Get a count of resources by their type to understand the distribution of different resource types within your environment.

select
  resource_list_type,
  count(*) as resource_count
from
  prismacloud_resource
group by
  resource_list_type;

select
  resource_list_type,
  count(*) as resource_count
from
  prismacloud_resource
group by
  resource_list_type;

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- prismacloud

You can pass the configuration to the command with the --config argument:

steampipe_export_prismacloud --config '<your_config>' prismacloud_resource