Shocking news for TM1 Administrators!

Advertisements, add-ons and other commercial information
Post Reply
Kyro
Community Contributor
Posts: 123
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: IBM Cognos TM1 all the way!
Version: You name it.
Excel Version: 2003 -2007 -2010
Location: Sydney, Australia
Contact:

Shocking news for TM1 Administrators!

Post by Kyro » Thu May 23, 2013 2:10 am

Comrades-in-arms,

I'm proud as punch to release a InfoCube Spark - a complimentary TM1 monitoring service which encorperates TM1Top, HDD & Ram Monitoring, Server Logs, Alerts and Notifications and much more still in development. Best of all its free. See a real account which is monitoring InfoCubes Development CX Servers here:

http://monitor.infocube.com.au
Username: tester
Password: abc123

Hope you like it. I would love some feedback - please either post here, on the blog or email me - ben [dot] hill [at] infocube.com.au.

Thanks again,
Ben
Last edited by Kyro on Tue May 28, 2013 3:28 am, edited 1 time in total.

User avatar
Harvey
Community Contributor
Posts: 218
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: Complimentary TM1 Application & Server Monitoring Servic

Post by Harvey » Fri May 24, 2013 4:56 am

This looks good, Ben, nice work. It has an attractive visual design, simple intuitive interface and useful functionality for monitoring servers.

I couldn't quite work out how to get a copy to try it out on my own servers, can you clarify the process?

Also, do I need a particular web server installed to run it, if so, which -- or does it have its own embedded web server?
Flow OLAP - thinking outside the cube.

Kyro
Community Contributor
Posts: 123
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: IBM Cognos TM1 all the way!
Version: You name it.
Excel Version: 2003 -2007 -2010
Location: Sydney, Australia
Contact:

Re: Complimentary TM1 Application & Server Monitoring Servic

Post by Kyro » Fri May 24, 2013 5:33 am

Thanks Lazarus,

The steps to getting this to monitor your servers can be found here: http://monitor.infocube.com.au/guide/

All you need to do is:
1. Register an account
2. Add a server entry to the portal (which will give you a server key)
3. Download the spark updater
4. Schedule it to run as often as you want to see updates online
5. Add the server key into the spark updater config file.

This will give you:
TM1 Top Data
CPU Usage
HDD Capacity
RAM Capacity
TM1Server.log
Some really cool charting - we presently have more data then the dashboard shows so we are looking at what other visualisations we can add in the future.

Thanks again for testing it out. Dick Smiths, Endeavour Energy and Cerebos among many others are all using this to monitor utilisation of their servers.

B

Christopher Kernahan
Community Contributor
Posts: 147
Joined: Mon Nov 29, 2010 6:30 pm
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: Office 2010

Re: Complimentary TM1 Application & Server Monitoring Servic

Post by Christopher Kernahan » Fri May 24, 2013 6:04 am

This is really great - is that a Bootstrap theme? Looking forward to seeing how you evolve the monitoring - are you thinking of extending it into more of an analytical tool?

User avatar
Harvey
Community Contributor
Posts: 218
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: Complimentary TM1 Application & Server Monitoring Servic

Post by Harvey » Fri May 24, 2013 7:49 am

Kyro wrote:The steps to getting this to monitor your servers can be found here: http://monitor.infocube.com.au/guide/
Man, I thought I was smart, but I didn't realize I could click on those to expand the info. Thanks Ben, will sign up and check it out.

What's the deal if we want to install this at a client site? What about un-hosted installs in situations where we can't expose the server to the open internet?
Flow OLAP - thinking outside the cube.

User avatar
Steve Vincent
Site Admin
Posts: 1050
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Complimentary TM1 Application & Server Monitoring Servic

Post by Steve Vincent » Fri May 24, 2013 10:14 am

Lazarus wrote: What's the deal if we want to install this at a client site? What about un-hosted installs in situations where we can't expose the server to the open internet?
Indeed this is exactly the sort of stuff we have been looking at, but not nearly as slick. We can not expose our servers to the internet due to security restrictions, so the only way we could use it would be via a locally hosted portal...
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

Kyro
Community Contributor
Posts: 123
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: IBM Cognos TM1 all the way!
Version: You name it.
Excel Version: 2003 -2007 -2010
Location: Sydney, Australia
Contact:

Re: Complimentary TM1 Application & Server Monitoring Servic

Post by Kyro » Sat May 25, 2013 12:08 am

Lazarus wrote:What's the deal if we want to install this at a client site? What about un-hosted installs in situations where we can't expose the server to the open internet?
No plans for un-hosted implementations. We've only had one client with this kind of setup (server with no internet access) and our contact sent a request to IT and they sorted it in 5 min. I'm not sure if this kind of policy is mainstream any longer with the advent of cloud computing and auto update software.

Note: Just implemented Minor Error Logging and a page dedicated to searching the TM1Server.log.

Image

