date of the suspension

Nostromo

unread,

Jun 6, 2018, 3:54:03 PM6/6/18

to GAM for G Suite

Dear, is there any way to list the suspended accounts with the date of the suspension?

Ross Scroggs

unread,

Jun 6, 2018, 3:59:23 PM6/6/18

to google-ap...@googlegroups.com

Nostromo,

I don't see a suspension date available in the APIs, so Gam can't help you.

Ross

On Wed, Jun 6, 2018 at 12:54 PM Nostromo <aala...@inia.cl> wrote:

Dear, is there any way to list the suspended accounts with the date of the suspension?

--
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-man...@googlegroups.com.
To post to this group, send email to google-ap...@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/85e7ed7f-a709-4817-93c2-e52c5bc6eec2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Ross Scroggs

ross.s...@gmail.com

Nostromo

unread,

Jun 6, 2018, 4:08:02 PM6/6/18

to GAM for G Suite

OK, and where can you see those API parameters?

El miércoles, 6 de junio de 2018, 15:59:23 (UTC-4), Ross Scroggs escribió:

Nostromo,

I don't see a suspension date available in the APIs, so Gam can't help you.

Ross

On Wed, Jun 6, 2018 at 12:54 PM Nostromo <aala...@inia.cl> wrote:

Dear, is there any way to list the suspended accounts with the date of the suspension?
--
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-ap...@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/85e7ed7f-a709-4817-93c2-e52c5bc6eec2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Ross Scroggs
ross.s...@gmail.com

Ross Scroggs

unread,

Jun 6, 2018, 4:10:01 PM6/6/18

to google-ap...@googlegroups.com

Nostromo,

https://developers.google.com/admin-sdk/reports/v1/reference/usage-ref-appendix-a/users-accounts

Ross

On Wed, Jun 6, 2018 at 1:08 PM Nostromo <aala...@inia.cl> wrote:

OK, and where can you see those API parameters?

El miércoles, 6 de junio de 2018, 15:59:23 (UTC-4), Ross Scroggs escribió:

Nostromo,

I don't see a suspension date available in the APIs, so Gam can't help you.

Ross

On Wed, Jun 6, 2018 at 12:54 PM Nostromo <aala...@inia.cl> wrote:

Dear, is there any way to list the suspended accounts with the date of the suspension?
--
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-man...@googlegroups.com.

To post to this group, send email to google-ap...@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/85e7ed7f-a709-4817-93c2-e52c5bc6eec2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Ross Scroggs
ross.s...@gmail.com

--

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-man...@googlegroups.com.

To post to this group, send email to google-ap...@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/0737789d-3076-4c55-a45b-82db08e40ae1%40googlegroups.com.

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

--

Ross Scroggs

ross.s...@gmail.com

+KimNilsson

unread,

Jun 7, 2018, 5:23:58 AM6/7/18

to GAM for G Suite

It has been suggested, and I actually think Kevin Melillo does it, that on suspension rename the user with the suspension date.

That way, when you list suspended users, you will have the suspension date available.

✉ Kevin Melillo

unread,

Jun 7, 2018, 8:22:14 AM6/7/18

to google-ap...@googlegroups.com

When we off board users, we do this. We rename the user to <user>@domain.com to <user>_departed...@domain.com. We keep accounts active, and delegated to managers for 3 months. Once this 3 month period is up, we suspend the account fully. This also has the benefit of knowing when a user left the company, if that is needed.

On Thu, Jun 7, 2018 at 5:24 AM +KimNilsson <there.is.no...@gmail.com> wrote:

It has been suggested, and I actually think Kevin Melillo does it, that on suspension rename the user with the suspension date.
That way, when you list suspended users, you will have the suspension date available.

--

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-man...@googlegroups.com.
To post to this group, send email to google-ap...@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/186ed721-1226-44cd-9a60-a2396a9e428e%40googlegroups.com.

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

--

Kevin Melillo

Electronic Communications Analyst

Information Technology

445 Hoes Lane

Piscataway, NJ 08854

