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 Recovery Model 14 left CompatLvl 9 right Collation 30 left Owner 25 left Name Status 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") 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 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