The new client storage feature in Admin is brilliant. Really helpful. From having a play around there are a few things which would make it more usable.
1. Primary use case is to be able to track storage over time and see which parts of the system are using more than others and work out rate of storage consumption. This is important to be able to do this by functional area. So the ability to compare over time or see a graph by functional area will help us plan and budget. To achieve this I have started to extract data from the screen and save as an Excel file and update over time and analyse in Excel
2. The most helpful view here is the Group by functional area. Unfortunately no Group by views are available for export. This has 34 rows vs a non-grouped export of over 3000. Could an export be made possible from the grouped by.
3. The column headings are not all visible. There doesn't seem to be a hover over feature to read the headings and the last column it seems impossible to expand to read what that is.
4. It's not clear if the total database size is equal to Database size + file attachment size but would assume this is the case.
5. I've no idea what BLOB/CLOB are or if this is relevant. It would seem we only need to worry about storage amount (Bytes) and (record count). Not sure how you tell how many files are attached for each module.
6. I created my own view (global) and removed columns I didn't want however it has ignored my column selection and still gives me all the columns whether I want them or not.
7. It would be nice to view the storage by functional area by year so you can tell how much you have used year on year at a glance
8. The numbers don't need the 2dp and should be right aligned
9. Parent date seems only to relate to claim incident date. This is misleading - could it be renamed as claim incident / loss date if that is what it is. It would be better if this was a create date and then would work across all entities not just claims
10. I've noticed we have some MP4 and MOV files. These could be large and grouping by Functional Area they seem to be attached to claims. The challenge now is how do you find those files? Use case - find and delete as unlikely to keep this type of file in the database. This could apply for any file type.
11. When you apply filters the Database size, Table count, File attachment and file attachment count do not change.
12. The options are very claim focused with claim status, coverage, major coverage. This only returns results for claims. I searched for coverage and Functional area of STARS.Policy and got no results as these fields are only claims related. We should be able to search for coverage across entities e.g. policies, programmes, allocations. And be able to search for location groups as critical when analysing location data.