Phone:732-465-6609 | Mobile: 732-609-4331

E-mail: k.me...@ieee.org

Kim Nilsson

unread,

Jun 7, 2018, 9:11:16 AM6/7/18

to Google Apps Manager

Thanks, Kevin.

Seems my memory served me right this time.

/Kim

--

There is No Substitute!

google.com/+KimNilsson

Andrew Penner

unread,

Jun 7, 2018, 10:48:40 AM6/7/18

to google-ap...@googlegroups.com

That's a great idea.

Thanks!

______________________________________________________

Andrew Penner, Technical Analyst III (A+, MCP, MCDST)

Office: 780-460-3712 (333)

Mobile:780-913-7576

Fax: 780.460.7686

60 Sir Winston Churchill Ave

St. Albert, AB T8N 0G4

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAKM%3Dboay42H32hrtXAwV1XN7RoAEzgSreRFjzMs-qk%3Drc7nk8Q%40mail.gmail.com.

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

Find us on Facebook: St. Albert Public Schools

Follow us on Twitter: @StAlbertPublic and @SuptWowk

Alpay Akyol

unread,

Jun 8, 2018, 3:27:44 AM6/8/18

to google-ap...@googlegroups.com

Hi Kevin,

How you handle this renaming process, manually or automated ?

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAKM%3Dboay42H32hrtXAwV1XN7RoAEzgSreRFjzMs-qk%3Drc7nk8Q%40mail.gmail.com.

Kim Nilsson

unread,

Jun 8, 2018, 4:50:06 AM6/8/18

to Google Apps Manager

With GAM, of course! :-)

Alpay Akyol

unread,

Jun 8, 2018, 4:53:11 AM6/8/18

to google-ap...@googlegroups.com

I had asked manually or automated, if automated can you tell us how did you perform ?

--

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-man...@googlegroups.com.
To post to this group, send email to google-ap...@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/CAGPzzFsOLESiPcqnTAEEJhPx0LjZ_gSfwwf_qcVh_om9cbOY%2Bw%40mail.gmail.com.

k.melillo

unread,

Jun 11, 2018, 9:52:02 AM6/11/18

to GAM for G Suite

I have a csv file. It takes email address, first name, last name, manager email, and manager phone... all comma separated..

When we get a new termination, I fill it in for the termination.

I then use a bash script to read the contents of the file, and perform the needed GAM commands.

See the following, hopefully it is formatted enough to read. I am using PasteBin for this.

