The KACE Systems Management Appliance (SMA) was recently updated to version 10.0. This version provides the new KACE Patch Catalog, but also comes with multiple patch table changes. When using the SMA wizards to create smart labels, reports, custom views, and ticket rules, these changes should be made during the upgrade.
Note: Due to the significant changes, all patching Smart Labels, Reports, Custom Views, and Ticket Rules which were created using a built-in wizard should each be individually reviewed after the upgrade to ensure the automatic changes still produce the desired results.
When it comes to custom SQL queries used in Smart Labels, Reports, Custom Views, and Ticket Rules, these will need to be repaired by hand. It is possible to use the KACE Patching Migration Report to help identify these custom queries.
This article should provide a few direct mappings from old tables to new tables, but note not all tables have direct mapping. For a full list of removed and added tables, please see the KACE SMA 10.0 Database Schema Changes.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.