Monitoring User Logins
Monitoring User Logins
Hi there
We are running Pa2, and I am trying to get a record of user logins.
Transaction logging is set for the }ClientProperties cube, but when I review the transaction log, nothing is there.
Any idea?
Regards
Chris
We are running Pa2, and I am trying to get a record of user logins.
Transaction logging is set for the }ClientProperties cube, but when I review the transaction log, nothing is there.
Any idea?
Regards
Chris
-
- 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: Monitoring User Logins
Check }CubeProperties LOGGINING mustbe "YES"
-
- MVP
- Posts: 3120
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Monitoring User Logins
Did you do a Savedata, in order to get a timestamped text file (in the logging directory) containing the data changes since the last savedata or server restart ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- MVP
- Posts: 2832
- 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: Monitoring User Logins
Putting something like this in your tm1slog.properties file will create a separate log file with login activity:
This particular example writes all login activity to a file called lock.log.
Code: Select all
log4j.logger.TM1.Login=DEBUG, LOCK
log4j.additivity.TM1.Login=false
log4j.appender.LOCK=org.apache.log4j.SharedMemoryAppender
log4j.appender.LOCK.File=lock.log
log4j.appender.LOCK.MaxFileSize=100 MB
log4j.appender.LOCK.MaxBackupIndex=20
log4j.appender.LOCK.TimeZone=GMT
Re: Monitoring User Logins
Hi there
Logging is set, and we do a SaveData every 5 minutes
Regards
Chris
Logging is set, and we do a SaveData every 5 minutes
Regards
Chris
-
- MVP
- Posts: 2832
- 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: Monitoring User Logins
I'm not sure what you are trying to capture with the }ClientProperties cube. There is no attribute in that cube that is going to show login activity. You are going to have to do that in a log like the example I gave you. You don't have to create a separate file, you can make it write to the server log, but you have to have the
log4j.logger.TM1.Login=DEBUG, LOCK
log4j.additivity.TM1.Login=false
lines in your tm1slogging.properties file.
log4j.logger.TM1.Login=DEBUG, LOCK
log4j.additivity.TM1.Login=false
lines in your tm1slogging.properties file.
Re: Monitoring User Logins
Hi Tom
Much appreciated, will give it a bash.
Regarding the }ClientProperties cube, I have seen a few posts where people claim that checking out a transaction log on this cube will give you login information.
Regards
Chris
Much appreciated, will give it a bash.
Regarding the }ClientProperties cube, I have seen a few posts where people claim that checking out a transaction log on this cube will give you login information.
Regards
Chris
-
- MVP
- Posts: 2832
- 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: Monitoring User Logins
Maybe it used to work in TM1 but it does not in PA. I am on PA and I double-checked again to make sure. There is nothing written to the transaction log for the }ClientProperties cube when a user logs in. The solution involving the tm1s-log.properties setting is the only sure-fire way to get what you want that I know of.
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Monitoring User Logins
Almost, and in addition ClientPropertiesSyncInterval must be in tm1s.cfg
It works and works fine. But for anything to be written against <}ClientProperties, userID, STATUS> ClientPropertiesSyncInterval must be set. It has been like this for a loooong time, like since 9.5 or 10.1
But the solution already suggested to write to a separate log file by adding parameters to tm1s-log.properties file is a much better solution.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- MVP
- Posts: 3120
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Monitoring User Logins
Hmmm, every 5 minutes. Isn't that window rather short ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 5
- Joined: Tue Aug 27, 2019 5:29 am
- OLAP Product: IBM Cognos TM1
- Version: IBM Planning Analytics 2.0
- Excel Version: Professional 2016
Re: Monitoring User Logins
Hi,
I cannot find the location for the tm1slog.properties file? Is it not in the same location as the tm1s config file?
Thanks,
I cannot find the location for the tm1slog.properties file? Is it not in the same location as the tm1s config file?
Thanks,
-
- MVP
- Posts: 3120
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Monitoring User Logins
Yes. If it’s not there, you should create it. There are examples in the documentation, for example.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- MVP
- Posts: 2832
- 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: Monitoring User Logins
It is actually called tm1s-log.properties.
-
- Posts: 5
- Joined: Tue Aug 27, 2019 5:29 am
- OLAP Product: IBM Cognos TM1
- Version: IBM Planning Analytics 2.0
- Excel Version: Professional 2016
Re: Monitoring User Logins
Yes - I cannot find this file either. Will I need to manually create a file and name it ''tm1s-log.properties''.
Thanks,
-
- Posts: 5
- Joined: Tue Aug 27, 2019 5:29 am
- OLAP Product: IBM Cognos TM1
- Version: IBM Planning Analytics 2.0
- Excel Version: Professional 2016
Re: Monitoring User Logins
Thanks everyone, will give it a try now.
-
- MVP
- Posts: 3120
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Monitoring User Logins
Didn't you see my post above ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- MVP
- Posts: 2832
- 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: Monitoring User Logins
While we're on the subject of logging, if you put this in your tm1s-log.properties file it will create a separate log called TI.log that will contain all messages you send from a TI:
I use it to record all instances of a TI process running, who ran it, and what parameters they used. Here is an example:
In this example I will get an entry in the TI.log file that looks like this when the process is run:
Having this information in a log is extremely helpful when trying to debug a process or finding out who did something.
Code: Select all
log4j.logger.TM1.TILogOutput=DEBUG, Debug_LogOutput
log4j.appender.Debug_LogOutput=org.apache.log4j.SharedMemoryAppender
log4j.additivity.TM1.TILogOutput=false
log4j.appender.Debug_LogOutput.File=TI.log
log4j.appender.Debug_LogOutput.MaxFileSize=100 MB
Code: Select all
# ========================== WRITE PARAMS TO LOG ==================================
LOGOUTPUT('INFO', '---------------------------------------------------------------------------------');
LOGOUTPUT('INFO', GETPROCESSNAME());
LOGOUTPUT('INFO', 'Executed by ' | TM1USER());
LOGOUTPUT('INFO', 'pPeriod - ' | pPeriod);
LOGOUTPUT('INFO', 'pSourceVersion - ' | pSourceVersion);
LOGOUTPUT('INFO', 'pTargetVersion - ' | pTargetVersion);
Code: Select all
17380 [2032] INFO 2020-02-04 20:23:00.658 TM1.TILogOutput Copy Version
17380 [2032] INFO 2020-02-04 20:23:00.658 TM1.TILogOutput Executed by Planning Analytics/Test User
17380 [2032] INFO 2020-02-04 20:23:00.658 TM1.TILogOutput pPeriod - Jan-2020
17380 [2032] INFO 2020-02-04 20:23:00.658 TM1.TILogOutput pSourceVersion - Actual
17380 [2032] INFO 2020-02-04 20:23:00.658 TM1.TILogOutput pTargetVersion - Forecast
Re: Monitoring User Logins
Hi Tom
Thanks once again for all your help. I have created a tm1s-log.properties file, but now the tm1server.log file has disappeared.
I still want this file to get all info about model startup, when users run TIs etc.
Any idea why?
Below is the contents of my log file.
Many thx!
Regards
Chris
Thanks once again for all your help. I have created a tm1s-log.properties file, but now the tm1server.log file has disappeared.
I still want this file to get all info about model startup, when users run TIs etc.
Any idea why?
Below is the contents of my log file.
Many thx!
Regards
Chris
- qml
- MVP
- Posts: 1094
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Monitoring User Logins
Kamil Arendt