For SQL Server 2005 gurus
Hi Skunksters, I need help. I have a table that has a list of all created users of a certain system. Other fields in the table are whether or not the user is logged in, the name of the computer that he is logged on to and the time that he logged in and out. The problem is that if some user XYZ logs in at 9 AM and logs out at 9:15 AM, then later on logs in at 12 noon and logs out at 1 PM, the initial record that he had logged in between 9 and 9:15 is erased. My question is: Is there a way that I can tell from the logs, perhaps or elsewhere what the record contained before it was overwritten? Me.
As you await your answer, try asking this at http://stackoverflow.com
Dude Normalize the table.. On Wed, Nov 24, 2010 at 4:09 PM, Simon Mbuthia <simon.mbuthia@gmail.com>wrote:
Hi Skunksters,
I need help. I have a table that has a list of all created users of a certain system. Other fields in the table are whether or not the user is logged in, the name of the computer that he is logged on to and the time that he logged in and out. The problem is that if some user XYZ logs in at 9 AM and logs out at 9:15 AM, then later on logs in at 12 noon and logs out at 1 PM, the initial record that he had logged in between 9 and 9:15 is erased.
My question is: Is there a way that I can tell from the logs, perhaps or elsewhere what the record contained before it was overwritten?
Me.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards, Kamiru Mwangi, 0721792419 Skype: samuel.kamiru
Thanks Kamiru, but that'll only help me avoid the problem in future. I'm looking to see whether I can get the info from logs. On 24 November 2010 17:22, Kamiru Mwangi Samuel <samuel.kamiru@gmail.com>wrote:
Dude Normalize the table..
On Wed, Nov 24, 2010 at 4:09 PM, Simon Mbuthia <simon.mbuthia@gmail.com>wrote:
Hi Skunksters,
I need help. I have a table that has a list of all created users of a certain system. Other fields in the table are whether or not the user is logged in, the name of the computer that he is logged on to and the time that he logged in and out. The problem is that if some user XYZ logs in at 9 AM and logs out at 9:15 AM, then later on logs in at 12 noon and logs out at 1 PM, the initial record that he had logged in between 9 and 9:15 is erased.
My question is: Is there a way that I can tell from the logs, perhaps or elsewhere what the record contained before it was overwritten?
Me.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards,
Kamiru Mwangi,
0721792419 Skype: samuel.kamiru
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
Hello Simon Mbuthia, It's simple.. I did it in MySQL, just have a different table that inserts a new record when a user logs in to the system. As for the log outs...if you can..try to update the time-stamp of the user on log out..that is: you update the very record of the user's last login....doing this..in your application..you can have a variable that stores the time the user logins..then use that variable with the user name to update the last user's login with the now obtained log out time..... You may mail me in 'camera' if you need further clarification. On Wed, Nov 24, 2010 at 5:32 PM, Simon Mbuthia <simon.mbuthia@gmail.com>wrote:
Thanks Kamiru, but that'll only help me avoid the problem in future. I'm looking to see whether I can get the info from logs.
On 24 November 2010 17:22, Kamiru Mwangi Samuel <samuel.kamiru@gmail.com>wrote:
Dude Normalize the table..
On Wed, Nov 24, 2010 at 4:09 PM, Simon Mbuthia <simon.mbuthia@gmail.com>wrote:
Hi Skunksters,
I need help. I have a table that has a list of all created users of a certain system. Other fields in the table are whether or not the user is logged in, the name of the computer that he is logged on to and the time that he logged in and out. The problem is that if some user XYZ logs in at 9 AM and logs out at 9:15 AM, then later on logs in at 12 noon and logs out at 1 PM, the initial record that he had logged in between 9 and 9:15 is erased.
My question is: Is there a way that I can tell from the logs, perhaps or elsewhere what the record contained before it was overwritten?
Me.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards,
Kamiru Mwangi,
0721792419 Skype: samuel.kamiru
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards, Adams John Opiyo.
You can't do that on retrospect. But going forward if you have legacy issues to keep you from doing it properly, what you can do is create a table to store login and logout times and then add a trigger to the original table to insert this data On Wed, Nov 24, 2010 at 4:09 PM, Simon Mbuthia <simon.mbuthia@gmail.com>wrote:
Hi Skunksters,
I need help. I have a table that has a list of all created users of a certain system. Other fields in the table are whether or not the user is logged in, the name of the computer that he is logged on to and the time that he logged in and out. The problem is that if some user XYZ logs in at 9 AM and logs out at 9:15 AM, then later on logs in at 12 noon and logs out at 1 PM, the initial record that he had logged in between 9 and 9:15 is erased.
My question is: Is there a way that I can tell from the logs, perhaps or elsewhere what the record contained before it was overwritten?
Me.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
participants (5)
-
Dennis Kioko -
John Adams -
Kamiru Mwangi Samuel -
Rad! -
Simon Mbuthia