Update UCS Software with Kbox

Issue: 

I need to update the UCS Outlook Connector with the latest version.

Solution:

Use the Kbox 1000 to do it.

How is it going to work:

My thought is

• Use the "Managed Installations" in the "Distribution" area
• Use a smart label to get the systems that need the newest installation
• based off the specific UCS software installed on the system.
• The install of the new software must be installed when Outlook is closed.

The work:

• Failure can't use a software smart label for a distribution.Made a smart label:
• Name:
• SoftwareUCS-7.2.1.520
• Item Type:
• Software
• sql:
• SELECT ID FROM SOFTWARE WHERE ((  SOFTWARE.DISPLAY_NAME like '%ucs%') AND SOFTWARE.DISPLAY_VERSION = '7.2.1.520')
• Make a smart machine label
• Name
• MachinesWithUcs7.2.1.520
• Item Type
• Machine
• SQL
• select MACHINE.*, C.CLIENT_CONNECTED, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME, UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_SECONDS from ORG1.MACHINE LEFT JOIN KBSYS.KUID_ORGANIZATION O ON O.KUID=MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION C ON C.KUID = MACHINE.KUID AND O.ORGANIZATION_ID = 1 where ((( (1 in (select 1 from ORG1.SOFTWARE, ORG1.MACHINE_SOFTWARE_JT where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and SOFTWARE.DISPLAY_NAME like '%ucs%')) ) AND (1 in (select 1 from ORG1.SOFTWARE, ORG1.MACHINE_SOFTWARE_JT where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and SOFTWARE.DISPLAY_VERSION = '7.2.1.520')) ))
• The smart label is not acting correctly
• I test the smart label works in testing
• it shows the machines that are suppose to be listed.
• It was working correctly. I guess a Smart label doesn't update till the computer checks in and attaches that smart label to itself. Weird way of doing it, seeing I don't think I have seen smart labels act like this before. 
• I forced an checkin for the machines and it did populate the smart label.

The Result

This is a simple msi install script that uses smart labels to choose what system to run the script on. It is up and working.