This utility is designed to discover the big picture of database interdependencies based on @Lookup and database connection methods in script. It is useful also for cleaning up redundant Data Dictionary entries.

The utlility profiles (creates documents) for all @DBLookup and @DBColumn formulas found in specified design element classes (Forms, Subforms, Agents) containing all lookup details including the code in which the lookup occurs. LotusScript methods which implement external connections are also profiled.

Optionally, the utility can be instructed to resolve lookup variables such as Server, Path and Key, such that a more accurate representation may result in the categorised output (view based). This feature is sophisticated and represents the majority of code. Since there are many potential scenarios where variable resolution is difficult or impossible, use this feature with caution. This feature does not attempt to resolve LotusScript variables.

Profiling of database connections can be performed for a single database, a set of databases defined by a directory, or an entire server.