#!/bin/bash
INPUT=~/gam-data/userterm.csv
OLDIFS=$IFS
IFS=,
timestamp=$(date +%Y-%m-%d@%I:%M%p)
[ ! -f $INPUT ] && { echo "$INPUT file not found"; exit 99; }
while read userEmail userFirst userLast managerEmail managerPhone
do
domain=${userEmail/*@/ }
userId=${userEmail/@*/ }
userId="$(echo -e "${userId}" | sed -e 's/[[:space:]]*$//')"
domain="$(echo -e "${domain}" | sed -e 's/^[[:space:]]*//')"
domain="@$domain"
dateStamp=_departed_$(date +%Y%m%d)
newEmail=$userId$dateStamp$domain
if [ -z "$1" ]
then
echo -e "\e[91m\e[7mALERT:\e[0m To be used only for termination procedure"
echo -e "to process changes use \e[91m./termUser doit\e[0m"
echo -e "---[ \e[93m\e[1mPREVIEW of Changes \e[0m]--- "
echo -e "\e[1mUnsuspend: \e[0m$userEmail"
echo -e "\e[1mRename to: \e[0m$newEmail"
echo -e "\e[1mDelegate to: \e[0m$managerEmail ($managerPhone)"
echo -e "\e[1mVacation Responder: \e[0m"
echo -e " $userFirst $userLast is no longer with the company, please contact $userFirst's manager at"
echo -e " <$managerEmail> or by telephone at $managerPhone. \n\n Thank You. \n company Support."
echo -e "\e[36mRemove from All Groups\e[0m"
echo -e "\e[36mRemove mobile devices\e[0m"
echo -e "\e[36mMove to ORG /EXEMPT/Departed Staff Hold Normal\e[0m"
echo -e "---[ \e[93m\e[1mPREVIEW END \e[0m]--"
echo
else
if [ "${1^^}" == "DOIT" ]
then
echo -e "---[ \e[93m\e[1mTermination Process for User \e[36m$userFirst $userLast \e[0m]---\e[32m"
echo -e "\e[36m- Unsuspending User\e[0m"
echo "* $timestamp * $userEmail - Termination Process Start" >> ~/gam-data/gam-data.log
~/bin/gam/gam update user $userEmail suspended off
echo "* $timestamp * $userEmail - unsuspended" >> ~/gam-data/gam-data.log
echo -e "\e[36m- Rename User\e[0m"
~/bin/gam/gam update user $userEmail username $newEmail
echo "* $timestamp * $userEmail - renamed to $newEmail" >> ~/gam-data/gam-data.log
echo -e "\e[36m- Remove from All Groups\e[0m"
~/bin/gam/gam user $newEmail delete groups
echo "* $timestamp * $newEmail - all groups removed" >> ~/gam-data/gam-data.log
echo -e "\e[36m- Move to Proper ORG\e[0m"
~/bin/gam/gam update user $newEmail org "/EXEMPT/Departed Staff Hold Normal"
echo "* $timestamp * $newEmail - Moved to Departed Staff Hold Normal" >> ~/gam-data/gam-data.log
echo -e "\e[36m- Delegate access to Manager\e[0m"
~/bin/gam/gam user $newEmail delegate to $managerEmail
echo "* $timestamp * $newEmail - Delegated email to $managerEmail" >> ~/gam-data/gam-data.log
echo -e "\e[36m- Set Vacation Message\e[0m"
~/bin/gam/gam user $newEmail vacation on subject "$userFirst $userLast is no longer with the the company:" message "$userFirst$userLast is no longer with the company, please contact $userFirst's manager by email at <$managerEmail> or by telephone at $managerPhone. \n\n Thank You, \n IEEE Support." startdate $(date +%Y-%m-%d) enddate 2099-12-30
echo "* $timestamp * $newEmail - Set vacation responder to $managerEmail ($managerPhone)" >> ~/gam-data/gam-data.log
echo -e "\e[36m- Randomize Password for $newEmail\e[0m"
~/bin/gam/gam update user $newEmail password random
echo "* $timestamp * $newEmail - Password Randomized" >> ~/gam-data/gam-data.log
echo -e "\e[36m- Deprovision $newEmail\e[0m"
~/bin/gam/gam user $newEmail deprovision
echo "* $timestamp * $newEmail - Revoked all App Passwords, 2 Factor, and OAuth tokens" >> ~/gam-data/gam-data.log
echo -e "\e[36m- Dump Mobile Phones\e[0m"
~/bin/gam/gam print mobile query "email:$userEmail" >> ~/gam-data/tmp.mobile-data.csv
echo -e "\e[36m- Wipe Account from All Mobile Devices\e[0m"
~/bin/gam/gam csv ~/gam-data/tmp.mobile-data.csv gam update mobile ~resourceId action account_wipe
rm ~/gam-data/tmp.mobile-data.csv
echo "* $timestamp * $newEmail - Mobile Devices Wiped" >> ~/gam-data/gam-data.log
echo "* $timestamp * $userEmail - Termination Process Complete" >> ~/gam-data/gam-data.log
echo -e "\e[0m---[ \e[93m\e[1m Termination Process Complete for \e[36m$userFirst $userLast \e[0m]---"
echo
echo "Please log into Admin Console and reset sign in cookies for $newEmail"
fi
fi
done < $INPUT
IFS=$OLDIFS

Mikhael jabroux

unread,

Jun 23, 2018, 11:36:13 AM6/23/18

to GAM for G Suite

Thanks for Sharing

You re a life saver!!!

Reply all

Reply to author

Forward