Report of Google Sheets files from Shared Drive (that have to Protect a sheet or range enabled)

[zbinos]

Hello,

I am trying to generate a report using the GAM tool that lists all Google Sheets with the Protect a sheet or range function enabled. Importantly, the report must check the specified SharedDrive.

I managed to find a command for one user.

gam redirect csv ./ProtectedRanges.csv user myuser@xys.com print sheet query "'me' in owners and mimeType = 'application/vnd.google-apps.spreadsheet'" sheetsfields protectedranges formatjson quotechar "'"

However, can you advise whether it is possible to generate a report for a specified SharedDrive?