option to summarize exported mod results

[judell]

When I ran steampipe-mod-zoom-compliance the output was pretty overwhelming. Once I removed the preamble (https://github.com/turbot/steampipe/issues/981) and brought it into Excel, I found myself doing the following steps.

1. Remove the OK rows.
2. Remove all columns except reason and status
3. Sort by reason to reveal duplication

Maybe there could be a --summary csv that would do that?

The output is still somewhat daunting. This is for a new Zoom account I just created.

Help! I'm a busy guy, what are the priorities here?

Well, it turns out that @dboeke has helpfully summarized them: https://newsletter.turbot.com/p/the-control-freaks-guide-to-zoom. Nice! I'll file a PR to mention that in the doc.

[e-gineer]

Does “—output brief” provide what you need?

https://steampipe.io/docs/reference/cli-args#output-formats

[judell]

Missed that, sorry. <dopeslap/>

--brief does help:

wc -l zoom-full.txt 788

wc -l zoom-brief.txt 561

In both cases there are 66 alarms. That dedupes to these 59, so not as much duplication as I'd thought. (Although maybe in some cases there's alternative wording for the same thing?)

ALARM: Add a timestamp to the recording is disabled.
ALARM: Add co-hosts is disabled.
ALARM: Always display "Zoom Meeting" as the meeting topic is disabled.
ALARM: Always display "Zoom Meeting" as the meeting topic setting is locked.
ALARM: Always show meeting control toolbar is disabled.
ALARM: Annotation tools are enabled.
ALARM: Ask to record voice as notification is disabled.
ALARM: Auto saving chats is disabled.
ALARM: Automatic recording is none.
ALARM: Breakout room is disabled.
ALARM: Chat is enabled.
ALARM: Consecutive characters length set to 0.
ALARM: Encryption for 3rd party endpoints is disabled.
ALARM: Enhanced weak password detection setting is disabled.
ALARM: Ensure add watermark is disabled.
ALARM: Ensure add watermark setting is not locked.
ALARM: Ensure mute participants upon entry is disabled.
ALARM: Ensure mute participants upon entry setting is not locked.
ALARM: Entry for users from specific countries/regions is disabled.
ALARM: File transfer is enabled.
ALARM: Have at least 1 letter setting is disabled.
ALARM: Have at least 1 number setting is disabled.
ALARM: Have at least 1 special character setting is disabled.
ALARM: Have special character setting is disabled.
ALARM: Have uppercase and lowercase characters is disabled.
ALARM: Have uppercase and lowercase characters setting is disabled.
ALARM: Hide billing information from administrators is disabled.
ALARM: Host can delete cloud recordings is enabled.
ALARM: Import photos from devices is enabled.
ALARM: Join Before Host setting is not locked.
ALARM: Meeting reactions is enabled.
ALARM: Method is not set.
ALARM: Minimum passcode length set to 0.
ALARM: Minimum password length set to 0.
ALARM: Only authenticated users can join meetings is disabled.
ALARM: Only show default email when sending email invites is disabled.
ALARM: Only the host can download cloud recordings is disabled.
ALARM: Participants Video On setting is locked.
ALARM: Peer to peer connection is enabled.
ALARM: Play sound for "Host and co-host only is none.
ALARM: Play sound when participants join or leave is none.
ALARM: Polling is disabled.
ALARM: Prevent hosts from accessing their cloud recordings is disabled.
ALARM: Private chat is enabled.
ALARM: Record gallery view with shared screen is disabled.
ALARM: Recording disclaimer is disabled.
ALARM: Remote control is enabled.
ALARM: Request permission to unmute is disabled.
ALARM: Show a "Join from your browser" link is disabled.
ALARM: Show Zoom windows during screen share is disabled.
ALARM: Upload custom backgrounds is enabled.
ALARM: Use HTML format email for Outlook plugin is disabled.
ALARM: Use Personal Meeting ID (PMI) when scheduling a meeting is disabled.
ALARM: Use Personal Meeting ID (PMI) when starting an instant a meeting is disabled.
ALARM: Virtual background videos are enabled.
ALARM: Waiting room setting is disabled.
ALARM: Weak password detection is disabled.
ALARM: Whiteboard is enabled.
ALARM: Who can share is all.

I think that condensed view, with links to guidance on what to do about it, would be very helpful!

[judell]

Done in v9.