In sheet reports

Gopher for Users provides the ability to run several "in Sheet" reports, which can be optionally set to auto-refresh daily.

Screen_Shot_2018-07-01_at_6.55.32_PM.png Screen_Shot_2018-07-01_at_6.57.59_PM.png

 

The User Properties by OU report provides aggregations of relevant user properties, including user status, admin role, 2FA status, directory visibility, creation time, and last login time for each organizational unit on the domain.

Screen_Shot_2018-07-01_at_7.05.38_PM.png

Applying native Sheets filters in row 3 of this report allows you to see subtotals of the remaining, visible rows.

Screen_Shot_2018-07-01_at_7.14.08_PM.png

 

The Never Logged In report provides a comprehensive list of domain users who have not logged into their G Suite accounts, and includes account creation date and organizational unit.

Screen_Shot_2018-07-01_at_7.05.55_PM.png

 

The Suspended Users report provides a comprehensive list of domain users who are currently suspended, and includes the Org Unit Path and Last Login Time.

Screen_Shot_2018-07-01_at_7.05.47_PM.png