Dashboard Tables

The complete set of database tables documented here includes:

• ApplicationAction_CODE table (see ApplicationAction_CODE Table)
• ApplicationCategory_CODE table (see ApplicationCategory_CODE Table)
• ApplicationClassification_CODE table (see ApplicationClassification_CODE Table)
• ApplicationIsManaged_CODE table (see ApplicationIsManaged_CODE Table)
• Application_DIM table (see Application_DIM Table)
• Application_Measurement_FACT table (see Application_Measurement_FACT Table)
• Application_Measurement_Snapshot_FACT table (see Application_Measurement_Snapshot_FACT Table)
• AssetStatus_CODE table (see AssetStatus_CODE Table)
• AssetType_CODE table (see AssetType_CODE Table)
• Asset_Activity_FACT table (see Asset_Activity_FACT Table)
• Asset_FACT table (see Asset_FACT Table)
• CalendarDate_DIM table (see CalendarDate_DIM Table)
• CalendarMonth_CODE table (see CalendarMonth_CODE Table)
• CalendarQuarter_CODE table (see CalendarQuarter_CODE Table)
• ContractStatus_CODE table (see ContractStatus_CODE Table)
• ContractType_CODE table (see ContractType_CODE Table)
• Contract_DIM table (see Contract_DIM Table)
• Contract_FACT table (see Contract_FACT Table)
• CurrencyCurrentConversion_FACT table (see CurrencyCurrentConversion_FACT Table)
• Currency_DIM table (see Currency_DIM Table)
• DiscoveredDevices_Activity_FACT table (see DiscoveredDevices_Activity_FACT Table)
• Installation_Activity_FACT table (see Installation_Activity_FACT Table)
• Inventory_DIM table (see Inventory_DIM Table)
• Inventory_DuplicateHostName_FACT table (see Inventory_DuplicateHostName_FACT Table)
• Inventory_DuplicateSerialNumber_FACT table (see Inventory_DuplicateSerialNumber_FACT Table)
• Inventory_VirtualizationType_FACT table (see Inventory_VirtualizationType_FACT Table)
• KPIDashboardMetric_CurrencyRate table (see KPIDashboardMetric_CurrencyRate Table)
• KPIDashboardMetric_SNAPSHOT_FACT table (see KPIDashboardMetric_SNAPSHOT_FACT Table)
• LicenseComplianceStatus_CODE table (see LicenseComplianceStatus_CODE Table)
• LicenseStatus_CODE table (see LicenseStatus_CODE Table)
• LicenseType_CODE table (see LicenseType_CODE Table)
• License_DIM table (see License_DIM Table)
• License_Position_FACT table (see License_Position_FACT Table)
• Publisher_DIM table (see Publisher_DIM Table)
• PurchaseStatus_CODE table (see PurchaseStatus_CODE Table)
• PurchaseType_CODE table (see PurchaseType_CODE Table)
• Purchase_DIM table (see Purchase_DIM Table)
• Purchase_Latest_FACT table (see Purchase_Latest_FACT Table)
• Purchase_Snapshot_FACT table (see Purchase_Snapshot_FACT Table)
• Purchase_Spend_FACT table (see Purchase_Spend_FACT Table)
• Purchase_Unprocessed_FACT table (see Purchase_Unprocessed_FACT Table)
• ResourceString_CODE table (see ResourceString_CODE Table)
• Snapshot_DIM table (see Snapshot_DIM Table)
• VMType_CODE table (see VMType_CODE Table)