|
<< Click to Display Table of Contents >> Raynet One Data Hub > 25.3 > Connectors > Alphabetic Connector List > Raynet One > Extracted Data Tables |
Table |
Column |
Type |
|---|---|---|
DeviceBios |
•Id •DeviceId •Version •Name •ReleaseDate •SerialNumber |
•Guid •Guid •String •String •DateTime •String |
DeviceCPUs
|
•Id •DeviceId •Name •Model •Cores •LogicalCores •CurrentClockSpeed •MaxClockSpeed •CurrentVoltage •Family •ProcessorId |
•Guid •Guid •String •Int32 •Int32 •Int32 •Int64 •Int64 •Double •Int32 •String |
DeviceDisks
|
•Id •DeviceId •Name •Manufacturer •Model •FreeSpace •Partitions •SerialNumber •InterfaceTypes •Size •Status •Description |
•Guid •Guid •String •String •String •Int64 •Int32 •String •String •Int64 •String •String |
DeviceGPUs
|
•Id •DeviceId •Name •DriverDate •DriverVersion •VideoProcessor |
•Guid •Guid •String •DateTime •String •String |
DeviceNetworkAdapters
|
•Id •DeviceId •Name •MacAddress •Description •Manufacturer •Index •Speed •IpV4 •IpV6 |
•Guid •Guid •String •String •String •String •Int32 •Int64 •String •String |
DeviceRelations
|
•RelationshipType •FromDeviceId •ToDeviceId •RelatedClusterId •RelatedServiceId |
•String •Guid •Guid •Guid •Guid |
DeviceRelationTypes
|
•Type •Relationship |
•String •String |
Devices
|
•import_id •import_data_source_id •device_key •device_name •import_org_level_2_id •device_manufacturer •device_model •serial_number •import_operating_system_id •import_device_type_id •import_device_status_id •import_domain_id •import_user_id •ip_address •mac_address •fqdn •inventory_number •inventory_date •installation_date •cpu_core_count •cpu_chip_count •cpu_core_count_limited •limit_cpu_core_count •cpu_thread_count •import_cpu_type_id •cpu_speed •ram •storage •network •graphics •bios •hyper_threading_act •uuid •tmp_computerid •remarks •corporateIdentifier •corporateAssetClass •corporateState •customSource •corporateOwnership •comment •isVirtual |
•String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •DateTime •String •Int32 •Int32 •Int32 •Int32 •Int32 •String •Int64 •Int64 •String •String •String •String •String •String •String •String •String •String •String •String •Boolean •String •Boolean |
DeviceVolumes |
•Id •DeviceId •Name •Size •Description •FileSystem •Freespace •Label •Partitions •Status |
•Guid •Guid •String •Int64 •String •String •Int64 •String •Int32 •String |
FileScans |
•Id •DeviceId •Name •MD5CheckSum •Content •Size •InstallDate •Manufacturer •Version •Locations •ExecutableHeaderCheckSum •ExecutableHeaderMajorImageVersion •ExecutableHeaderMinorImageVersion •ExecutableHeaderMajorLinkerVersion •ExecutableHeaderMinorLinkerVersion •ExecutableHeaderMajorOSVersion •ExecutableHeaderMinorOSVersion •ExecutableHeaderMajorSubSysVersion •ExecutableHeaderMinorSubSysVersion •CompanyName •FileVersion •Comments •BuildPart •Description •MajorPart •MinorPart •PrivatePart •InternalName •IsDebug •IsPatched •IsPreRelease •IsPrivateBuild •IsSpecialBuild •Language •LegalCopyright •LegalTrademarks •OriginalFilename •PrivateBuild •ProductBuildPart •ProductMajorPart •ProductMinorPart •ProductName •ProductPrivatePart •ProductVersion •SpecialBuild |
•Guid •Guid •String •String •String •Int64 •DateTime •String •String •String •Int64 •Int64 •Int64 •Int64 •Int64 •Int64 •Int64 •Int64 •Int64 •String •String •String •Int64 •String •Int64 •Int64 •Int64 •String •Boolean •Boolean •Boolean •Boolean •Boolean •String •String •String •String •String •Int64 •Int64 •Int64 •String •Int64 •String •String |
MsClusters |
•Id •ScopeId •Name •Domain •FunctionalLevel •QuorumType •DynamicQuorumEnabled •WitnessDynamicWeight •QuarantineThreshold •QuarantineDurationSec •EnabledSharedVolumes •SharedVolumesRoot •ClusterLogSizeMB •ClusterLogLevel •RequestReplyTimeout •RecentEventsResetTimeUtc •EnabledEventLogs •Nodes |
•Guid •Guid •String •String •Int32 •String •Boolean •Int32 •Int32 •Int32 •Boolean •String •Int32 •Int32 •Int32 •String •String •String |
OracleClusters |
•Id •DatabaseName •ScopeId •ArchiverStatus •Status •Thread •Nodes |
•Guid •String •Guid •String •String •Int32 •String |
OracleComponents |
•import_id •import_oracledb_id •name •version •status •modified •schema |
•String •String •String •String •String •DateTime •String |
OracleDbs |
•import_id •import_data_source_id •import_device_id •version •creationDate •instanceName •databaseRole •status •databaseName •uniqueName •appName •appEdition •appVersion •hostName •ipAddress •operatingSystem •cpuCountCurrent •cpuCountHighwater •cpuCoreCountCurrent •cpuCoreCountHighwater •cpuSocketCountCurrent •cpuSocketCountHighwater •users •usersMax •totalUserData •lockedUserData •expiredUserData •openUserData •totalInternalUsers •lockedInternalUsers •expiredInternalUsers •openInternalUsers •sessionMax •sessionsWarning •sessionsCurrent •sessionsHighwater •clusterId •clusterInstance •clusterRole •state •port |
•String •String •String •String •DateTime •String •String •String •String •String •String •String •String •String •String •String •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •Int32 •String •String •String •String •Int32 |
OracleDfus |
•import_id •import_oracledb_id •Class •name •version •deprecated •auxCount •conId •currentlyUsed •detectedUsages •featureInfo •firstUsageDate •lastSampleDate •lastUsageDate •sampleInterval •totalSamples |
•String •String •String •String •String •Boolean •Int32 •String •Boolean •Int32 •String •DateTime •DateTime •DateTime •Int32 •Int32 |
OracleDfusScriptResults |
•import_id •import_oracledb_id •result •row |
•String •String •Int32 •Int32 |
OracleOptions |
•import_id •import_oracledb_id •name •Class •isInstalled •isUsed |
•String •String •String •String •Boolean •Boolean |
OracleParameters |
•import_id •import_oracledb_id •name •value |
•String •String •String •String |
OracleReports |
•OracleId •Version •FeatureName •FirstUsageDate •Installed •LastUsageDate •NeedLicense •OracleComment •OracleUsed •RaynetComment •Used •CurrentlyUsed •RaynetUsed •ProductName •ProductType |
•Guid •String •String •DateTime •Boolean •DateTime •Boolean •String •Boolean •String •Boolean •Boolean •Boolean •String •String |
OracleVOptions |
•import_id •import_oracledb_id •name •isEnabled |
•String •String •String •Boolean |
ScriptResults |
•Id •DeviceId •Name •Class •Value •ImportDate •Key |
•Guid •Guid •String •String •String •DateTime •String |
SoftwareARP |
•import_id •import_data_source_id •product •publisher •product_version •guid •import_device_id •languageCode •installation_date •type |
•String •String •String •String •String •String •String •String •String •String |
SoftwareMSI |
•import_id •import_data_source_id •product •publisher •product_version •guid •import_device_id •languageCode •installation_date •type |
•String •String •String •String •String •String •String •String •String •String |
SoftwareOS |
•import_id •import_data_source_id •product •publisher •product_version •guid •import_device_id •languageCode •installation_date •type |
•String •String •String •String •String •String •String •String •String •String |
SoftwareOtherSW |
•import_id •import_data_source_id •product •publisher •product_version •guid •import_device_id •languageCode •istallation_date •type |
•String •String •String •String •String •String •String •String •String •String |