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 DB | Data Access in SQL Infrastructure | SQLOpsDB Utility Command-Lets |
Add-SQLOpOperatingSystem Get-SQLOpOperatingSystem | Get-SIOperatingSystem | Add-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-SIExtendedProperties | Get-SQLOpErrorDetails |
Add-SQLOpSQLInstance Get-SQLOpSQLInstance Update-SQLOpSQLInstance | — No Command-Let Collected from CMS — | Get-SQLOpSettings Set-SQLOpSetting |
Get-SQLOpAvailabilityGroup Update-SQLOpAvailabilityGroup | Get-SIAvailabilityGroups | Get-SqlType |
Update-SQLOpDatabasePermission | Get-SIDatabasePermission | Initialize-SQLOpsDB |
Update-SQLOpDatabasePrincipalMembership | Get-SIDatabasePrincipalMembership | Out-DataTableV2 |
Update-SQLOpDatabaseRole | Get-SIDatabaseRole | Publish-SQLOpMonthlyAggregate |
Update-SQLOpDatabase | Get-SIDatabases | Publish-SQLOpSnapshot |
Update-DiskVolumes | Get-SIDiskVolume Get-SISQLVolumeDetails | Publish-SQLOpTreadData |
Get-SIMemory | Split-Parts | |
Get-SIProcessor | Write-StatusUpdate | |
Update-SQLOpServerPermission | Get-SIServerPermission | Set-SQLOpReportLogo |
Update-SQLOpServerPrincipalMembership | Get-SIServerPrincipalMembership | |
Update-SQLOpServerRole | Get-SIServerRole | |
Get-SQLOpSQLErrorLogStats Update-SQLOpSQLErrorLogStats Update-SQLOpSQLErrorLog | Get-SISQLErrorLogs | |
Get-SQLOpSQLJobs Get-SQLOpSQLJobStats Update-SQLOpSQLJobs Update-SQLOpSQLJobStats | Get-SISQLJobs | |
Get-SQLOpSQLProperties | Get-SISQLProperties | |
Get-SQLOpSQLService Update-SQLOpSQLService | Get-SISQLService | |
Get-SQLOpCMSGroups Get-SQLOpCMSServerInstance Set-SQLOpCMSGroups | ||
Update-SQLOpExtendedProperties | Set-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.
Please make sure to leave a link to the Github repo so we can get the newest changes. 😀
Please follow the https://sqlcan.com/category/administration/sqlopdb/. All posts relating the topics will be grouped there. The Git Link is also documented in the initial post.