I have a Document Library that contains about 100,000 folders (tickets from Remedy), and each ticket (folder) has 1-5 files associated with it. All ticket folders are on the same level hierarchy with respect to the root folder, if that makes sense. Also, each ticket is prefixed with three characters to denote the nature of the ticket. Folder names are the same as the ticket ID.
What I'd like to do is, create a custom view for each ticket category (prefix), and then, for each record (ticket) within each custom view, provide a link to the Document Library, specifically to the folder that contains all attachments for the given ticket.
My concern is: How can I obtain a spreadsheet that contains the links to each ticket attachment folder within the Document Library? Manually doing this would of course be insane.