Table schema reference

It has been noted that in smaller environments a full set of data may not be available. This may cause issues with the automation runbooks and the Power BI report due to required columns not being present in the Log Analytics workspace tables.

Recent updates to the runbooks and the report have improved the handling of potentially missing columns to avoid them throwing errors. However, it is not possible to handle every potentially missing column. Therefore I have published a reference document containing the schema for each table used in this solution. This can be used to check your own tables and add any columns that may be missing.

Note that not every column is required or will be populated in every environment.

You can find the table schema reference here: https://github.com/SMSAgentSoftware/MEM/blob/main/Software%20Updates%20Reporting%20Solution/SU_TableSchema.xlsx

To add any missing columns, in your Log Analytics workspace, go to Tables. Open the context menu for the table and click Edit schema. Add the missing column with the correct data type and save your changes.