Quote:
Originally Posted by Dr.Abdelfattah
Ya , to find out that ,
Open SMC > SR_UserLog > ServiceManager > write the user name and check LoginLoggedout in Catagory > then Date begin and end , Then click Query , Also it may take some seconds or a mint , it's depend on ur Log DB size also ur SQL server speed .
|
I don't think those are stored in the log db.
But rather the Account Database and - LoginLogoutStatistics
I checked the 3 procedure tables that use it. IpStastistics, IpStatisticsOnUserLogin, and IpStatisticsOnUserLogout.
Some of the Data entries for column names were different then what the table column headers used. So I changed them in the stored procedures and executed them. Successfully but it's still not storing data based on users logins.
Also SMC will return a failed error because it's not finding logs.
My Log_Db is very small with only a few tables.
_LogCashItem
_LogEventChar
_LogEventItem
_LogEventSiegeFortress
_LogSchedule
_LogServerEvent
That's it ...
Also ... SMC -> User_Log -> ServiceManager -> LoginLogout = SMC Logs for Login / Logout Statistics.
I'm trying to find the last known connected IP for each account. Which that is in the UserControl. But I don't think there's any logs created for it. As I said above, the tables and procedures that would store that info isn't working right.