Super Admin Activity Reporting GCP

[CiaranMallory]

Hi all, 

I am trying to create a report for auditing purposes which lists all Super Admins in our GCP org and some basic information such as last login, email, username etc. The method which I have looked at so far is to route Workspace Admin logs to GCP Cloud Logging and sink to BigQuery to generate the report. We would also like to be able to export this report to something like a Google Sheet. I am wondering if anyone has implemented something like this before or has any suggestions on how to list all super admins and extract last login data in BigQuery.

Thanks in advance,

Ciaran.   

[dionv · Accepted solution]

Hello @CiaranMallory ,

On my investigation, I found this documentation on downloading the list of all users and filtering. As per the documentation attached, you can download the file to a .csv file or .JSON file and upload it to Google Sheets/BigQuery.