GAM ADV-X - User Login Activity Reports

587 views
Skip to first unread message

Chuck W. Williams

unread,
Oct 3, 2017, 3:14:02 PM10/3/17
to GAM for G Suite
Hi Ross and Team,

QQ--What is the best gam command to pull user login activity reports ...thanks a ton.

Regards

Chuck W. Williams

unread,
Oct 3, 2017, 3:38:28 PM10/3/17
to GAM for G Suite
Ross and Team,

I am referring to the documentation here---https://github.com/taers232c/GAMADV-XTD/wiki/Reports for running a users login activity report via the GAMADV-XTD version..thanks a ton.

Regards

Ross Scroggs

unread,
Oct 3, 2017, 3:39:35 PM10/3/17
to google-ap...@googlegroups.com
Chuck,


gam report logins[todrive [<ToDriveAttributes>]] [maxresults <Number>]

[([start <Time>] [end <Time>])|yesterday] [(user all|<UserItem>)|(select <UserTypeEntity>)] [event <String>] [filter|filters <String>] [ip <String>] [countsonly] [summary]


You have to decide for whom you want the login info.
user all - all users, the default
user <UserItem> - one user (<EmailAddress>|<UniqueID>)
select <UserTypeEntity> - a set of users, e.g., select group st...@domain.com

Select desired activities

start <Time>
end <Time>
event <String>
filter <String>
ip <String>

Don't show individual events, just counts per user.
countsonly

Don't show any individual information, just counts per event for all specified users.
summary

Ross



--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/8393b489-2318-491c-b8df-fe3ee8a3c844%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

Chuck W. Williams

unread,
Oct 3, 2017, 3:44:01 PM10/3/17
to GAM for G Suite
Thanks Ross,

So for example what would the commands look like to grab log in activity for all users,  and then a specific user for the last via successful Google PW login type

Thanks a ton


On Tuesday, October 3, 2017 at 3:14:02 PM UTC-4, Chuck W. Williams wrote:

Ross Scroggs

unread,
Oct 3, 2017, 4:01:48 PM10/3/17
to google-ap...@googlegroups.com
Chuck,

gam redirect csv ./AllUserLogins.csv report logins

gam redirect csv ./OneUserLogin.csv report logins event login_success filter "login_type==google_password"

The first row is the latest login

Ross

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.

For more options, visit https://groups.google.com/d/optout.



--

Chuck W. Williams

unread,
Oct 3, 2017, 4:36:45 PM10/3/17
to GAM for G Suite
Hi Ross,

This is a bit confusing.  I see the output will be piped to a .csv file.  The first command looks like it will pull login activity for all users..am I correct?  The second command, this looks like this will pull login activity for all users but filter on just successful Google pw events..am I correct?

Is there a way to pull the same type of reports of a specific user..ie us...@domain.com and filter on just successful Google pw events?  I am asking because running a report on all users will take too long...thanks a ton.

Regards


On Tuesday, October 3, 2017 at 3:14:02 PM UTC-4, Chuck W. Williams wrote:

Ross Scroggs

unread,
Oct 3, 2017, 5:37:33 PM10/3/17
to google-ap...@googlegroups.com
Chuck,

It's confusing because I left something out.
I just uploaded a version that let you limit the number of activities.

gam redirect csv ./OneUserLogin.csv report logins event login_success filter "login_type==google_password" user us...@domain.com maxactivities 1

redirect csv ./OneUserLogin.csv - Send output to CSV file, omit and output goes to screen
event login_success - only show login_success events
filter "login_type==google_password"- limit to events where google_password was used, rather than SAML (whatever that is)
user us...@domain.com - The user of interest
maxactivities 1 - show latest activity

Ross

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.

For more options, visit https://groups.google.com/d/optout.



--
Reply all
Reply to author
Forward
0 new messages