SMS Query:

select distinct SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier,

SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserName,

SMS_G_System_SoftwareFile.FileName, SMS_G_System_SoftwareFile.FileVersion,

SMS_G_System_SoftwareFile.FileSize, SMS_G_System_SoftwareFile.ModifiedDate from

SMS_R_System inner join SMS_G_System_SoftwareFile on

SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where

SMS_G_System_SoftwareFile.FileName = "wintrv.exe"

Every 3 months or so a new Bloomberg is released. Bloomberg can push updates to PCs but sometimes, if the version of Bloomberg on a PC is very old, it is not possible for Bloomberg to push the update and the user gets a message that their Bloomberg is too old.

We don't have to re-script Bloomberg every 3 months using SMS Installer. Bloomberg install executable has its own silent installation routine if you use /s.

This is configurable using an INI file. As it happens the defaults are all fine for us so we don't have to use an INI file at all. Here is the command line required to do silent install with Bloomberg's install exe. Also configuration INI file format and an SMS query which can be used to spot Bloomberg installations that are old. I got this from Bloomberg, "Although we do not directly support customers who choose to script their software, we have tested the attached file and procedure listed below."

sotrt0307.exe /s /cfg=config.ini

Download sotrt12345678.exe (name changes often). The actual sotrt12345678.exe file can be found at http://www.bloomberg.com/professional/software_support (section: Software Support -> Bloomberg Professional Service -> New Installation)

According to http://www.bloomberg.com/professional/software_faq (section: Software -> How do I silently install Bloomberg for my company?) you install Bloomberg once and in temp directory is a configuration file (setup.blp) created. This file can be used for deployment.

Execute sotrt12345678.exe file the following command line switches:

sotrt12345678.exe /s /cfg=C:\setup.blp /perm=default

Explanation of the command line switches:

/s                               silent setup
/cfg=C:\setup.blp    recorded configuration
/perm=default          correct permission settings