User avatar
Harvey
Community Contributor
Posts: 218
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: Shocking news for TM1 Administrators!

Post by Harvey » Tue May 28, 2013 9:05 am

I wrote what I hope was a thorough evaluation of setting up and using Spark monitor on the Flow Blog.

If you're interested, you can check out the article.
Flow OLAP - thinking outside the cube.

tomok
MVP
Posts: 2595
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Shocking news for TM1 Administrators!

Post by tomok » Tue May 28, 2013 12:21 pm

I applaud your ingenuity but I can't think of a single company, at least in the U.S., that is going to allow their TM1 server to communicate with an un-vetted third party company outside the firewall. If you really want to make money on this you need to sell the software so that it can be run by the companies themselves inside their own firewalls. Once again, great idea, just may need a tweak to your business model to realize it's potential.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

User avatar
Harvey
Community Contributor
Posts: 218
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: Shocking news for TM1 Administrators!

Post by Harvey » Tue May 28, 2013 12:43 pm

Hey tomok, I thought the same thing at first, and you're right some companies will not allow it if they have rigid IT policies.

But since it does not require your TM1 username and password, it's not as much of a security risk as I originally thought it might be. It simply reads the TM1 logs, TM1Top information and machine performance counters.

I guess you could argue that it could do something outside of what it says it does, as it does sit on the same physical machine as the TM1 data folder, but you can easily prevent this using file system security.
Flow OLAP - thinking outside the cube.

User avatar
jim wood
Site Admin
Posts: 3723
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Shocking news for TM1 Administrators!

Post by jim wood » Tue May 28, 2013 2:58 pm

Lazarus,

I think you are missing Tomok's point. It has nothing to do with user names and passwords. It's all about port numbers. Unless this is using a port already allowed by a companies firewall it will never make it out. Virtually all the companies I have encountered in the US and the UK would only let it through if it went through a full analysis and purchase cycle. During this process they would identify the risks of opening up such a port. Keep in mind we are talking about bigger customers now that big blue holds the reigns. We are not in small time Applixville any longer,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
Harvey
Community Contributor
Posts: 218
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: Shocking news for TM1 Administrators!

Post by Harvey » Tue May 28, 2013 5:15 pm

No I agree, but there's no need to open any ports. I had the same concerns before I communicated with Ben about it.

If you look at the architecture of the program, you''ll see the Monitor program sits in between the TM1 Server and the web application server, regularly pushing data out via a tcp/ip channel. Since ports are for programs to monitor and respond to non-initiated incoming traffic, it's not an issue. The server just needs an outbound internet connection and it'll work fine.

I've worked for many large corporates in the past, not just consulting with TM1 but developing client-server software, and in some it was a painful process to get IT to grant a server internet access, but I never found one that was unable to do it.

Sure, the Monitor program itself might have to go through SIT in large companies, and having internet access on the TM1 server may be an issue for some also, but it's not a port issue.

Anyway, it'll be the customer's choice at the end of the day, but I don't see any reason not to give them the option, given it's a better monitoring option than they get out of the box.
Flow OLAP - thinking outside the cube.

Kyro
Community Contributor
Posts: 123
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: IBM Cognos TM1 all the way!
Version: You name it.
Excel Version: 2003 -2007 -2010
Location: Sydney, Australia
Contact:

Re: Shocking news for TM1 Administrators!

Post by Kyro » Wed May 29, 2013 1:34 am

Thanks for the review Lazarus.
Jim, Tomok, the system has been designed to be simple from the go. Its as Lazarus says, all you need is an internet connection on your server and your ready to schedule the monitor to update the cloud as often as you like.

The only information we collect is Performance Monitor, TM1Top, TM1s.cfg, TM1Server.log, TM1 Audit Log, TM1 Process Error Logs and Operating System Version.

We may make an optional free extra that Spark will document your environment for you and formulate a wiki, but we aren't there yet - new features which require more data will always be an Opt-in system configured from the settings page.

We've just added a TM1 Top page which displays TM1 Top data and history (line chart) for each server on your account.
Admittedly this looks much better for our clients where they have a lot of activity.
Image

User avatar
Steve Vincent
Site Admin
Posts: 1050
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Shocking news for TM1 Administrators!

Post by Steve Vincent » Wed May 29, 2013 11:54 am

it all looks excellent but due to the nature of the work here there is no way we can implement it :roll: i can't even send a TM1 server crash log to IBM due to security restrictions...
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

Kyro
Community Contributor
Posts: 123
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: IBM Cognos TM1 all the way!
Version: You name it.
Excel Version: 2003 -2007 -2010
Location: Sydney, Australia
Contact:

Re: Shocking news for TM1 Administrators!

Post by Kyro » Thu May 30, 2013 1:38 am

Too bad Steve. It hasn't stopped 35 other companies from coming online in the first week.
Happy 1 Week Anniversary Spark! ;)
Russia, USA, UK, Australia and NZ all included.

Post Reply