How to get one users meetings via admin login

Good points, T

One thing a lot of people don't know if that a Connect licensed server can be installed twice without risk of penalty (this is in the ULA). 1 for production and 1 for testing, so maybe build a test/sandbox image and work this issue out. I would LOVE to know the solution(s) by touching the SQL db, if any come about.

While not ideal, you can loop through each meeting on the server and test whether the user has permissions on it.

Grab the sco-id of the user meetings folder (from the url when you are in the directory)
Run sco-expanded-contents from the XML API (filter for type=meeting for meetings only)
Foreach meeting sco
-----Run permissions-info on the sco, providing the principal-id
-----If you want to know exactly the type (e.g. host, mini-host (aka presenter), view (aka participant)), parse for type

Beyond that, as Sean stated, you can run a SQL query (although I would *highly* recommend having the query OKed by Adobe before running in production).

To my knowledge (and I have looked for this type a data a few times), there are no reports that ever differentiate a user as a participant/host/presenter directly. I think the reason is because users sometimes are promoted and demoted within a single meeting? That is not to say a custom report couldn't be made, but either the XML API (probably not) or directly from the MS-SQL DB on a licensed installation.

A small nuance to be aware of is, whenever you see a report that gives the users email address, you know that they are a fully qualified Connect user. When the email is not there in the report and only a name is given, they are a "guest". Also, if you assign yourself as someone's manager, then go to "Manager Reports" link found on the homepage, you will get a manifest list of all of the meetings attended by the staff member you assigned under you. Sadly, that report only gives the meeting room name, time-in & time-out. To find-out what there roll was, you'd have to find the meeting in the Meetings tab and look under the permissions link.

Real bummer the report you want doesn't come pre-built with Connect. Silly, in fact. If you really need this made for you, PM me and I can see if our engineers could access this indirectly.