====== Query with jq ======

Just a fabricated joke to have a page starting with ''Q''

<code bash>
STANDARDS=$(aws securityhub list-standards-control-associations  --security-control-id ${CONTROL_ID} | jq -r .StandardsControlAssociationSummaries.[].StandardsArn)
</code>

Seriously, jq is a really useful Linux command to process and extract values from JSON formatted data - See [[linux:jq|jq - json parser]]

Sadly, or more likely serves you right, jq is a linux and not windows command. Just one more reason to dump windows. [[crashed-windows:start|Crashed Windows pictures]]


===== Parse AWS cli output =====


<code>
aws lambda list-functions | jq '[.Functions[] | {FunctionName, Description,  Runtime}]'


[
  {
    "FunctionName": "UpdateStackFunction",
    "Runtime": "python3.8"
  },
  {
    "FunctionName": "ExtractDict",
    "Runtime": "python3.9"
  }

.....
]
</code>