Logging ip,user,mac add of comp | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Logging ip,user,mac add of comp

Is any one have any script or any tool which will log the following info and write to a text file inside the db folder for a particular database
ip from where request has been made
mac add of that ip
username Here is the scnerio of my db.I have 100z of DB each with one login and one user such that loginname=username.All dbs have therir individual folder say for db 1 I hv D:SQLDatadb1 ;for db2 I hv D:SQLDatadb2 and so on till db100.
Now I have a log folder inside each db folder which will keep a log file for Requested ip,user,login,mac add of the ip
Any kind of help in this will be highly appreciated
Network Monitor gives administrators the ability to watch packets and in this you can capture the required information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi aaronsandy,<br />for that you can set performance counter of Performance Monitor (a tool shipped with MS Windows OS / Administrative Tool) <br />BTW <br />master..sysprocesses table having a field ‘net_address’ that contains MAC ADDRESS of the System and another field , nt_username contains NT USERNAME,hostname field contains name of the client system’s NETBIOS name, and if you want to store ‘sql username’ then you have to use system_user to store the same .<br /><br />HTH<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />][<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]<br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />
You could work something out by modifying this:
http://www.sql-server-performance.c…HIVE=true&TOPIC_ID=298&SearchTerms=netaddress
]]>