Anyway to export Google users who have configured AWS SSO on it?

[Mariano Schesak]

Hi team,

In our Gsuite google workspace we have in the User Information side, a line or category called AWS SSO.

Not all the users in our workspace have a line setup overthere, some of them they will have it empty.

Is there anyway to use GAM or GAM advance to export a list of users who have something setup on AWS SSO line and the ones who doesn't have anything configured or setup, just skip them?

Thank you all.

Regards,

Mariano.

[Ross Scroggs]

Do: gam show schemas

From this information I can give you the commands

Ross

----

Ross Scroggs

Ross.S...@gmail.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/70de3f62-eb3c-40db-aa38-4dbecdaa7e17n%40googlegroups.com.

[Mariano Schesak]

Hi Ross,

Thank you. I executed the command and I obtained different schemas. The one that I am interested in is this one: Schema: AWS-SSO

 schemaId: 3PawXAUrSVmidyu1Zud2Ug==
 displayName: AWS SSO
 Field: role
  fieldId: 9qQK4bf0Si2nrzQSPGQ0dg==
  fieldType: STRING
  displayName: Role
  multiValued: True
  readAccessType: ADMINS_AND_SELF
 Field: session_duration
  fieldId: l0bV9WDJTSeqr2rSPKKyEw==
  fieldType: STRING
  displayName: Session Duration
  multiValued: False
  readAccessType: ADMINS_AND_SELF

With that one, we are ok or do you need the whole schemas obtained from the command?

Thank you for your help.

Regards,

Mariano.

You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/L0h0yfVC1Iw/unsubscribe.
To unsubscribe from this group and all its topics, 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/93A2E43E-5368-44ED-BD54-800338886923%40gmail.com.

--

Cheers
Mariano Schesak

Jr. Systems Administrator

205-209 Wairau Road, Wairau Valley

Auckland 0627

www.smartpay.co.nz                   

This email and any attachments may be confidential. If received in error, please delete the message and inform us by return email. Further, the internet contains many uncertainties and Smartpay cannot guarantee that what you receive is what we intended to send. Smartpay has taken great effort to verify the accuracy of this document but assumes no responsibility for any technical inaccuracies or typographical errors. If you have any doubts about the authenticity of an email from Smartpay, please contact us immediately. Please maintain an up to date virus scanner and think before you print. Thank you.

[Ross Scroggs]

Users with AWS-SSO

gam config csv_output_row_filter "customSchemas.AWS-SSO.role.0.value:regex:^.+$" redirect csv ./UsersWithAWS-SSO.csv all users print users fields name custom AWS-SSO

Users without AWS-SSO

gam config csv_output_row_drop_filter "customSchemas.AWS-SSO.role.0.value:regex:^.+$" redirect csv ./UsersWithoutAWS-SSO.csv ou_and_children /Test print users fields name custom AWS-SSO

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJ%2BkxkL-ApgrFsjkwAFeaEw0r-S4jTaiGvx_Txs1KNKOefyiuQ%40mail.gmail.com.

[Mariano Schesak]

Hi Ross,

Thanks so much for the command and your help.

This worked out for me.

Thank you.

Have a good day.

Regards,

Mariano.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/272B03B3-9695-45D1-AF40-61BEA7B77F35%40gmail.com.