Understanding Report Types
Note:
IT Visibility With Technology Intelligence reports are designed in an interconnected manner that enables you to drill down into the visuals for deeper insights and enhanced data exploration.
This topic explains how the data relates to each other within each of the following report types:
| • | Hardware |
| • | Software |
| • | Vulnerabilities |
The following table lists how different tables within the Hardware report type are related to each other:
|
From Table |
Table Column |
To Table |
Table Column |
|
Device Taxonomy |
Id |
Device |
TaxonomyId |
|
Device Manufacturer |
Id |
Device |
ManufacturerId |
|
Device Product |
Id |
Device |
ProductId |
|
Device Model |
Id |
Device |
ModelId |
|
Device Lifecycle |
Id |
Device |
LifecycleId |
|
Device Operating System |
Id |
Device |
OperatingSystemId |
|
Device Model Sustainability |
Id |
Device |
ModelId |
|
Device Business Service |
DeviceId |
Device |
Id |
|
Device Cloud Instance |
DeviceId |
Device |
Id |
|
Device Context |
DeviceId |
Device |
Id |
|
Device File System |
DeviceId |
Device |
Id |
|
Device Network Adapter |
DeviceId |
Device |
Id |
|
Device Processor |
DeviceId |
Device |
Id |
|
Device Software |
DeviceId |
Device |
Id |
|
Device Taxonomy |
Id |
Device Lifecycle Daily |
TaxonomyId |
|
Device Manufacturer |
Id |
Device Lifecycle Daily |
ManufacturerId |
|
Device Product |
Id |
Device Lifecycle Daily |
ProductId |
|
Device Model |
Id |
Device Lifecycle Daily |
ModelId |
|
Device Taxonomy |
Id |
Virtual Machine |
TaxonomyId |
|
Device Manufacturer |
Id |
Virtual Machine |
ManufacturerId |
|
Device Product |
Id |
Virtual Machine |
ProductId |
|
Device Model |
Id |
Virtual Machine |
ModelId |
|
Device Lifecycle |
Id |
Virtual Machine |
LifecycleId |
|
Device Operating System |
Id |
Virtual Machine |
OperatingSystemId |
|
Virtual Machine Software |
DeviceId |
Virtual Machine |
Id |
To view the graphical representation of the relationships between the tables in the Hardware report type, see Hardware Tables Relationships.
The following table lists how different tables within the Software report type are related to each other:
|
From Table |
Table Column |
To Table |
Table Column |
|
Software Taxonomy |
Id |
Installed Software |
TaxonomyId |
|
Software Manufacturer |
Id |
Installed Software |
ManufacturerId |
|
Software Product |
Id |
Installed Software |
ProductId |
|
Software Release |
Id |
Installed Software |
ReleaseId |
|
Software Version |
Id |
Installed Software |
VersionId |
|
Software Lifecycle |
Id |
Installed Software |
LifecycleId |
|
Software Edition |
Id |
Installed Software |
EditionId |
|
Device Business Service |
DeviceId |
Installed Software |
DeviceId |
|
Device Context |
DeviceId |
Installed Software |
DeviceId |
|
Software Context |
SoftwareId |
Installed Software |
Id |
|
Software File Evidence |
SoftwareId |
Installed Software |
Id |
|
Software Installer Evidence |
SoftwareId |
Installed Software |
Id |
|
Software Device |
Id |
Installed Software |
DeviceId |
|
Software Taxonomy |
Id |
Software Lifecycle Daily |
TaxonomyId |
|
Software Manufacturer |
Id |
Software Lifecycle Daily |
ManufacturerId |
|
Software Product |
Id |
Software Lifecycle Daily |
ProductId |
|
Software Release |
Id |
Software Lifecycle Daily |
ReleaseId |
|
Software Version |
Id |
Software Lifecycle Daily |
VersionId |
To view the graphical representation of the relationships between the tables in the Software report type, see Software Tables Relationships.
The following table lists how different tables within the Vulnerabilities report type are related to each other:
|
From Table |
Table Column |
To Table |
Table Column |
|
Vulnerability Device |
Id |
Vulnerability |
DeviceId |
|
Vulnerability Calendar |
Date |
Vulnerability |
CVE Publish Date |
|
Vulnerability CVE |
Id |
Vulnerability |
CVEId |
|
Vulnerability Software |
Id |
Vulnerability |
SoftwareId |
|
Vulnerability CPE |
SoftwareId |
Vulnerability |
SoftwareId |
|
Device Context |
DeviceId |
Vulnerability |
DeviceId |
|
Software Context |
SoftwareId |
Vulnerability |
SoftwareId |
|
Vulnerability Malware |
CVEId |
Vulnerability |
CVEId |
|
Device Business Service |
DeviceId |
Vulnerability Device |
DeviceId |
|
Vulnerability CPE Detail |
CPEId |
Vulnerability CPE |
Id |
|
Vulnerability Device |
Id |
Vulnerability Advisory |
DeviceId |
|
Vulnerability Calendar |
Date |
Vulnerability Advisory |
ReleasedDate |
|
Vulnerability CVE |
Id |
Vulnerability Advisory |
CVEId |
|
Vulnerability Software |
Id |
Vulnerability Advisory |
SoftwareId |
|
Vulnerability CPE |
SoftwareId |
Vulnerability Advisory |
SoftwareId |
|
Device Context |
DeviceId |
Vulnerability Advisory |
DeviceId |
|
Software Context |
SoftwareId |
Vulnerability Advisory |
SoftwareId |
|
Vulnerability Advisory Detail |
AdvisoryId |
Vulnerability Advisory |
Id |
To view the graphical representation of the relationships between the tables in the Vulnerabilities report type, see Vulnerabilities Tables Relationships.
