RegisteredServerTypes Microsoft.SqlServer.Management.RegisteredServers.ServerGroup Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer RegisteredServerTypes-GroupingFormat 4 Directory: $_.PSParentPath Server Microsoft.SqlServer.Management.Smo.Server Instance Name 80 left DisplayName Database Microsoft.SqlServer.Management.Smo.Database Name 20 left Status 15 left Containment Type 16 left Recovery Model 14 left CompatLvl 9 right Collation 30 left Owner 25 left Name Status ContainmentType RecoveryModel [int] $_.CompatibilityLevel Collation Owner Table Microsoft.SqlServer.Management.Smo.Table Schema 28 left Name 30 left Created 22 left Schema Name $_.CreateDate.ToString("g") View Microsoft.SqlServer.Management.Smo.View Schema 28 left Name 30 left Created 22 left Schema Name $_.CreateDate.ToString("g") StoredProcedure Microsoft.SqlServer.Management.Smo.StoredProcedure Schema 28 left Name 30 left Created 22 left Schema Name $_.CreateDate.ToString("g") User Microsoft.SqlServer.Management.Smo.User Name 30 left Login 28 left Created 22 left Name Login $_.CreateDate.ToString("g") Login Microsoft.SqlServer.Management.Smo.Login Name 45 left Login Type 13 left Created 22 left Name LoginType $_.CreateDate.ToString("g") ServerRole Microsoft.SqlServer.Management.Smo.ServerRole Name 25 left Fixed Role 11 left Created 22 left Owner 25 left Modified 22 left Name IsFixedRole $_.DateCreated.ToString("g") Owner $_.DateModified.ToString("g") Sequence Microsoft.SqlServer.Management.Smo.Sequence Schema 28 left Name 25 left CurrentValue 25 left IsExhausted 22 left Created 22 left Owner 25 left Modified 22 left Schema Name CurrentValue IsExhausted $_.CreateDate.ToString("g") Owner $_.DateLastModified.ToString("g") Schema Microsoft.SqlServer.Management.Smo.Schema Name 30 left Owner 28 left Name Owner Index Microsoft.SqlServer.Management.Smo.Index Name 80 left Name Trigger Microsoft.SqlServer.Management.Smo.Trigger Name 30 left Created 22 left Name $_.CreateDate.ToString("g") UserDefinedFunction Microsoft.SqlServer.Management.Smo.UserDefinedFunction Schema 28 left Name 30 left Created 22 left Schema Name $_.CreateDate.ToString("g") SystemMessage Microsoft.SqlServer.Management.Smo.SystemMessage ID 5 right Language 15 left Text 58 left ID Language Text UserDefinedMessage Microsoft.SqlServer.Management.Smo.UserDefinedMessage ID 5 right Language 15 left Text 58 left ID Language Text PolicyStore Microsoft.SqlServer.Management.Dmf.PolicyStore Instance Name 80 left DisplayName Policy Microsoft.SqlServer.Management.Dmf.Policy Name 30 left Category 17 left Created 22 left Enabled 7 left Name PolicyCategory $_.CreateDate.ToString("g") Enabled EvaluationHistory Microsoft.SqlServer.Management.Dmf.EvaluationHistory ID 5 right Policy Name 30 left Result 6 left Start Date 18 left End Date 18 left Messages 22 left ID PolicyName Result $_.StartDate.ToString("g") $_.EndDate.ToString("g") Exception ConnectionEvaluationHistory Microsoft.SqlServer.Management.Dmf.ConnectionEvaluationHistory ID 5 right Server Instance 30 left Result 6 left Messages 22 left ID ServerInstance Result Exception EvaluationDetail Microsoft.SqlServer.Management.Dmf.EvaluationDetail ID 5 right Result 6 left Target Query Expression 40 left Messages 22 left ID Result TargetQueryExpression Exception TargetSet Microsoft.SqlServer.Management.Dmf.TargetSet ID 5 right Target Type 20 left Target Type Skeleton 40 left Enabled 5 left ID TargetType TargetTypeSkeleton Enabled TargetSetLevel Microsoft.SqlServer.Management.Dmf.TargetSetLevel ID 5 right Condition 20 left Target Type Skeleton 40 left Level Name 20 left ID Condition TargetTypeSkeleton LevelName Condition Microsoft.SqlServer.Management.Dmf.Condition Name 30 left Facet 25 left Created 22 left Name Facet $_.CreateDate.ToString("g") PolicyCategory Microsoft.SqlServer.Management.Dmf.PolicyCategory ID 5 right Name 30 left Mandate Database Subscriptions 30 left ID Name MandateDatabaseSubscriptions PolicyCategorySubscription Microsoft.SqlServer.Management.Dmf.PolicyCategorySubscription ID 5 right Policy Category 23 left Target 23 left Target Type 23 left ID PolicyCategory Target TargetType ObjectSet Microsoft.SqlServer.Management.Dmf.ObjectSet Name 30 left Facet 25 left Name Facet children RegisteredServerTypes PSParentPath RegisteredServerTypes-GroupingFormat Mode 4 left Name 40 left Mode DisplayName children RegisteredServerTypes PSParentPath RegisteredServerTypes-GroupingFormat Microsoft.SqlServer.Management.RegisteredServers.ServerGroup DisplayName DisplayName CollectionSet Microsoft.SqlServer.Management.Collector.CollectionSet Name 30 left IsRunning 10 left Description 36 left Name IsRunning Description CollectionItem Microsoft.SqlServer.Management.Collector.CollectionItem Name 30 left Collector Type 27 left Collection Frequency 21 left Name TypeName CollectionFrequency SqlServerProviderExtension Microsoft.SqlServer.Management.PowerShell.Extensions.SqlServerProviderExtension Name 15 left Root 30 left Description 40 left Name Root Description Machine Microsoft.SqlServer.Management.PowerShell.Extensions.Machine MachineName 32 left MachineName CollectionInfo Microsoft.SqlServer.Management.Sdk.Sfc.CollectionInfo Name 60 left DisplayName XEStore Microsoft.SqlServer.Management.XEvent.XEStore Instance Name 30 left Total Session Count 30 left Running Session Count 30 left DisplayName $_.Sessions.Count RunningSessionCount Session Microsoft.SqlServer.Management.XEvent.Session Name 20 left AutoStartUp 20 left IsRunning 20 left Start Time 20 left Name AutoStart IsRunning $_.StartTime.ToString("g") Event Microsoft.SqlServer.Management.XEvent.Event Name 30 left Package Name 30 left Predicate 20 left Description 40 left Name PackageName PredicateExpression Description Target Microsoft.SqlServer.Management.XEvent.Target Name 30 left Package Name 30 left Description 40 left Name PackageName Description EventField Microsoft.SqlServer.Management.XEvent.EventField Name 20 left Value 20 left Description 40 left Name Value Description TargetField Microsoft.SqlServer.Management.XEvent.TargetField Name 20 left Value 20 left Description 40 left Name Value Description Action Microsoft.SqlServer.Management.XEvent.Action Name 30 left Package Name 30 left Description 40 left Name PackageName Description Package Microsoft.SqlServer.Management.XEvent.Package Name 20 left ID 40 left Module ID 40 left Description 20 left Name ID ModuleID Description EventInfo Microsoft.SqlServer.Management.XEvent.EventInfo Name 40 left Capabilities 40 left Description 40 left Name CapabilitiesDesc Description EventColumnInfo Microsoft.SqlServer.Management.XEvent.EventColumnInfo Name 20 left Type 20 left Value 20 left Description 20 left Name TypeName Value Description DataEventColumnInfo Microsoft.SqlServer.Management.XEvent.DataEventColumnInfo Name 20 left Type 20 left Description 20 left Name TypeName Description ReadOnlyEventColumnInfo Microsoft.SqlServer.Management.XEvent.ReadOnlyEventColumnInfo Name 20 left Type 20 left Value 20 left Description 20 left Name TypeName Value Description ActionInfo Microsoft.SqlServer.Management.XEvent.ActionInfo Action Name 40 left Type 20 left Description 40 left Name TypeName Description TargetInfo Microsoft.SqlServer.Management.XEvent.TargetInfo Name 40 left Description 40 left Name Description TargetColumnInfo Microsoft.SqlServer.Management.XEvent.TargetColumnInfo Name 20 left Type 20 left Value 20 left Description 20 left Name TypeName Value Description TypeInfo Microsoft.SqlServer.Management.XEvent.TypeInfo Type Name 20 left Type Size 10 left Description 40 left Name Size Description MapInfo Microsoft.SqlServer.Management.XEvent.MapInfo Name 20 left Description 40 left Name Description MapValueInfo Microsoft.SqlServer.Management.XEvent.MapValueInfo Name 20 left Value 20 left Name Value PredSourceInfo Microsoft.SqlServer.Management.XEvent.PredSourceInfo Name 20 left Type 20 left Description 40 left Name TypeName Description PredCompareInfo Microsoft.SqlServer.Management.XEvent.PredCompareInfo Name 20 left Type 20 left Description 40 left Name TypeName Description Utility Microsoft.SqlServer.Management.Utility.Utility Instance Name 80 left DisplayName Computer Microsoft.SqlServer.Management.Utility.Computer Name 30 left Clustered 27 left Name IsClustered Volume Microsoft.SqlServer.Management.Utility.Volume Mount Point 12 left Space Utilization % 20 left Total Space 20 left Total Space Used 20 left MountPointLocation TotalSpaceUtilization TotalSpace TotalSpaceUsed Processor Microsoft.SqlServer.Management.Utility.Processor Processor Name 16 left Architecture 18 left Clock Speed 20 left Name Architecture ClockSpeed ImportedObject Microsoft.SqlServer.Management.Utility.ImportedObject Name 30 left Version 27 left Name Version DAC Microsoft.SqlServer.Management.DAC.DacStore Name 80 left Name DacPackage Microsoft.SqlServer.Management.DAC.DacInstance Instance Name 30 left Application Name 30 left Application Version 27 left Name $_.Type.Name $_.Type.Version AvailabilityDatabase Microsoft.SqlServer.Management.Smo.AvailabilityDatabase Name 20 SynchronizationState 20 IsSuspended 11 IsJoined 8 Name SynchronizationState IsSuspended $_.IsJoined -eq 1 AvailabilityGroup Microsoft.SqlServer.Management.Smo.AvailabilityGroup Name 20 PrimaryReplicaServerName 32 Name PrimaryReplicaServerName AvailabilityReplica Microsoft.SqlServer.Management.Smo.AvailabilityReplica Name 20 Role 9 ConnectionState 15 RollupSynchronizationState 26 Name Role ConnectionState RollupSynchronizationState DatabaseReplicaState Microsoft.SqlServer.Management.Smo.DatabaseReplicaState AvailabilityReplicaServerName 29 AvailabilityDatabaseName 24 SynchronizationState 21 EstimatedRecoveryTime 24 SynchronizationPerformance 26 LogSendQueueSize 16 AvailabilityReplicaServerName AvailabilityDatabaseName SynchronizationState EstimatedRecoveryTime SynchronizationPerformance LogSendQueueSize DatabaseReplicaHealthState Microsoft.SqlServer.Management.PowerShell.Hadr.DatabaseReplicaHealthState HealthState 22 AvailabilityGroup 20 AvailabilityReplica 20 Name HealthState AvailabilityGroup AvailabilityReplica Name AvailabilityReplicaHealthState Microsoft.SqlServer.Management.PowerShell.Hadr.AvailabilityReplicaHealthState HealthState 22 AvailabilityGroup 20 Name HealthState AvailabilityGroup Name AvailabilityGroupHealthState Microsoft.SqlServer.Management.PowerShell.Hadr.AvailabilityGroupHealthState HealthState 22 Name HealthState Name PolicyEvaluationDetails Microsoft.SqlServer.Management.PowerShell.PolicyEvaluationDetails Result 6 TargetObject 20 Category 35 Name Result TargetObject Category Name AvailabilityGroupListener Microsoft.SqlServer.Management.Smo.AvailabilityGroupListener Name 20 PortNumber 15 ClusterIPConfiguration Name PortNumber ClusterIPConfiguration AvailabilityGroupListenerIPAddress Microsoft.SqlServer.Management.Smo.AvailabilityGroupListenerIPAddress IsDhcp 6 SubnetMask 20 IPAddress 40 State IsDHCP SubnetMask IPAddress IPAddressState AnalysisServerHost Microsoft.AnalysisServices.PowerShell.Provider.AnalysisServerHost Host Name 80 Left DisplayName MajorObjectCollection Microsoft.AnalysisServices.MajorObjectCollection Collections 80 Left DisplayName ASServer Microsoft.AnalysisServices.Server Instance Name 80 Left if ([string]::IsNullOrEmpty($_.DisplayName)) { $_.Name } else { $_.DisplayName } ASDatabase Microsoft.AnalysisServices.Database Name 40 Left State 20 Left Read-Write Mode 20 Left Name State ReadWriteMode Cube Microsoft.AnalysisServices.Cube Name 25 Left State 18 Left Processing Mode 16 Left Last Processed On 17 Right Name State ProcessingMode $_.LastProcessed.ToString("g") MeasureGroup Microsoft.AnalysisServices.MeasureGroup Name 25 Left State 18 Left Type 18 Left Processing Mode 16 Left Name State Type ProcessingMode AggregateDesign Microsoft.AnalysisServices.AggregationDesign Name 60 Left Estimated Rows 20 Right Name EstimatedRows Partition Microsoft.AnalysisServices.Partition Name 25 Left Aggregation Design ID 21 Left Estimated Rows 14 Right Processing Mode 16 Left Type 10 Left Storage Mode 12 Left Name AggregationDesignID EstimatedRows ProcessingMode Type CurrentStorageMode Dimension Microsoft.AnalysisServices.Dimension Name 35 Left Processing Mode 16 Left State 18 Left Current Storage Mode 20 Left Name ProcessingMode State CurrentStorageMode DimensionPermission Microsoft.AnalysisServices.DimensionPermission Name 50 Left Read Access 15 Left Write Access 15 Left Name Read Write Assembly Microsoft.AnalysisServices.Assembly Name 60 Left Loaded State 15 Left Name IsLoaded DatabasePermission Microsoft.AnalysisServices.DatabasePermission Name 50 Left Read Access 15 Left Write Access 15 Left Name Read Write Role Microsoft.AnalysisServices.Role Name 60 Left Created On 20 Left Name $_.CreatedTimeStamp.ToSTring("g") MiningStructure Microsoft.AnalysisServices.MiningStructure Name 25 Left Collation 20 Left Cache Mode 20 Left State 18 Left Name Collation CacheMode State MiningModel Microsoft.AnalysisServices.MiningModel Name 20 Left State 18 Left Algorithm 28 Left AllowDrillThrough 17 Left Name State Algorithm AllowDrillThrough MiningModelPermission Microsoft.AnalysisServices.MiningModelPermission Name 50 Left Read Access 15 Left Write Access 15 Left Name Read Write MiningStructurePermission Microsoft.AnalysisServices.MiningStructurePermission Name 50 Left Read Access 15 Left Write Access 15 Left Name Read Write Trace Microsoft.AnalysisServices.Trace Name 25 Left Log File Name 25 Left Log File Size 13 Left Auto Restart 12 Left Name LogFileName LogFileSize AutoRestart MdxScript Microsoft.AnalysisServices.MdxScript Name 40 Left Default Script 17 Left Created Timestamp 20 Left Name DefaultScript $_.CreatedTimestamp.ToSTring("g") Perspective Microsoft.AnalysisServices.Perspective Name 25 Left KPIs 25 Left Dimensions 25 Left MeasureGroups 25 Left Name Kpis Dimensions MeasureGroups CubePermission Microsoft.AnalysisServices.CubePermission Name 50 Left Read Access 15 Left Write Access 15 Left Name Read Write DataSource Microsoft.AnalysisServices.DataSource Name 25 Left Isolation 13 Left Max Connections 15 Right Connection String 40 Left Name Isolation MaxActiveConnections ConnectionString DataSourcePermission Microsoft.AnalysisServices.DataSourcePermission Name 50 Left Read Access 15 Left Write Access 15 Left Name Read Write DataSourceView Microsoft.AnalysisServices.DataSourceView Name 40 Left Primary Data Source 40 Left Name DataSource ASDatabase Microsoft.AnalysisServices.Tabular.Database Name 40 Left State 20 Left Read-Write Mode 20 Left Name State ReadWriteMode Model Microsoft.AnalysisServices.Tabular.Model Name 10 Left Default Mode 16 Left Default DataView 16 Left Structure Modified On 30 Right Name DefaultMode DefaultDataView $_.StructureModifiedTime.ToString("g") TabularCollection Microsoft.AnalysisServices.PowerShell.Provider.TabularCollection Navigable Items 25 Left DisplayName DataSource Microsoft.AnalysisServices.Tabular.DataSource Data Source Name 35 Left ConnectionString 60 Left Name ConnectionString Table Microsoft.AnalysisServices.Tabular.Table Name 35 Left Partitions 10 Left Name $_.Partitions.Count ModelRole Microsoft.AnalysisServices.Tabular.ModelRole Name 35 Left Members 10 Left Name $_.Members.Count WindowsModelRoleMember Microsoft.AnalysisServices.Tabular.WindowsModelRoleMember Name 30 Left Member ID 50 Left MemberName MemberID Column Microsoft.AnalysisServices.Tabular.Column Name 35 Left Data Type 10 Left Name DataType Measure Microsoft.AnalysisServices.Tabular.Measure Name 35 Left Data Type 10 Left Name DataType Partition Microsoft.AnalysisServices.Tabular.Partition Name 35 Left State 20 Left Mode 20 Left Name State Mode