User Report with a specific format.

[Stew_Whitney]

I am attempting to pull a user report that has all of the data from the User Accounts report e.g. User Name, User Groups, Name User Licenses, etc. I need to pull it in a format that has those parameters as column headers so that I can apply a VLookup to parse in the department, which I have in a separate file.

[AdamShaneHyland]

Hi Stew,

Thanks for you post.

I would recommend looking into the Database Reporting Guide available in the Database Technical Community (link).  This guide will give you more information on the database schema.  From there you can write your own SQL to extract the data you are looking for.

Take care.