Help with labels
Hi all, I'm setting up a managed install and must be doing something totally wrong... The program I am setting up is called AeriesCS, it uses Access to connect back to a SQL server. Since we have access 2003, 2007 and 2010 running I need to use smart labels (as someone helped me with a few weeks ago) to kick off the correct install. The problem is when I assign the MI to a machine with office 2007 it's installing the 2003 and 2010 versions instead of the correct one...
Here is what I hve done... First I setup a machine label for the MI that I could make the smart labels join if they met the criteria I specified.
Next I setup machine based smart labels to detect the version of office installed, the labels are populated properly and my test machine did become a member of the office 2007 label. When checking the machines specifics in inventory I see that it has 2 MIs for the incorrect version of office even though it's showing up in the correct AeriesCs 2007 smart label.
Any thoughts on what I'm missing here guys? I swear in my mind I'm doing it right - but it's sure not working that way!
Thanks for any info!
Dennis
Answers (2)
Can you post your SQL queries for the labels? This might help.
Comments:
-
Or, if it was created through the label wizard, what did you select? - jknox 11 years ago
-
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.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 '%Microsoft Office Professional Plus 2010%')) ) 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 '%All Sites - Aeries CS%')) )) - ddevore 11 years ago -
Thanks for getting back, here are the three smart labels I setup using the wizard. - ddevore 11 years ago
-
Is it possible that some machines contain two versions of office? I did a quick search on my Kbox and found 177 machines with both Microsoft Office Professional Plus 2007 and Microsoft Office Professional Edition 2003. - dugullett 11 years ago
-
I've seen a bit of that out in the wild as well. This test machine only has 2007 on it, right now the only smart label to pick it up is the one for office 2007... The part killing me is under the MI area for the specific machine it wants to install both of the ones for the versions of office it does not have. - ddevore 11 years ago
How are you assigning the MI to the machine? Via the smart label?
Comments:
-
I drop the machine into a non-smart label that should be nesting the three smart labels that are checking for the version of access installed. It does work - just the opposite as I want... - ddevore 11 years ago
