Updating Custom SQL Queries for 10.0 (4287979)

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.

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.