GAM

[Andrew Schiess]

I recently updated accounts in my domain to add a number to the EmployeeID field using the following:

gam update user $($entry.email) externalID organization $($entry.employeeid)

(I hadn't updated GAM to the csv supported version yet.)

And while it completed successfully and I have no reason to believe it missed any, I want to turn around and print a list of users and this employeeID value associated with them so I can put the file in SQL and do some comparisons with another business system. Not clear on what syntax I could use.

[Jay Lee]

Try:

gam print users organization todrive

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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 http://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/e2a959a9-6b18-4351-a06f-6a9312f7dabe%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Andrew Schiess]

I get this for the headers of the file:

primaryEmail

organizations.0.costCenter

organizations.0.customType

organizations.0.department

organizations.0.description

organizations.0.title

and no values in anything other than primaryEmail

On Wednesday, November 19, 2014 4:15:43 PM UTC-7, Jay Lee wrote:

Try:

gam print users organization todrive

On Wed, Nov 19, 2014, 6:12 PM Andrew Schiess <andrew....@boiseschools.org> wrote:

I recently updated accounts in my domain to add a number to the EmployeeID field using the following:

gam update user $($entry.email) externalID organization $($entry.employeeid)

(I hadn't updated GAM to the csv supported version yet.)

And while it completed successfully and I have no reason to believe it missed any, I want to turn around and print a list of users and this employeeID value associated with them so I can put the file in SQL and do some comparisons with another business system. Not clear on what syntax I could use.

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.

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

[Jay Lee]

Sorry, misread your email. Try:

gam print users externalid

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 http://groups.google.com/group/google-apps-manager.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/9657fe5c-4d73-4323-b625-df9fe1caf01e%40googlegroups.com.

[Andrew Schiess]

primaryEmail

externalIds.0.customType

externalIds.0.type

externalIds.0.value

Again no values in the three fields.

On Wednesday, November 19, 2014 4:30:02 PM UTC-7, Jay Lee wrote:

Sorry, misread your email. Try:

gam print users externalid

On Wed, Nov 19, 2014, 6:28 PM Andrew Schiess <andrew....@boiseschools.org> wrote:

I get this for the headers of the file:

primaryEmail

organizations.0.costCenter

organizations.0.customType

organizations.0.department

organizations.0.description

organizations.0.title

and no values in anything other than primaryEmail

On Wednesday, November 19, 2014 4:15:43 PM UTC-7, Jay Lee wrote:

Try:

gam print users organization todrive

On Wed, Nov 19, 2014, 6:12 PM Andrew Schiess <andrew....@boiseschools.org> wrote:

I recently updated accounts in my domain to add a number to the EmployeeID field using the following:

gam update user $($entry.email) externalID organization $($entry.employeeid)

(I hadn't updated GAM to the csv supported version yet.)

And while it completed successfully and I have no reason to believe it missed any, I want to turn around and print a list of users and this employeeID value associated with them so I can put the file in SQL and do some comparisons with another business system. Not clear on what syntax I could use.

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.

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

To post to this group, send email to google-ap...@googlegroups.com.

Visit this group at http://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/e2a959a9-6b18-4351-a06f-6a9312f7dabe%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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 http://groups.google.com/group/google-apps-manager.

[Jay Lee]

Doesn't sound like the values got set properly then. What does "gam info user <email>" for someone show?

Jay Lee

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 http://groups.google.com/group/google-apps-manager.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/b7ee112f-ca49-41d4-b582-79eb44b9cc47%40googlegroups.com.

[Andrew Schiess]

Along with the rest of the user info (names, email aliases, groups) about the me, it does have a section:

External IDs:

  type: Employee ID

  value: <my employee id>

Jay Lee

And while it completed successfully and I have no reason to believe it missed any, I want to turn around and print a list of users and this employeeID value associated with them so I can put the file in SQL and do some comparisons with another business system. Not clear on what syntax I could should use.

[Andrew Schiess]

I take that back

type: organization

[Jay Lee]

And you're updated to 3.42?

--

You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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 http://groups.google.com/group/google-apps-manager.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/96852bbd-cb9d-423d-a958-037f69112d3c%40googlegroups.com.

[Andrew Schiess]

3.41

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

[Andrew Schiess]

Jay I just upgraded to 3.42, then did gam print users externalid query "my OU" > users.csv and it printed what i want.

Was it just the version of GAM? In any case, I appreciate your willingness to assist someone at my level. Thank you so much for your work on this invaluable tool.