/build/static/layout/Breadcrumb_cap_w.png

How do you deploy software with managed installation using a custom inventory field?

I have created a custom inventory field that consists of the version number of the software.  Is there a way to reference this custom field to deploy software using managed installs?

FileInfoReturn(C:\Program Files\FourJs\gdc\bin\gdc.exe,FileVersion, TEXT)

I need to upgrade this software.  The software already exists on the computers with an older version.  The file version information uses commas instead of periods, so I cannot used the Kace custom inventory rule to check for file version.

FileVersionEquals(c:\program files\fourjs\gdc\bin\gdc.exe, 2.22.0.6) - does not work

Thanks for any assistance.

 

 


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: darkhawktman 11 years ago
Green Belt
3

I had this same problem a while ago. First you want to create a new Software item with the Custom Inventory Rule of FileInfoReturn(C:\Program Files\FourJs\gdc\bin\gdc.exe,FileVersion, TEXT) 

Next you want to create another software item and attach your install files to this record. Note: you do not want to create a custom inventory rule for this software item.

Now create a Computer Inventory Label that you will need to manually apply to all of the computers that need to have this software. Let's call it M-Software.

Now create a smart label. Let's call it F-Software and put this info in

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 not in (select 1 from ORG1.MACHINE_CUSTOM_INVENTORY where MACHINE.ID = MACHINE_CUSTOM_INVENTORY.ID and MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID = SoftwareIDofCustomInventory and MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE = 'FileVersionWithCommas')) ) 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 = 'M-Software')) ))

Replace SoftwareIDofCustomInventory with the Software ID number of the custom inventory item we created earlier and replace FileVersionWithCommas with the file version of the new software you want to deploy.

Finally create a Managed install using the software record with the attached install files and add the F-Software label to the Managed install.

So what this does, is looks at all computers and finds out what version of the software is installed if it is installed. Next the kbox looks if the M-Software label is applied to the computer. If a computer has the M-Software label and the version of the software does not equal the version you are trying to deploy or isn't installed at all, the kbox will apply the F-Software label to the computer and deploy the software to the computer.

After the software successfully installs the kbox should find that the software version is now up-to-date and remove the F-Software label from the computer and will not try to deploy the software to the machine again.


Comments:
  • This is just what I needed. Thanks alot. - kathywilson 11 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