Parsing TM1AuditLog files for getting login info

[anoops81]

Hi All ,

We are using TM1 9.4.1 FP3.Have around 400 TM1 users globally. We have Audit log enabled, Now top management want to check on how many users have not logged into cognos tm1till now (for making effective utilization of tm1 licences). I need a way where I can parse the tm1audit.log files and get the information in excel format . I am attaching the sample of audit log file and the excel sheet format in which i need the information . I know that we can use view auditlog option to get this information manually into a csv file or XLM file . But the number of rows for successfull login is coming as more than 25,000 for a period of 10 days. Could anyone please help me on this


Thanks & Regards
Anoop

[mattgoff]

This is pretty easily written in perl. Do you have it installed or can you? I could whip something up as I'd like to have this for my own stats (and possible disable my user logging cube/chore.

I hadn't looked at these logs before, but it's irritating that, once again, IBM Cognos has shunned industry standard formats (XML or JSON) and made up their own. I'd hoped IBM would have influenced them to be more standardized.

Matt

[anoops81]

Hi Matt ,

I have installed "ActivePerl 5.10.1 Build 1007" in my local machine. Could you please guide me on next step ? I am new to perl scripting.


Thanks & Regards
Anoop