Updated simplified interface with build-in analytical features
Problems:
Analyze CMS DB objects in table
Solution:
Query CMS DB for any objects
Analyze available properties with tree and property view. Average object has around 50 properties only on the first level
Hide/unhide first level properties as columns and add/remove them as filters
Flatten embedded collections (UserGroups -> Users, Reports -> DataSources, Objects -> Rights…) with regex as Path to collection or/and low level Property Name
Filter duplicates after flattening with Distinct, in some cases it is drastically reduce result set to useful information
Resolve IDs to names, as in most cases collections are presented as SI_ID
Comments