Prismacloud-cli

What's Changed
* Fix/fix rql issue by SimOnPanw in https://github.com/PaloAltoNetworks/prismacloud-cli/pull/118


**Full Changelog**: https://github.com/PaloAltoNetworks/prismacloud-cli/compare/v0.6.13...v0.6.14

What's Changed
* Added all-except-licenses option and progress bar by steven-deboer in https://github.com/PaloAltoNetworks/prismacloud-cli/pull/117

<img width="392" alt="image" src="https://user-images.githubusercontent.com/96180461/219343715-1f008e42-eecd-4813-8fd0-11df5cb27878.png">


**Full Changelog**: https://github.com/PaloAltoNetworks/prismacloud-cli/compare/v0.6.12...v0.6.13

Description

Added output option raw for raw json output without parsing.
Added filter by collection for output of stats vulnerabilities

Example

`pc --config -o raw stats vulnerabilities --collection "dvwa" | jq`

Motivation and Context

In some cases parsing to dataframe and then output as json is unwanted and does not show the requested output.

What's Changed

* Added output count which just returns the number of results found.
* Added option to rql command --file, to define a yaml file with rql queries to run

Use Case

The new --field parameter of the rql command can be used to parse a file with
RQL queries. This file needs to be in yaml format as the example below:


- name: Find all permissions granted to Users
query: config from iam where grantedby.cloud.entity.type = 'user'

- name: Find all permissions granted to Roles
query: config from iam where grantedby.cloud.entity.type = 'role'

- name: IAM identities that can delete DynamoDB tables
query: config from iam where action.name = 'dynamodb:DeleteTable'


Examples to use this:

`pc -o count rql --file ~/.prismacloud/my-important-queries.yaml`
`pc rql --file ~/.prismacloud/my-important-queries.yaml`

Sample output

Command

`pc -o markdown rql --file ~/.prismacloud/my-important-queries.yaml `

RQL Query name: Find all permissions granted to Roles
RQL Query: config from iam where grantedby.cloud.entity.type = 'role'
| id | sourcePublic | sourceCloudType | sourceCloudAccount | sourceCloudRegion |
|:-------------------------------|:---------------|:------------------|:---------------------|:--------------------|
| 7984fc7e5041b7439272897da5c948 | False | AWS | Pedro AWS Account | AWS Oregon |
| 538adb5f6ccea83434be64b9e3b882 | | | | |
| 2c47 | | | | |
| 3206a93cd56dc0d983f67a994a648a | False | AWS | Pedro AWS Account | AWS Oregon |
| 9a7e2f47f8a1d8851f37433312c1bc | | | | |
| a3d5 | | | | |

RQL Query name: Find all permissions granted to Groups
RQL Query: config from iam where grantedby.cloud.entity.type = 'group'
| id | sourcePublic | sourceCloudType | sourceCloudAccount | sourceCloudRegion |
|:-------------------------------|:---------------|:------------------|:---------------------|:--------------------|
| 177bef83192f13a4e11f439fa8f7bb | False | AWS | pete-aws | AWS Global |
| dc50ce83185092er44re4431d3cad0 | | | | |
| 19ce | | | | |
| 177bef83192f13aer11f4erfa8f7bb | False | AWS | pete-aws | AWS Global |
| dc50ce831850928ddfeb9461d3cad0 | | | | |
| 19ce | | | | |

RQL Query name: Show all INACTIVE identities and their allowed actions over the last specified number of days
RQL Query: config from iam where action.lastaccess.days > 90


New Contributors
* jjchavanne made their first contribution in https://github.com/PaloAltoNetworks/prismacloud-cli/pull/111

**Full Changelog**: https://github.com/PaloAltoNetworks/prismacloud-cli/compare/v0.6.10...v0.6.11

What's Changed
* bump prismacloud-api to 5.1.6 by SimOnPanw in https://github.com/PaloAltoNetworks/prismacloud-cli/pull/112


**Full Changelog**: https://github.com/PaloAltoNetworks/prismacloud-cli/compare/v0.6.9...v0.6.10

What's Changed
* add iam rql queries by SimOnPanw in https://github.com/PaloAltoNetworks/prismacloud-cli/pull/110


**Full Changelog**: https://github.com/PaloAltoNetworks/prismacloud-cli/compare/v0.6.8...v0.6.9