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
from ORG1.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 = 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%')) ))
Answers (1)
Comments:
-
Thanks for this input pultsch! I don't really have anything to test this with any longer. I may have been dealing with a system bug or data corruption at the time. It more than likely was more to do with my own learning curve however.
I continue to have smart label which incorporate other (nested) smart labels and work just fine today in 6.3.113399.
What I have learned since is that when dealing with software versions, they do not necessarily refer to the software title in question; they only need to find another title that matches this version to be considered a match unfortunately. This is a sad reality of using the SQL wizard. There are better ways to form a proper SQL statement manually to get the intended result. So until Dell KACE gets a better wizard that can actually... not sure I'm using the proper syntax but... merge tables or group queries, doing a manual SQL query is all we can use; and luckily the provide this ability. - worzie 8 years ago
Have you had any success since your post? - mcole@ottertail.com 11 years ago