SQLOpsDB PowerShell Module

The PowerShell model is the primary code for collecting and updating the information. The command-lets in this module are broken into three categories. I have tried to follow modular development strategies. Although I did break some rules. For example, you will notice there is no Add-* command for most objects. I did this to minimize row-by-row based processing. The Update-* command lets handle update and insert where set based operations are possible. All command-lets do support Get-Help.

Data Modification / Access in SQL Ops DBData Access in SQL InfrastructureSQLOpsDB Utility Command-Lets
Add-SQLOpOperatingSystem
Get-SQLOpOperatingSystem
Get-SIOperatingSystemAdd-SqlTable
Add-SQLOpSQLCluster
Get-SQLOpSQLCluster
Update-SQLOpSQLCluster
— No Command-Let Collected from CMS —Clear-SQLOpData
Add-SQLOpServer
Get-SQLOpServer
Update-SQLOpServer
— No Command-Let Collected from CMS —Get-SQLErrorLogs
Add-SQLOpSQLClusterNode
Get-SQLOpSQLClusterNode
Update-SQLOpSQLClusterNode
Get-SIExtendedPropertiesGet-SQLOpErrorDetails
Add-SQLOpSQLInstance
Get-SQLOpSQLInstance
Update-SQLOpSQLInstance
— No Command-Let Collected from CMS —Get-SQLOpSettings
Set-SQLOpSetting
Get-SQLOpAvailabilityGroup
Update-SQLOpAvailabilityGroup
Get-SIAvailabilityGroupsGet-SqlType
Update-SQLOpDatabasePermissionGet-SIDatabasePermissionInitialize-SQLOpsDB
Update-SQLOpDatabasePrincipalMembershipGet-SIDatabasePrincipalMembershipOut-DataTableV2
Update-SQLOpDatabaseRoleGet-SIDatabaseRolePublish-SQLOpMonthlyAggregate
Update-SQLOpDatabaseGet-SIDatabasesPublish-SQLOpSnapshot
Update-DiskVolumesGet-SIDiskVolume
Get-SISQLVolumeDetails
Publish-SQLOpTreadData
Get-SIMemorySplit-Parts
Get-SIProcessorWrite-StatusUpdate
Update-SQLOpServerPermissionGet-SIServerPermissionSet-SQLOpReportLogo
Update-SQLOpServerPrincipalMembershipGet-SIServerPrincipalMembership
Update-SQLOpServerRoleGet-SIServerRole
Get-SQLOpSQLErrorLogStats
Update-SQLOpSQLErrorLogStats
Update-SQLOpSQLErrorLog
Get-SISQLErrorLogs
Get-SQLOpSQLJobs
Get-SQLOpSQLJobStats
Update-SQLOpSQLJobs
Update-SQLOpSQLJobStats
Get-SISQLJobs
Get-SQLOpSQLPropertiesGet-SISQLProperties
Get-SQLOpSQLService
Update-SQLOpSQLService
Get-SISQLService
Get-SQLOpCMSGroups
Get-SQLOpCMSServerInstance
Set-SQLOpCMSGroups
Update-SQLOpExtendedPropertiesSet-SIExtendedProperties


The command lets between SQLOp* and SI* are grouped as they are used together. I will explain each command-let and intent in later blog posts.

2 comments

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.