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

 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

Can you post your SQL queries for the labels? This might help.

Answered 10/11/2012 by: dugullett
Red Belt

  • Or, if it was created through the label wizard, what did you select?
  • This content is currently hidden from public view.
    Reason: dupe
    For more information, visit our FAQ's.
  • This content is currently hidden from public view.
    Reason: dupe
    For more information, visit our FAQ's.
  • 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%')) ))
  • Thanks for getting back, here are the three smart labels I setup using the wizard.
    • 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.
  • 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.
Please log in to comment
0

How are you assigning the MI to the machine? Via the smart label?

Answered 10/11/2012 by: chucksteel
Red Belt

  • 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...
Please log in to comment
Answer this question or Comment on this question for clarity