You can use the reporting tool, and run a Machines Assigned Users or a Users Assigned To Machines Report (depending which way you want to look it up), and you should be able to get whatever information you are looking for.
Thanks for that.
Am i correct in thinking that the reporting tool can only be run on the server itself? Is there any way we could run this type of query remotely?
The closest thing I could come up with is using the SBADMCL tool with the "DumpMachineUsers" command which would give you all the users assigned to a machine in a csv file. Theoretically, you could run that for all machines, and dump the csv file into excel or access, and sort by the user you wanted. Or you could filter it through a Perl Script, if you were so inclined.
The only other option would be to user the "DumpUserAudit" command, but that would only give you machines that the particular user had logged into, not all the machines to which they were assigned.
use the report generator - it has a "users assigned to machines" report - you can stick in a user, or user group and it will tell you which machines they are assigned to.