Hi Guys,
Here again to ask.
I just want to know if there's a way I can get using a TI the IP address/admin host of my TM1 server? I know OPTGET but its for VBA.
Does anyone know?
Thanks a lot.
Bunch
Get the Admin Host of TM1 server
-
- Regular Participant
- Posts: 197
- Joined: Thu Dec 03, 2009 8:47 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2.x
- Excel Version: 2010
- Location: Singapore
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Get the Admin Host of TM1 server
You could create a TI to create/ run a .bat which could output the IP of the host machine to a text file which could then be picked up by another TI?
-
- Regular Participant
- Posts: 197
- Joined: Thu Dec 03, 2009 8:47 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2.x
- Excel Version: 2010
- Location: Singapore
Re: Get the Admin Host of TM1 server
Yes Sir Edward,
Here's what I found. In my .bat file,
ipconfig > ip.txt
or
ipconfig | find "IP Address" > ip.txt
Thank you Sir.
Bunch
Here's what I found. In my .bat file,
ipconfig > ip.txt
or
ipconfig | find "IP Address" > ip.txt
Thank you Sir.
Bunch
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Get the Admin Host of TM1 server
bunchukokoy wrote:Yes Sir Edward,
Here's what I found. In my .bat file,
ipconfig > ip.txt
or
ipconfig | find "IP Address" > ip.txt
Thank you Sir.
Bunch
The only thing that you should be aware of is that it'll only provide the Admin host if the Admin Server is running on the same box as the TM1 server. (Which I grant will usually, but not always, be the case.)
I suppose that another option would be to have the TI read the tm1s.cfg file to find the name of the admin host, though I must confess to being perplexed as to why you want this...
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Regular Participant
- Posts: 173
- Joined: Sat Mar 20, 2010 3:03 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007-10
Re: Get the Admin Host of TM1 server
I find it quite useful to have start-up process/chore copy the contents of the config file into a simple cube. That way the values are available for use in websheets, rules, Ti's...
-
- Regular Participant
- Posts: 159
- Joined: Fri Aug 12, 2016 10:02 am
- OLAP Product: tm1
- Version: 10.2.0 - 10.3.0
- Excel Version: 2010
Re: Get the Admin Host of TM1 server
I apologize for raising the old topic but no where there is no explanatory description let it be here
Test this script only on Windows server.
p/s/
adminhost=localhost
Test this script only on Windows server.
p/s/
you do not use in tm1s.cfgsctript created dimension
DimName='sys_ServerParameters';
you can append parameters
pParamsList=UPPER(':adminhost:ServerName:');
or append all parameters
pParamsList='';
adminhost=localhost
- Attachments
-
- sys_GetServerParameters.pro
- (2.88 KiB) Downloaded 318 times
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: Get the Admin Host of TM1 server
I just put the admin host manually into a central control cube where all processes can refer to as it really doesn't change.
-
- Regular Participant
- Posts: 159
- Joined: Fri Aug 12, 2016 10:02 am
- OLAP Product: tm1
- Version: 10.2.0 - 10.3.0
- Excel Version: 2010
Re: Get the Admin Host of TM1 server
I also did this until I transferred a model that starts several hours and left home as a result of which users started the processes on the productive model and the child processes were run on the test.
so I came to the conclusion that it's better to make a process that will do this even when I'm not around.