KACE Product Support

Hi,

I finally upgraded our k1000 9.1 to 10.1, but I have 27 Smart labels mostly related to patching, 2 reports, and 52 patch/detect/deploy labels that failed to convert that are deprecated.

I cannot perform any patching currently and I'm afraid this may take me forever since I didn't create any of these originally and patching changed so much.

I have looked at all of the below links but still cannot figure completely figure it out unfortunately. I manually have replaced many of the old vs new schema/tables (patchlink vs patch), etc., but can't figure out how to substitute some of them.

Like select uid is what now? I'll keep trying though.

Updating Custom SQL Queries for 10.0 (309572) https://support.quest.com/kace-systems-management-appliance/kb/309572/updating-custom-sql-queries-for-10-0

Deprecated Patching Items in the 10.0 Release (264454) https://support.quest.com/kace-systems-management-appliance/kb/264454/deprecated-patching-items-in-the-10-0-release

KACE SMA 10.0 Database Schema Changes (309180) https://support.quest.com/kb/309180/kace-sma-10-0-database-schema-changes

How to run the Patching Migration Report (309381) https://support.quest.com/kb/309381/how-to-run-the-patching-migration-report

I'm hoping since there are so many experts and helpful people on ITNinja if I post two examples of broken smart labels maybe someone can help me correct them and then I hopefully can correct the others because they are similar and then move on to the patching labels/schedules.

List_Missing_Patches_Not_Tested

SELECT UNIX_TIMESTAMP(RELEASEDATE) as DATEPOSTED_SECONDS, KBSYS.PATCHLINK_PATCH.IS_APP, KBSYS.PATCHLINK_PATCH.IMPACTID AS DESCRIPTION, KBSYS.PATCHLINK_PATCH.RELEASEDATE AS DATEPOSTED, KBSYS.PATCHLINK_PATCH.IS_SUPERCEDED, KBSYS.PATCHLINK_PATCH.DESCR, KBSYS.PATCHLINK_PATCH.ID AS BID, KBSYS.PATCHLINK_PATCH.UID AS UID, KBSYS.PATCHLINK_PATCH.IDENTIFIER AS BULLETINID, KBSYS.PATCHLINK_PATCH.STATUSID AS STATUS, KBSYS.PATCHLINK_PATCH.TYPE, KBSYS.PATCHLINK_PATCH.VENDOR, UNPATCHED, YEAR(KBSYS.PATCHLINK_PATCH.RELEASEDATE) as DATEPOSTED_YEAR, PATCHED, KBSYS.PATCHLINK_PATCH.TITLE, KBSYS.PATCHLINK_IMPACT.IMPACT_SEQ, PATCHLINK_PATCH_STATUS.STATUS AS PATCH_STATUS, CACHE_SIZE AS CACHE_SIZE, KBSYS.PATCHLINK_PATCH.ID as TOPIC_ID FROM KBSYS.PATCHLINK_PATCH left join PATCHLINK_PATCH_COUNT on PATCHLINK_PATCH_COUNT.PATCHUID = KBSYS.PATCHLINK_PATCH.UID join KBSYS.PATCHLINK_IMPACT ON KBSYS.PATCHLINK_IMPACT.IMPACT=KBSYS.PATCHLINK_PATCH.IMPACTID left join PATCHLINK_PATCH_STATUS on PATCHLINK_PATCH_STATUS.PATCHUID = KBSYS.PATCHLINK_PATCH.UID WHERE ((( exists (select 1 from PATCHLINK_PATCH_LABEL_JT, LABEL where PATCHLINK_PATCH_LABEL_JT.PATCHUID = KBSYS.PATCHLINK_PATCH.UID AND LABEL.ID = PATCHLINK_PATCH_LABEL_JT.LABEL_ID AND LABEL.TYPE != 'HIDDEN' and LABEL.NAME = 'P_Patches_Not-Tested')) ) AND (( exists (select 1 from PATCHLINK_MACHINE_STATUS MS where MS.PATCHUID = KBSYS.PATCHLINK_PATCH.UID and MS.STATUS = 'NOTPATCHED')) ))

P_OS_Critical_Testing

select UID from KBSYS.PATCHLINK_PATCH where (((( (1 in (select 1 from LABEL, PATCHLINK_PATCH_LABEL_JT where PATCHLINK_PATCH.UID = PATCHLINK_PATCH_LABEL_JT.PATCHUID and PATCHLINK_PATCH_LABEL_JT.LABEL_ID = LABEL.ID and LABEL.NAME = 'P_Patches_In-Testing')) ) AND KBSYS.PATCHLINK_PATCH.RELEASEDATE > DATE_SUB(NOW(), INTERVAL 14 DAY)) AND KBSYS.PATCHLINK_PATCH.IS_APP = '0') AND KBSYS.PATCHLINK_PATCH.IMPACTID = 'Critical')

Any help at all will be appreciated since if I can figure out these two, I think I'll be able to figure out the other 25 smart labels, then start working on the schedules, patch labels and reports.

Thanks,
Jeff