Just started using ARM and we are going to start out with reporting. The reports give us the info we need, but the CSV versions come out formatted rather than a true CSV dump. For example, I am trying to get a security dump of the access on our SharePoint online site and the report comes out as
| Library Name | |||||
| Library Address (https://bla bla blah | Administrator | Owner | Design | Edit | Full controll |
| User ABCD | X | ||||
| User XYX | X | ||||
| User 123 | x |
This makes it very difficult to pull into Excel and group user names to see where they have access. Is there a way to make reports so the CSV or Excel files come out as real data dumps like:
Library Name, Library Address, User/Group, Administrator, Owner, Design, Edit, Full, Read, Restricted Read
MyLibrary, https://mysharepointsite/mylibrary, User ABCD, X,,,,,,
MyLibrary, https://mysharepointsite/mylibrary, User XYZ, ,,X,,,,
MyLibrary, https://mysharepointsite/mylibrary, User 123, ,,,,,X,
If there is not built in way to do it, I am pretty good with Crystal, Access, and a few other tools for connecting to the SQL database. I would just need a document that defines the tables.