RegisteredServerTypes
Microsoft.SqlServer.Management.RegisteredServers.ServerGroup
Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer
RegisteredServerTypes-GroupingFormat
4
Directory:
$_.PSParentPath
Server
Microsoft.SqlServer.Management.Smo.Server
80
left
DisplayName
Database
Microsoft.SqlServer.Management.Smo.Database
20
left
15
left
16
left
14
left
9
right
30
left
25
left
Name
Status
ContainmentType
RecoveryModel
[int] $_.CompatibilityLevel
Collation
Owner
Table
Microsoft.SqlServer.Management.Smo.Table
28
left
30
left
22
left
Schema
Name
$_.CreateDate.ToString("g")
View
Microsoft.SqlServer.Management.Smo.View
28
left
30
left
22
left
Schema
Name
$_.CreateDate.ToString("g")
StoredProcedure
Microsoft.SqlServer.Management.Smo.StoredProcedure
28
left
30
left
22
left
Schema
Name
$_.CreateDate.ToString("g")
User
Microsoft.SqlServer.Management.Smo.User
30
left
28
left
22
left
Name
Login
$_.CreateDate.ToString("g")
Login
Microsoft.SqlServer.Management.Smo.Login
45
left
13
left
22
left
Name
LoginType
$_.CreateDate.ToString("g")
ServerRole
Microsoft.SqlServer.Management.Smo.ServerRole
25
left
11
left
22
left
25
left
22
left
Name
IsFixedRole
$_.DateCreated.ToString("g")
Owner
$_.DateModified.ToString("g")
Sequence
Microsoft.SqlServer.Management.Smo.Sequence
28
left
25
left
25
left
22
left
22
left
25
left
22
left
Schema
Name
CurrentValue
IsExhausted
$_.CreateDate.ToString("g")
Owner
$_.DateLastModified.ToString("g")
Schema
Microsoft.SqlServer.Management.Smo.Schema
30
left
28
left
Name
Owner
Index
Microsoft.SqlServer.Management.Smo.Index
80
left
Name
Trigger
Microsoft.SqlServer.Management.Smo.Trigger
30
left
22
left
Name
$_.CreateDate.ToString("g")
UserDefinedFunction
Microsoft.SqlServer.Management.Smo.UserDefinedFunction
28
left
30
left
22
left
Schema
Name
$_.CreateDate.ToString("g")
SystemMessage
Microsoft.SqlServer.Management.Smo.SystemMessage
5
right
15
left
58
left
ID
Language
Text
UserDefinedMessage
Microsoft.SqlServer.Management.Smo.UserDefinedMessage
5
right
15
left
58
left
ID
Language
Text
PolicyStore
Microsoft.SqlServer.Management.Dmf.PolicyStore
80
left
DisplayName
Policy
Microsoft.SqlServer.Management.Dmf.Policy
30
left
17
left
22
left
7
left
Name
PolicyCategory
$_.CreateDate.ToString("g")
Enabled
EvaluationHistory
Microsoft.SqlServer.Management.Dmf.EvaluationHistory
5
right
30
left
6
left
18
left
18
left
22
left
ID
PolicyName
Result
$_.StartDate.ToString("g")
$_.EndDate.ToString("g")
Exception
ConnectionEvaluationHistory
Microsoft.SqlServer.Management.Dmf.ConnectionEvaluationHistory
5
right
30
left
6
left
22
left
ID
ServerInstance
Result
Exception
EvaluationDetail
Microsoft.SqlServer.Management.Dmf.EvaluationDetail
5
right
6
left
40
left
22
left
ID
Result
TargetQueryExpression
Exception
TargetSet
Microsoft.SqlServer.Management.Dmf.TargetSet
5
right
20
left
40
left
5
left
ID
TargetType
TargetTypeSkeleton
Enabled
TargetSetLevel
Microsoft.SqlServer.Management.Dmf.TargetSetLevel
5
right
20
left
40
left
20
left
ID
Condition
TargetTypeSkeleton
LevelName
Condition
Microsoft.SqlServer.Management.Dmf.Condition
30
left
25
left
22
left
Name
Facet
$_.CreateDate.ToString("g")
PolicyCategory
Microsoft.SqlServer.Management.Dmf.PolicyCategory
5
right
30
left
30
left
ID
Name
MandateDatabaseSubscriptions
PolicyCategorySubscription
Microsoft.SqlServer.Management.Dmf.PolicyCategorySubscription
5
right
23
left
23
left
23
left
ID
PolicyCategory
Target
TargetType
ObjectSet
Microsoft.SqlServer.Management.Dmf.ObjectSet
30
left
25
left
Name
Facet
children
RegisteredServerTypes
PSParentPath
RegisteredServerTypes-GroupingFormat
4
left
40
left
Mode
DisplayName
children
RegisteredServerTypes
PSParentPath
RegisteredServerTypes-GroupingFormat
Microsoft.SqlServer.Management.RegisteredServers.ServerGroup
DisplayName
DisplayName
CollectionSet
Microsoft.SqlServer.Management.Collector.CollectionSet
30
left
10
left
36
left
Name
IsRunning
Description
CollectionItem
Microsoft.SqlServer.Management.Collector.CollectionItem
30
left
27
left
21
left
Name
TypeName
CollectionFrequency
SqlServerProviderExtension
Microsoft.SqlServer.Management.PowerShell.Extensions.SqlServerProviderExtension
15
left
30
left
40
left
Name
Root
Description
Machine
Microsoft.SqlServer.Management.PowerShell.Extensions.Machine
32
left
MachineName
CollectionInfo
Microsoft.SqlServer.Management.Sdk.Sfc.CollectionInfo
60
left
DisplayName
XEStore
Microsoft.SqlServer.Management.XEvent.XEStore
30
left
30
left
30
left
DisplayName
$_.Sessions.Count
RunningSessionCount
Session
Microsoft.SqlServer.Management.XEvent.Session
20
left
20
left
20
left
20
left
Name
AutoStart
IsRunning
$_.StartTime.ToString("g")
Event
Microsoft.SqlServer.Management.XEvent.Event
30
left
30
left
20
left
40
left
Name
PackageName
PredicateExpression
Description
Target
Microsoft.SqlServer.Management.XEvent.Target
30
left
30
left
40
left
Name
PackageName
Description
EventField
Microsoft.SqlServer.Management.XEvent.EventField
20
left
20
left
40
left
Name
Value
Description
TargetField
Microsoft.SqlServer.Management.XEvent.TargetField
20
left
20
left
40
left
Name
Value
Description
Action
Microsoft.SqlServer.Management.XEvent.Action
30
left
30
left
40
left
Name
PackageName
Description
Package
Microsoft.SqlServer.Management.XEvent.Package
20
left
40
left
40
left
20
left
Name
ID
ModuleID
Description
EventInfo
Microsoft.SqlServer.Management.XEvent.EventInfo
40
left
40
left
40
left
Name
CapabilitiesDesc
Description
EventColumnInfo
Microsoft.SqlServer.Management.XEvent.EventColumnInfo
20
left
20
left
20
left
20
left
Name
TypeName
Value
Description
DataEventColumnInfo
Microsoft.SqlServer.Management.XEvent.DataEventColumnInfo
20
left
20
left
20
left
Name
TypeName
Description
ReadOnlyEventColumnInfo
Microsoft.SqlServer.Management.XEvent.ReadOnlyEventColumnInfo
20
left
20
left
20
left
20
left
Name
TypeName
Value
Description
ActionInfo
Microsoft.SqlServer.Management.XEvent.ActionInfo
40
left
20
left
40
left
Name
TypeName
Description
TargetInfo
Microsoft.SqlServer.Management.XEvent.TargetInfo
40
left
40
left
Name
Description
TargetColumnInfo
Microsoft.SqlServer.Management.XEvent.TargetColumnInfo
20
left
20
left
20
left
20
left
Name
TypeName
Value
Description
TypeInfo
Microsoft.SqlServer.Management.XEvent.TypeInfo
20
left
10
left
40
left
Name
Size
Description
MapInfo
Microsoft.SqlServer.Management.XEvent.MapInfo
20
left
40
left
Name
Description
MapValueInfo
Microsoft.SqlServer.Management.XEvent.MapValueInfo
20
left
20
left
Name
Value
PredSourceInfo
Microsoft.SqlServer.Management.XEvent.PredSourceInfo
20
left
20
left
40
left
Name
TypeName
Description
PredCompareInfo
Microsoft.SqlServer.Management.XEvent.PredCompareInfo
20
left
20
left
40
left
Name
TypeName
Description
Utility
Microsoft.SqlServer.Management.Utility.Utility
80
left
DisplayName
Computer
Microsoft.SqlServer.Management.Utility.Computer
30
left
27
left
Name
IsClustered
Volume
Microsoft.SqlServer.Management.Utility.Volume
12
left
20
left
20
left
20
left
MountPointLocation
TotalSpaceUtilization
TotalSpace
TotalSpaceUsed
Processor
Microsoft.SqlServer.Management.Utility.Processor
16
left
18
left
20
left
Name
Architecture
ClockSpeed
ImportedObject
Microsoft.SqlServer.Management.Utility.ImportedObject
30
left
27
left
Name
Version
DAC
Microsoft.SqlServer.Management.DAC.DacStore
80
left
Name
DacPackage
Microsoft.SqlServer.Management.DAC.DacInstance
30
left
30
left
27
left
Name
$_.Type.Name
$_.Type.Version
AvailabilityDatabase
Microsoft.SqlServer.Management.Smo.AvailabilityDatabase
20
20
11
8
Name
SynchronizationState
IsSuspended
$_.IsJoined -eq 1
AvailabilityGroup
Microsoft.SqlServer.Management.Smo.AvailabilityGroup
20
32
Name
PrimaryReplicaServerName
AvailabilityReplica
Microsoft.SqlServer.Management.Smo.AvailabilityReplica
20
9
15
26
Name
Role
ConnectionState
RollupSynchronizationState
DatabaseReplicaState
Microsoft.SqlServer.Management.Smo.DatabaseReplicaState
29
24
21
24
26
16
AvailabilityReplicaServerName
AvailabilityDatabaseName
SynchronizationState
EstimatedRecoveryTime
SynchronizationPerformance
LogSendQueueSize
DatabaseReplicaHealthState
Microsoft.SqlServer.Management.PowerShell.Hadr.DatabaseReplicaHealthState
22
20
20
HealthState
AvailabilityGroup
AvailabilityReplica
Name
AvailabilityReplicaHealthState
Microsoft.SqlServer.Management.PowerShell.Hadr.AvailabilityReplicaHealthState
22
20
HealthState
AvailabilityGroup
Name
AvailabilityGroupHealthState
Microsoft.SqlServer.Management.PowerShell.Hadr.AvailabilityGroupHealthState
22
HealthState
Name
PolicyEvaluationDetails
Microsoft.SqlServer.Management.PowerShell.Hadr.PolicyEvaluationDetails
6
20
35
Result
TargetObject
Category
Name
AvailabilityGroupListener
Microsoft.SqlServer.Management.Smo.AvailabilityGroupListener
20
15
Name
PortNumber
ClusterIPConfiguration
AvailabilityGroupListenerIPAddress
Microsoft.SqlServer.Management.Smo.AvailabilityGroupListenerIPAddress
6
20
40
IsDHCP
SubnetMask
IPAddress
IPAddressState
AnalysisServerHost
Microsoft.AnalysisServices.PowerShell.Provider.AnalysisServerHost
80
Left
DisplayName
MajorObjectCollection
Microsoft.AnalysisServices.MajorObjectCollection
80
Left
DisplayName
ASServer
Microsoft.AnalysisServices.Server
80
Left
if ([string]::IsNullOrEmpty($_.DisplayName)) { $_.Name }
else { $_.DisplayName }
ASDatabase
Microsoft.AnalysisServices.Database
40
Left
20
Left
20
Left
Name
State
ReadWriteMode
Cube
Microsoft.AnalysisServices.Cube
25
Left
18
Left
16
Left
17
Right
Name
State
ProcessingMode
$_.LastProcessed.ToString("g")
MeasureGroup
Microsoft.AnalysisServices.MeasureGroup
25
Left
18
Left
18
Left
16
Left
Name
State
Type
ProcessingMode
AggregateDesign
Microsoft.AnalysisServices.AggregationDesign
60
Left
20
Right
Name
EstimatedRows
Partition
Microsoft.AnalysisServices.Partition
25
Left
21
Left
14
Right
16
Left
10
Left
12
Left
Name
AggregationDesignID
EstimatedRows
ProcessingMode
Type
CurrentStorageMode
Dimension
Microsoft.AnalysisServices.Dimension
35
Left
16
Left
18
Left
20
Left
Name
ProcessingMode
State
CurrentStorageMode
DimensionPermission
Microsoft.AnalysisServices.DimensionPermission
50
Left
15
Left
15
Left
Name
Read
Write
Assembly
Microsoft.AnalysisServices.Assembly
60
Left
15
Left
Name
IsLoaded
DatabasePermission
Microsoft.AnalysisServices.DatabasePermission
50
Left
15
Left
15
Left
Name
Read
Write
Role
Microsoft.AnalysisServices.Role
60
Left
20
Left
Name
$_.CreatedTimeStamp.ToSTring("g")
MiningStructure
Microsoft.AnalysisServices.MiningStructure
25
Left
20
Left
20
Left
18
Left
Name
Collation
CacheMode
State
MiningModel
Microsoft.AnalysisServices.MiningModel
20
Left
18
Left
28
Left
17
Left
Name
State
Algorithm
AllowDrillThrough
MiningModelPermission
Microsoft.AnalysisServices.MiningModelPermission
50
Left
15
Left
15
Left
Name
Read
Write
MiningStructurePermission
Microsoft.AnalysisServices.MiningStructurePermission
50
Left
15
Left
15
Left
Name
Read
Write
Trace
Microsoft.AnalysisServices.Trace
25
Left
25
Left
13
Left
12
Left
Name
LogFileName
LogFileSize
AutoRestart
MdxScript
Microsoft.AnalysisServices.MdxScript
40
Left
17
Left
20
Left
Name
DefaultScript
$_.CreatedTimestamp.ToSTring("g")
Perspective
Microsoft.AnalysisServices.Perspective
25
Left
25
Left
25
Left
25
Left
Name
Kpis
Dimensions
MeasureGroups
CubePermission
Microsoft.AnalysisServices.CubePermission
50
Left
15
Left
15
Left
Name
Read
Write
DataSource
Microsoft.AnalysisServices.DataSource
25
Left
13
Left
15
Right
40
Left
Name
Isolation
MaxActiveConnections
ConnectionString
DataSourcePermission
Microsoft.AnalysisServices.DataSourcePermission
50
Left
15
Left
15
Left
Name
Read
Write
DataSourceView
Microsoft.AnalysisServices.DataSourceView
40
Left
40
Left
Name
DataSource