Nested Labels and Smart Labels work when tested but fail to tag after check-in's
I have a couple static labels that I use to collect machines needing JRE; one global Java7 Targets and one per region of the Java7 Targets such as Java7East Targets and Java7NW Targets.
My smart labels look for labels that begin with Java7East Targets and Java7-to-install which is a smart label that targets machines in the
Java7 Targets and Software Version Number != 7.0.130. From this the machnes get the smart label JRE7East2Install or JRENW2Install.
In my fiddling, I created the one smart label JRE7East2Install working possibly after squeezing the spaces out of the other labels and choosing alternative names to the batch of others, but, if I use the smart lable creator from the computer inventory tab, modifying for each region, they produce no results after checkin; unlike they tested.
A new test smart label will, but, if I copy the sql syntax to the other smart labels... still nothing.
I have K1000 server ver. 5.3.53053 and agents ver. 5.3.53177. Is there a known issue with these versions or flaw in my nesting?
This in an example of a regional smart lable:
select *, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME,
UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS
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 ((( (1 in (select 1 from ORG1.LABEL, ORG1.MACHINE_LABEL_JT where MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID and MACHINE_LABEL_JT.LABEL_ID = LABEL.ID and LABEL.TYPE != 'hidden' and LABEL.NAME like 'Java7East Targets%')) ) AND (1 in (select 1 from ORG1.LABEL, ORG1.MACHINE_LABEL_JT where MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID and MACHINE_LABEL_JT.LABEL_ID = LABEL.ID and LABEL.TYPE != 'hidden' and LABEL.NAME like 'Java7-to-install%')) ))