Hi All,
We are currently monitoring the tm1 server memory usage for our tm1 model.
In this regard, I would like to have tm1 cube memory size and dimension size and data directory size etc.....
generated in CSV file or email alerts to know current memory usage in tm1 model in server.
Currently memory size of cubes and dim- I am manually checking it in tm1 perspective server explorer to know memory usage.
Is there way you can suggest to write IT proces.......?
Thanks and Regards,
Ravi
Export or email memory usage
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Export or email memory usage
As long as you already know which cubes the data you wish to view is held in why can't you just use asciioutput to create your CSV file within a TI and then something like sendemail.exe within another TI (described extensively on this forum) to pick up that CSV file and send it as an attachment?ravi wrote:Hi All,
We are currently monitoring the tm1 server memory usage for our tm1 model.
In this regard, I would like to have tm1 cube memory size and dimension size and data directory size etc.....
generated in CSV file or email alerts to know current memory usage in tm1 model in server.
Currently memory size of cubes and dim- I am manually checking it in tm1 perspective server explorer to know memory usage.
Is there way you can suggest to write IT proces.......?
Thanks and Regards,
Ravi
If there is a specific part of the process you are struggling with, then I'm sure we will be able to point you in the right direction.
Declan Rodger
-
- Posts: 141
- Joined: Wed Mar 09, 2011 1:25 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2003 2007 2010 2013
Re: Export or email memory usage
Do you have an email system pearl script configured to use Ravi?
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: Export or email memory usage
If you don't want to create your own take a look at Blat.exe command line smtp emailer.
It takes care of attachments, HTML emails, etc. super easy to use. We built a standard process for sending emails. That intakes parameters and builds the command line call dynamically so anyone can send emails from TM1.
It takes care of attachments, HTML emails, etc. super easy to use. We built a standard process for sending emails. That intakes parameters and builds the command line call dynamically so anyone can send emails from TM1.
- 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: Export or email memory usage
I think gathering server physical memory uasge info is more practical to prevent server crash. As long as your cubes can live with current server's memory, it is meanless to check them all the time. Unless you use up all your server memory, it is time to re-order or clean up tm1 objects.