|
<< Click to Display Table of Contents >> RayVentory Data Hub > 12.6 u5 > Administration and User Guide > Appendices Appendix II: List of Tasks for the Default Reports and Dashboards |
The tasks listed below are used by the default dashboards and reports. The setup of the tasks is described in the Import Data from Template chapter.
Path and Task |
Table* |
Connector |
|---|---|---|
1. Data collection > Directory services > Active Directory > Active Directory devices |
ActiveDirectoryDevices |
Active Directory |
1. Data collection > Directory Services > Active Directory > Active Directory groups |
ActiveDirectoryGroups |
Active Directory |
1. Data collection > Directory Services > Active Directory > Active Directory users |
ActiveDirectoryUsers |
Active Directory |
1. Data collection > Directory Services > Azure > Azure AD |
azuread |
Microsoft Azure AD |
1. Data collection > IAAS - PAAS > AWS EC2 > AWS EC2 |
aws_ec2 |
Amazon Elastic Compute Cloud (EC2) |
1. Data collection > IAAS - PAAS > AWS RDS > AWS RDS |
aws_rds |
Amazon Relational Database Services (RDS) |
1. Data collection > Inventory > ECM SQL > ECM SQL collection |
SCCMSQLCollection |
Microsoft SQL Server |
1. Data collection > Inventory > ECM SQL > ECM SQL device relations |
SCCMSQLDeviceRelations |
Microsoft SQL Server |
1. Data collection > Inventory > ECM SQL > ECM SQL devices |
SCCMSQLDevices |
Microsoft SQL Server |
1. Data collection > Inventory > ECM SQL > ECM SQL software ARP |
SCCMSQLSoftwareARP |
Microsoft SQL Server |
1. Data collection > Inventory > ECM SQL > ECM SQL software file |
SCCMSQLSoftwareFile |
Microsoft SQL Server |
1. Data collection > Inventory > ECM SQL > ECM SQL software file metering |
SCCMSQLSoftwareFileMetering |
Microsoft SQL Server |
1. Data collection > Inventory > ECM SQL > ECM SQL software OS |
SCCMSQLSoftwareOS |
Microsoft SQL Server |
1. Data collection > Inventory > ECM SQL > ECM SQL software tag |
SCCMSQLSoftwareTag |
Microsoft SQL Server |
1. Data collection > Inventory > ECM SQL > ECM SQL users |
SCCMSQLUsers |
Microsoft SQL Server |
1. Data collection > Inventory > ECM WMI > ECM WMI |
sccm_wmi |
SCCM (via WMI) |
1. Data collection > Inventory > Hypervisor > Citrix > Citrix Director |
CitrixDirector |
Microsoft SQL Server |
1. Data collection > Inventory > Hypervisor > Citrix > Citrix Director device relations |
CitrixDirectorDeviceRelations |
Microsoft SQL Server |
1. Data collection > Inventory > Hypervisor > Citrix > Citrix Director devices |
CitrixDirectorDevices |
Microsoft SQL Server |
1. Data collection > Inventory > Hypervisor > Vmware > vCenter |
vcenter |
VMware vCenter |
1. Data collection > Inventory > RayVentory > Inventory device |
InventoryDevice |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory device provider types |
InventoryDeviceProviderTypes |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory device providers |
InventoryDeviceProviders |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory device relation types |
InventoryDeviceRelationTypes |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory device relations |
InventoryDeviceRelations |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory device types |
InventoryDeviceTypes |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory software ARP |
InventorySoftwareARP |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory software file |
InventorySoftwareFile |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory software Microsoft |
InventorySoftwareMicrosoft |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory software MSI |
InventorySoftwareMSI |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory software Oracle |
InventorySoftwareOracle |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory software OS |
InventorySoftwareOS |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory software othersw |
InventorySoftwareOthersw |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory software tag |
InventorySoftwareTag |
Microsoft SQL Server |
1. Data collection > Inventory > RayVentory > Inventory terminal server |
InventoryTerminalServer |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_BIOS |
CMP_BIOS |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_CASE |
CMP_CASE |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_CDROM |
CMP_CDROM |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_CPU |
CMP_CPU |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_DISK |
CMP_DISK |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_FABRICSWITCH |
CMP_FABRICSWITCH |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_LANADAPTER |
CMP_LANADAPTER |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_LOGICALDRIVE |
CMP_LOGICALDRIVE |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_MEMORY |
CMP_MEMORY |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_MONITOR |
CMP_MONITOR |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_MOTHERBOARD |
CMP_MOTHERBOARD |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_NETWORK |
CMP_NETWORK |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_OS |
CMP_OS |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_OS_FUNCTION |
CMP_OS_FUNCTION |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_PRINTER |
CMP_PRINTER |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_ROUTER |
CMP_ROUTER |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_SOFTWARE |
CMP_SOFTWARE |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_SYSSYSTEM |
CMP_SYSSYSTEM |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_SYSTEM |
CMP_SYSTEM |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_TCP |
CMP_TCP |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_USBDEVICE |
CMP_USBDEVICE |
Microsoft SQL Server |
1. Data collection > ITSM > EXPORT > CMP_VIDEO |
CMP_VIDEO |
Microsoft SQL Server |
1. Data collection > ITSM > IMPORT > Get PNP Matching Table |
InventoryPNPMatchingTable |
Microsoft SQL Server |
1. Data collection > ITSM > IMPORT > RayVentory f_GetDeviceDiskDrive |
InventoryDeviceDiskDrive |
Microsoft SQL Server |
1. Data collection > ITSM > IMPORT > RayVentory f_GetDeviceLogicalDisk |
InventoryDeviceLogicalDisk |
Microsoft SQL Server |
1. Data collection > ITSM > IMPORT > RayVentory HardwareProperties |
InventoryDeviceHardwareProperties |
Microsoft SQL Server |
1. Data collection > ITSM > IMPORT > RayVentory SNMP devices |
InventorySNMPDevices |
Microsoft SQL Server |
1. Data collection > ITSM > SaaS > Adobe Connect |
adobe_ac |
Adobe Connect |
1. Data collection > ITSM > SaaS > Dynamics CRM |
dynamicscrm |
Microsoft Dynamics CRM |
1. Data collection > ITSM > SaaS > Dynamics CRM SKU prices |
dynamicscrm_org_data |
Container |
1. Data collection > ITSM > SaaS > Jira users |
JiraUsers |
Atlassian Jira (Cloud) |
1. Data collection > ITSM > SaaS > Office 365 |
Office365Data |
Microsoft 365 |
2.1 Data transformation > Standardized Data Transformation |
DataTransformation |
Data Transformation |
2.2 Processing data transformation > Account data |
result_account_summary |
Microsoft SQL Server |
2.2 Processing data transformation > Device data |
result_device_summary |
Microsoft SQL Server |
2.2 Processing data transformation > Software data |
result_software_summary |
Microsoft SQL Server |
2.2 Processing data transformation > User data |
result_user_summary |
Microsoft SQL Server |
2.3 Data enrichment > Catalog |
Catalog |
RayVentory Catalog |
3. Data analysis > Hardware Asset Management > Device details |
DeviceDetails |
Microsoft SQL Server |
3. Data analysis > Hardware Asset Management > Hypervisor details |
HypervisorDetails |
Microsoft SQL Server |
3. Data analysis > Hardware Asset Management > Hypervisor overview |
HypervisorOverview |
Microsoft SQL Server |
3. Data analysis > IT visibility > Hardware overview |
HardwareOverview |
Microsoft SQL Server |
3. Data analysis > IT visibility > IT visibility |
ITVisibility |
Microsoft SQL Server |
3. Data analysis > IT visibility > Vulnerability information |
Vulnerability |
Microsoft SQL Server |
3. Data analysis > OS > Devices by OS |
DevicesByOS |
Microsoft SQL Server |
3. Data analysis > OS > Operating System |
OperatingSystem |
Microsoft SQL Server |
3. Data analysis > Portfolio optimization > Software portfolio overview > Software portfolio information |
SoftwarePortfolioInformation |
Microsoft SQL Server |
3. Data analysis > Portfolio optimization > Software portfolio overview > Software portfolio overview |
SoftwarePortfolioOverview |
Microsoft SQL Server |
3. Data analysis > Portfolio optimization > Software portfolio overview > Software portfolio overview redundant |
SoftwarePortfolioOverviewRSw |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Extract Oracle DFUS Script Data |
rvsqlOracleDFUSScriptData |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Extract Oracle DFUS Table |
rvsqlOracleDFUSTable |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Extract Oracle Instances |
rvspOracleInstances |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Extract Oracle Option |
rvsqlOracleOption |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Extract Oracle Option List Data |
rvsprpOracleOptionList |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Extract Oracle Report Data |
rvsprpOracleReport |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Extract Oracle Virtual Infrastructure |
rvsprpOracleVirtualInfrastructure |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Extract Oracle vOption Table |
rvsqlOraclevOptionTable |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Extract Oracle vParameter |
rvsqlOraclevParameter |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Transform Oracle Dashboard |
OracleDashboard |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Transform Oracle Server Overview |
OracleServerOverview |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Transform Oracle Sub Reports HWInfoOS |
Oracle_sub_reports_HWInfoOS |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Transform Oracle Sub Reports Instance License Info |
Oracle_sub_reports_InstanceLicenseInfo |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Transform Oracle Sub Reports License Summary |
Oracle_sub_reports_LicenseSummary |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Transform Oracle Sub Reports Oracle DFUS Table |
Oracle_sub_reports_OracleDFUSTable |
Microsoft SQL Server |
3. Data analysis > Software Asset Management > Database > Oracle > Transform Oracle Sub Reports Oracle Option |
Oracle_sub_reports_OracleOption |
Microsoft SQL Server |
3. Data analysis > Vulnerability monitoring > Vulnerability monitoring |
VulnerabilityMonitoring |
Microsoft SQL Server |
3. Data analysis > Vulnerability monitoring > Vulnerability monitoring summary |
VulnerabilityMonitoringSummary |
Microsoft SQL Server |
3. Data analysis > Technology Asset Inventory |
TechnologyAssetInventory |
Microsoft SQL Server |
* 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.