PowerShell Cmdlets for Monitor Cluster Management: Reference Tables

Prev Next

This article provides an overview of schemes and tables that you can use with the Invoke-CUQuery and Export-CUQuery PowerShell cmdlets included in PowerShell Cmdlets for Monitor Cluster Management. The Table parameter is part of a Scheme. For example, the table Computersis part of the Mainscheme. The following overview shows all the tables that you can use with the cmdlets, including the corresponding scheme.

 Image is script example showing Invoke-CUQuery powershell cmdlet with Table parameter and Scheme parameter

Schemes

Tables

Scheme: Main

Scheme: BackupCoordinator

  • IndexPartitions
  • Nodes
  • Partition
  • PartitionToRecord
  • RoleAssignment

Scheme: Cluster

  • IndexPartitions
  • Nodes
  • Partition
  • PartitionToRecord
  • RoleAssignment

Scheme: Coordinator

  • IndexPartitions
  • Nodes
  • Partition
  • PartitionToRecord
  • RoleAssignment

Scheme: AssocFeed

  • AgentConnectionState
  • AvdUserSessions
  • AwsComputer
  • AzureComputer
  • CloudConnector
  • ClusteredHosts
  • MonitorMetrics
  • VMs
  • XD_Brokers
  • XD_Sessions
  • XD_Users
  • XD_VDA

Scheme: Diagnostics

  • AssociationFeedStats
  • AssociationMatchStats
  • Errors
  • MatchTransactionsDetails
  • Resources
  • RoleTransitions
  • Summary

Scheme: Metadata

  • Instructions

Scheme: Central Aggregation

  • LicenseCache
  • LicenseRestrictions
  • MonitorMetrics

Scheme: Config

From 9.0 This schema contains the configuration data stored in the monitors' settings:

  • AdvancedSettings
  • AgentSettings
  • AuditLog
  • AuditSettings
  • BrowserUrlSettings
  • ComputerTreeItem
  • MonitorSettings
  • ProcessDataCollection
  • ProcessReductionSettings
  • ProxySettings
  • ServiceConnectivity
  • ServicesConfigurationSettings
  • SystemCreds
  • TriggersConfiguration

Scheme: Runtime

From 9.0 This scheme contains runtime data that is queried in real-time from the monitors:

  • ADConnections
  • AAQueue
  • AssignedSources
  • ConfigSBA
  • ConfigurationModels
  • DataUpload
  • DisconnectedAgents
  • IndexEntries
  • KeyChainItems
  • LicenseUsage
  • Observables
  • OpenedIncidents
  • OutboundReservations
  • RunTimeSBA
  • TriggersRuntime