How to determine the version of the IBM Cognos TM1 installation

[gtonkin]

Saw this post today from IBM.

May be useful if you have not already got your own spreadsheet that is tracking this information for your own sanity.

[TrevorGoss]

We have a TI that can find out for us aswell, it runs via the ExecuteCommand function:

Code: Select all

Quote = CHAR(34);

## Change to actual path of tm1sd.exe
LocationOfBinary = 'x:\\blah\\blah\\blah\\blah\\blah\\tm1sd.exe';

## change to desired path
OutputFile = 'x:\VersionOfTM1.txt';

## Command line

Command = 'cmd /c wmic datafile where Name=' | Quote | LocationOfBinary | Quote | ' get ' | Quote | 'Version' | Quote | ' > ' | Quote | Outputfile | Quote;


ExecuteCommand(Command,0);

DataSourceNameForServer = Outputfile;

it also prints out the version to a text file

[declanr]

How often do you change versions to make a TI worthwhile?

I suppose it could be neat to put it into a startup chore and load the result to a control cube - but again if you wanted that data in a control cube you could just have someone check and update it as and when upgrades are done.
Annoyingly the location of the tm1sd.exe file also changes depending on company policy/who did the install/what version you are on so there is a small manual effort required to keep the TI up to date.

cmplst.txt file has been around for a while now and seems to suffice - the annoying part is trying to find a definitive list from IBM where you can compare your build numbers to an associated fix pack etc but they are getting better at publishing them... just have to go through the maze to find it.

[TrevorGoss]

How often do you change versions to make a TI worthwhile?

Indeed, we rarely use it, but to get the exact version number at the click of the button has proved useful for us in the past, a control cube could help but the TI provides us with a quick .txt file that tells us the same information, no need for extra metadata.

Annoyingly the location of the tm1sd.exe file also changes depending on company policy/who did the install/what version you are on so there is a small manual effort required to keep the TI up to date.

A more enhanced script could counter this annoying issue.

cmplst.txt file has been around for a while now and seems to suffice - the annoying part is trying to find a definitive list from IBM where you can compare your build numbers to an associated fix pack etc but they are getting better at publishing them... just have to go through the maze to find it.

Agreed.