[EDIT: I changed the title to appeal more to users looking to manage their file store disk space]
Author: Jim McGregor, firstname.lastname@example.org
- Julien Bras - I used Julien’s code from the “BOXI UserList & Group Extraction” as a base for this macro.
- jrennatc from the Tek-Tips forum - I used jrennatc’s code to get the number of instances, recurring instances and avg runtime.
Required: Microsoft Excel 2007 / XI 3.1
Rather than post the code verbatim, here is an overview of the logic: 1. Connect to the CMS (Thanks Julien!) 2. First Loop - Loop through the three types of reports: Crystal, Webi, Deski 2. Second Loop - Extract the list of reports. 3. Third Loop - Count up the number of instances and calculate the avg runtime and sum the size of the instance files in MB.
alpha1145 (BOB member since 2006-01-04)