Documenting database schema is not an easy task. SQL can provide a table-column view of all selected tables, but this does not account for any interdependencies between tables in a normalized environment. In 7.0 Normalization includes dependencies on base-class tables, or, in other words, subsequent tables are extensions of the base table.
The following list reveals data classes and their structure. First, the name of the table is given, followed by a designation as a Base or Sub Class data class. The following label system is used:
Note the following when reviewing the grids:
For help in navigating dependent data classes, use the following guide:
The following data classes are for User-based data:
The following data classes are for Software-based data:
Hopefully this provides a guide that will allow you to upgrade or implement Inventory Solution 7.0 armed with the necessary data to manage your reports, filters, or anything else based off of Detailed Software and User data. This also concludes the series and now all data classes as part of Inventory Solution 7.0 are included (this does not include Server Inventory data classes, which will be covered in a separate article). Inventory Solution 7.0 Database Schema, Part 2: Hardware Inventory
I think a more robust list detailing the schema of the 7 platform is needed. Does Symantec plan on releasing a schema of the 7.1 platform when it releases? I know I will have quite a bit of re-writing reports and such to map to the new schema, so a diagram of the new schema is a neccesary piece of information. Would anyone else benefit from having a documented schema for 7.1?
I am in the same boat as you....I haven't found the table that has this data.