Appendix I: List of Default Reports and Dashboards

<< Click to Display Table of Contents >>

RayVentory Data Hub > 12.5 u5 > Administration and User Guide > Appendices 

Appendix I: List of Default Reports and Dashboards

RayVentory Data Hub comes with a number of default Reports and Dashboards. Information on how to setup RayVentory Data Hub in order to be available to access these default Reports and Dashboards refer to the Import Data from Template chapter. To find out which task creates the specific table used for a report or a dashboard refer to Appendix II: List of Tasks for the Default Reports and Dashboards.

Data Transformation

Path and Name

Type

Tables*

Data transformation

Dashboard

DataTransformation

ActiveDirectoryDevices

adobe_ac

vCenter

SCCMSQLDevicesCount

InventoryDevicesCount

Office365Data

ActiveDirectoryGroups

ActiveDirectoryUsers

aws_ec2

aws_rds

SCCMSQLDeviceRelations

SCCMSQLSoftwareARP

SCCMSQLSoftwareFile

SCCMSQLSoftwareOS

Account data

Dashboard

result_account_summary

Account data details

Report

DataTransformation

Device data

Dashboard

result_device_summary

Device data details

Report

DataTransformation

Software data

Dashboard

result_software_summary

Software data details

Report

DataTransformation

User data

Dashboard

result_user_summary

User data details

Report

DataTransformation

 

Data Collection

Path and Name

Type

Tables*

ITSM connector

Dashboard

CMP_BIOS

CMP_CASE

CMP_CDROM

CMP_DISK

CMP_FABRICKSWITCH

CMP_LANADAPTER

CMP_LOGICALDRIVE

CMP_MEMORY

CMP_MONITOR

CMP_MOTHERBOARD

CMP_NETWORK

CMP_OS

CMP_OS_FUNCTION

CMP_PRINTER

CMP_ROUTER

CMP_SOFTWARE

CMP_SYSSYSTEM

CMP_SYSTEM

CMP_TCP

CMP_USBDEVICE

CMP_VIDEO

RayVentory

Dashboard

InventoryDevice

InventoryDeviceProviders

InventoryDevicyProviderTypes

InventoryDeviceRelations

InventoryDeviceRelationTypes

InventoryDeviceTypes

InventorySoftwareARP

InventorySoftwareFile

InventorySoftwareMicrosoft

InventorySoftwareMSI

InventorySoftwareOracle

InventorySoftwareOS

InventorySoftwareOthersw

InventorySoftwareTag

InventoryTerminalServer

ECM

Dashboard

SCCMSQLCollections

SCCMSQLDeviceRelations

SCCMSQLDevices

SCCMSQLSoftwareARP

SCCMSQLSoftwareFile

SCCMSQLSoftwareFileMeter

SCCMSQLSoftwareOS

SCCMSQLSoftwareTag

sccm_wmi

Dynamics CRM

Dashboard

dynamicscrm_org_data

dynamicscrm

AWS

Dashboard

aws_ec2

aws_rds

VMware vCenter

Dashboard

vcenter

Citrix

Dashboard

CitrixDirector

CitrixDirectorDeviceRelations

CitrixDirectorDevices

Active Directory

Dashboard

ActiveDirectoryUsers

ActiveDirectoryDevices

ActiveDirectoryGroups

Office 365

Dashboard

Office365Data

Azure Active Directory

Dashboard

azuread

Adobe Admin Console

Dashboard

adobe_ac

ActiveDirectoryUsers

Jira

Dashboard

JiraUsers

 

Data Analysis

Path and Name

Type

Tables*

SaaS Management > Dynamics CRM optimization

Dashboard

dynamicscrm

dynamicscrm-org_data

SaaS Management > Jira User optimization

Dashboard

JiraUsers

SaaS Management > Office 365 optimization

Dashboard

Office365Data

Hardware Asset Management > Hypervisor overview

Dashboard

CustomSqlQuery

Hardware Asset Management > Device software

Report

DataTransformation

Hardware Asset Management > Hypervisor details

Report

DataTransformation

Hardware Asset Management > Device details

Report

DataTransformation

Hardware Asset Management > Devices

Report

DataTransformation

Hardware Asset Management > Device hardware

Report

DataTransformation

Vulnerability Monitoring > Vulnerability details

Report

VulnerabilityMonitoring

Vulnerability Monitoring > Vulnerable software products

Report

VulnerabilityMonitoring

Vulnerability Monitoring > Vulnerable device

Report

VulnerabilityMonitoring

Vulnerability Monitoring > Vulnerability overview

Dashboard

VulnerabilityMonitoring

Vulnerability_MonitoringSummary

Portfolio Optimization > EOL/EOS

Dashboard

Portfolio Optimization > Software portfolio overview

Dashboard

SoftwarePortfolioOverview

SoftwarePortfolioInformation

SoftwarePortfolioOverviewRSw

Portfolio Optimization > Software on device

Report

Catalog

Portfolio Optimization > Software portfolio details

Report

Catalog

Portfolio Optimization > Software details

Report

Catalog

Software Asset Management > Database > Oracle > Sub Reports > Oracle DB Detail Overview

Report

HWInfoOS

InstanceLicenseInfo

LicenseSummary

Virtualization

Software Asset Management > Database > Oracle > Sub Reports > Oracle DB Raynet Info

Report

OracleDFUSTable

OracleOption

rvsqlOraclevOptionTable

rvsqlOraclevParameter

Software Asset Management > Database > Oracle > Sub Reports > Oracle DB DFUS Info

Report

rvsqlOracleDFUSScriptData

Software Asset Management > Database > Oracle > Oracle DB Server Overview

Report

OracleServerOverview

Software Asset Management > Database > Oracle > Oracle DB Dashboard

Dashboard

OracleDashboard

Software Asset Management > Installed software

Report

DataTransformation

Software Asset Management > Software device

Report

DataTransformation

OS > OS Overview

Dashboard

OperationSystem

OS > Devices by OS

Dashboard

DevicesByOS

Technology asset inventory

Dashboard

TechnologyAssetInventory

IT visibility

Dashboard

ITVisibility

VulnerabilityInformation

HardwareOverview

Oracle Java details

Dashboard

Oracle Java powered by Unified Data Platform

Dashboard

 

* The names of the table in the list only represent part of the table names that will be created. The exact table names depend on the data that is delivered by a task. The information on how the exact table names are created can be found in the Naming Conventions chapter.