mail-address instead username from userfield in a query-result?

You can take the userid and do a "im.exe viewuser" on it. This kind of thing works out great in powershell. Here's how that would look.

$users = (im.exe issues --fields=<userfield> --qeryDefinition=(bla bla bla...))

$emails=$users | foreach { im.exe viewuser $_ | findstr "Email Address" | foreach {$_.split(":").trim() }

...of course this just gets you a list of email addresses, like a bulk mail.

To find an individual user's email would be something like this:

$aUsersEmail = (im.exe viewuser $users[1] | findstr "Email Address" | foreach {$_.split(":").trim() )[0]

# where 1 is the number of the desired user in the array, which of course

# can be a variable derived by scanning the $users array for a desired name

# The [0] is there because the foreach output will be an array of one.

Message was edited by: David Hegland (for thie to work as written, we have to get only the user field in the first query. Of course, additional fields can be retrieved individually or in bulk by clever parsing.)