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.
SQL Canada (SQLCAN) 
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.