How to get last login time of all user in OBIEE without using usage tracking
Try looking in your log files if you have a log level high enough.
But you should really consider enabling usage tracking as it's useful for various tasks.
+1 to what Gianni said. Without Usage Tracking - have fun looking at the log files. It's one one the reasons why not enabling UT is just one of the worst approaches for any OA implementation.
Thanks for reply. Usage tracking is enabled recently but need history of user before the UT implementation.
You have information in the WLS logs which handles the security backend and also some information in the sawlog (OBIPS) but it'll be anything but straight-forward to get it out. Will be a manual task, sorry.