Appendix I: List of Default Reports and Dashboards

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 > Administration and User Guide > Appendices 

Appendix I: List of Default Reports and Dashboards

Raynet One Data Hub comes with a number of default Reports and Dashboards. Information on how to setup Raynet One 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.