Using GAM to find a device

2,206 views
Skip to first unread message

Courtney Tech

unread,
Sep 23, 2021, 9:10:24 AM9/23/21
to GAM for Google Workspace
I have a student who misplaced their computer and when we went to check where it was located, the device wasn't properly checked out to him in our asset management software. Is there a way to pull the device information and narrow it to a certain user?

I thought it would be formatted like this:

gam print crosactivity <students email> 2021-09-01 2021-09-04

But this doesn't seem to work. Can someone please help me with the syntax I need to maybe find this device 

Thank you!

Ross Scroggs

unread,
Sep 23, 2021, 9:32:37 AM9/23/21
to google-ap...@googlegroups.com
Try this; replace 123456 with the device serial number:
gam info cros query "id:123456" recentusers activetimeranges

Ross

Find resources to help stop bullying here

By pressing "send" on this email, I acknowledge that this is not my personal email account, and that any emails I send or receive belong in whole or in part to Goshen Community Schools, and that I am expected to conform to the behavioral standards of Goshen High School. This includes emails that engage in activity recognized as cyberbullying.

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/1c274bfd-543b-4af8-87b5-279e1371da7bn%40googlegroups.com.

Courtney Tech

unread,
Sep 23, 2021, 9:43:01 AM9/23/21
to GAM for Google Workspace
That's the problem. I'm trying to find the device through the user, I don't have the device serial. I can find the external IP through the user's logged on devices. But I don't have a serial or asset tag number for the device.

I was hoping to list all the devices in a date range and either filter it by the student's email or at least narrow the date range so I could search the excel sheet for his email. 

Ross Scroggs

unread,
Sep 23, 2021, 10:34:06 AM9/23/21
to google-ap...@googlegroups.com
Contact me directly and we can find a solution.

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/b3f3e0af-12d0-4973-a8ed-f194a325bcbbn%40googlegroups.com.


--

Ross Scroggs

unread,
Sep 23, 2021, 10:46:17 AM9/23/21
to google-ap...@googlegroups.com
Try this:
Standard GAM
Linux/MacOS

export GAM_CSV_ROW_FILTER="recentUsers.email:regex:ad...@rdschool.org"

Windows

set GAM_CSV_ROW_FILTER=recentUsers.email:regex:ad...@rdschool.org

All

gam print cros serialnumber recentusers activetimeranges listlimit 1


Advanced GAM

gam config csv_output_row_filter "recentUsers.email:regex:ad...@rdschool.org" print cros serialnumber recentusers activetimeranges listlimit 1


Ross
--

NEWMAN, P

unread,
Sep 23, 2021, 11:08:09 AM9/23/21
to google-ap...@googlegroups.com
I run this on as a cron job
gam print cros annotatedAssetId annotatedLocation annotatedUser recentUsers listlimit 1 lastSync lastKnownNetwork orderby lastsync todrive tdfileid <file id>
set to update every hour during the working week.
Very helpful when a chromebook goes missing to see who last logged in and if it was off site when it last synced.

Piers


To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS8HYzKyNqZNi15aTNRoUXupPe3qK%2BWNj_HtMkGnj%3DrMvQ%40mail.gmail.com.


--

Piers Newman

Network Technician

 

Courtney Tech

unread,
Sep 23, 2021, 12:43:46 PM9/23/21
to GAM for Google Workspace
Is there a parameter for WAN IP address to be added to print cros?

On Thursday, September 23, 2021 at 11:08:09 AM UTC-4 pne...@judd.kent.sch.uk wrote:
I run this on as a cron job
gam print cros annotatedAssetId annotatedLocation annotatedUser recentUsers listlimit 1 lastSync lastKnownNetwork orderby lastsync todrive tdfileid <file id>
set to update every hour during the working week.
Very helpful when a chromebook goes missing to see who last logged in and if it was off site when it last synced.

Piers


On Thu, 23 Sept 2021 at 15:46, Ross Scroggs <ross.s...@gmail.com> wrote:
Try this:
Standard GAM
Linux/MacOS

export GAM_CSV_ROW_FILTER="recentUsers.email:regex:admin@rdschool.org"

Windows

set GAM_CSV_ROW_FILTER=recentUsers.email:regex:admin@rdschool.org

All

gam print cros serialnumber recentusers activetimeranges listlimit 1


Advanced GAM

gam config csv_output_row_filter "recentUsers.email:regex:ad...@rdschool.org" print cros serialnumber recentusers activetimeranges listlimit 1


Ross

On Thu, Sep 23, 2021 at 7:33 AM Ross Scroggs <ross.s...@gmail.com> wrote:
Contact me directly and we can find a solution.

Ross

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/b3f3e0af-12d0-4973-a8ed-f194a325bcbbn%40googlegroups.com.


--


--

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.

Ross Scroggs

unread,
Sep 23, 2021, 12:53:03 PM9/23/21
to google-ap...@googlegroups.com
Courtney,

lastknownnetwork

Ross

On Thu, Sep 23, 2021 at 9:43 AM 'Courtney Tech' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:
Is there a parameter for WAN IP address to be added to print cros?

On Thursday, September 23, 2021 at 11:08:09 AM UTC-4 pne...@judd.kent.sch.uk wrote:
I run this on as a cron job
gam print cros annotatedAssetId annotatedLocation annotatedUser recentUsers listlimit 1 lastSync lastKnownNetwork orderby lastsync todrive tdfileid <file id>
set to update every hour during the working week.
Very helpful when a chromebook goes missing to see who last logged in and if it was off site when it last synced.

Piers


On Thu, 23 Sept 2021 at 15:46, Ross Scroggs <ross.s...@gmail.com> wrote:
Try this:
Standard GAM
Linux/MacOS

export GAM_CSV_ROW_FILTER="recentUsers.email:regex:ad...@rdschool.org"

Windows

set GAM_CSV_ROW_FILTER=recentUsers.email:regex:ad...@rdschool.org

All


Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/b3f3e0af-12d0-4973-a8ed-f194a325bcbbn%40googlegroups.com.


--


--

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS8HYzKyNqZNi15aTNRoUXupPe3qK%2BWNj_HtMkGnj%3DrMvQ%40mail.gmail.com.


--

Piers Newman

Network Technician

 

Find resources to help stop bullying here

By pressing "send" on this email, I acknowledge that this is not my personal email account, and that any emails I send or receive belong in whole or in part to Goshen Community Schools, and that I am expected to conform to the behavioral standards of Goshen High School. This includes emails that engage in activity recognized as cyberbullying.

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/0402c87c-2d96-4ee9-a650-4aa8b705a2b1n%40googlegroups.com.


--
Reply all
Reply to author
Forward
0 new messages