Extracting Employee ID number

[Brian Gorsky]

I am trying to export user, last and first name, custom schemas and employee ID using the following:

gam print users lastname fullname externalids custom all orderby lastname> GWorkspace_Users.csv

It works well except that 'externalids' returns 3 columns:

- externalids displays a '1' if the user has anything entered in the Employee ID field at all
- externalids.0.type displays the work 'organization' if the user has anything entered in the Employee ID field at all
- externalids.0.value is the actual value of what is in the Employee ID field

The only column I want is the last one, "externalids.0.value" not the other two. I have tried using just " externalids.0.value" in the query above but I get a "Invalid argument" error. Thoughts?

[Ross Scroggs]

gam config csv_output_header_drop_filter "^externalIds$,externalIds.0.type" print users lastname fullname externalids custom all orderby lastname> GWorkspace_Users.csv

Ross

----

Ross Scroggs

Ross.S...@gmail.com

CONFIDENTIALITY NOTICE: The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or their agent, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited.

 

Dissemination to non-Law Enforcement entities should have prior approval of the originating agency/organization.

--
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/2ca2173f-b684-41e8-8ef6-92d769734ac0n%40googlegroups.com.