Export users to excel

Mar 6, 2014 at 9:22 AM
First of all thanks vey much Chris for making this pack available. I'd be lost without it! I'm looking to export all of my FBA users to an excel spreadsheet. What would be the easiest way of achieving this. Thanks
Mar 6, 2014 at 6:13 PM
You can query the users in SharePoint with powershell and have it write out the results to a csv that can be opened in excel. This might get you started:


If you only need usernames and email addresses, you could open up the aspnetdb database in SQL Server Management Studio, and just copy the values from the table into excel.