KACE Product Support

A machine label is a label on machines regardless of what that label is based upon the label is applied to machines. Are you certain that the "software label" you describe is not or should not be a "machine label"?

You can designate what objects a label has the potential to identify. You can do this by editing the label Home->Label->Label Management -> restrict label usage to. Perhaps you have restricted it's usage to the wrong object types?

the smart label was created from within Inventory -- Software, and identifies 24 versions of flash that are running across our systems, when i apply it to machines, and try to view by label from Inventory -- Machines, i dosent come up with any computers, likewise when i apply the label to machines also it does not attempt to deploy on any machines as the smart label doesnt contain any.

How are you applying it to machines?

If you wanted to identify all the machines with adobe you would create this smart label from the computer inventory tab (not software inventory tab) When you "test" a smart label it gives you a preview of what could be in the label. When you create it no machines are in it until they check in.

I just ran a quick test and I was able to put all my machines with adobe into a smart label using the wizard on the computer inventory tab. The sql behind (as shown if you go home->label->label managemtn ->click on smart label ) it is:
select *, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME,
UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS
from ORG2.MACHINE
LEFT JOIN KBSYS.KUID_ORGANIZATION ON KUID_ORGANIZATION.KUID=MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION ON SMMP_CONNECTION.KUID = MACHINE.KUID AND KUID_ORGANIZATION.ORGANIZATION_ID = 2
where (( (1 in (select 1 from ORG2.SOFTWARE, ORG2.MACHINE_SOFTWARE_JT where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and SOFTWARE.DISPLAY_NAME like '%adobe%')) ))


Since version is not a field to use in the filter creation on machines when relatingto software you have to tweak the query. To narrow this down to name AND version you would rewrite it to something like this (note i rewrote it for efficiency as well):

select DISTINCT MACHINE.*, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME,
UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS
from MACHINE
JOIN MACHINE_SOFTWARE_JT MS ON MS.MACHINE_ID=MACHINE.ID
JOIN SOFTWARE S ON S.ID=MS.SOFTWARE_ID
LEFT JOIN KBSYS.KUID_ORGANIZATION ON KUID_ORGANIZATION.KUID=MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION ON SMMP_CONNECTION.KUID = MACHINE.KUID AND KUID_ORGANIZATION.ORGANIZATION_ID = 1
where DISPLAY_NAME LIKE 'Adobe Flash Player%' and DISPLAY_VERSION RLIKE '^10[[...]][0-1][[...]]'

ah, ok, that makes more sense, so i would need to tweak the SQL, thats fine, i was wondering if there was a method of doing it out of the box.