Announcement

Collapse
No announcement yet.

Audit logons

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Audit logons

    Hi all

    We would like to be able to audit logons of our students without having to go through the event logs of both our Domain Controllers. What is the best way of doing this? I have tried using a script to run at logon thats adds the info needed to a database but when two people log on at the same time one gets locked out of the database and it fails.

    Is there an alternative or a way to solve this?

    Thanks
    Server 2000 MCP
    Development: ASP, ASP.Net, PHP, VB, VB.Net, MySQL, MSSQL - Check out my blog http://tonyyeb.blogspot.com

    ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

  • #2
    Easy way to do it is to just append to a text file, then you'll never get locked out.

    If you want to keep it more simple from an admin point of view then append each logon to an individual text file for each user

    ECHO User Logged on %DATE% @ %TIME% >> \\server\share\%username%.txt

    Then you'll end up with a share with text files detailing time and date for each logon for each user.

    Chris
    * Shamelessly mentioning "Don't forget to add reputation!"

    Comment


    • #3
      Thanks for the reply Chris but a text file inst very good for compiling reports from, querying etc... I want to use ASP to make a nice front end for this data so that it can create graphs on the fly etc.. Plus a query function to find where a user is logged on now etc...

      EDIT: i suppose i could make it comma seperated and then use a script that compiles the info into a database which could be queryed?
      Server 2000 MCP
      Development: ASP, ASP.Net, PHP, VB, VB.Net, MySQL, MSSQL - Check out my blog http://tonyyeb.blogspot.com

      ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

      Comment


      • #4
        Yea I suppose that would do the trick, easy to make a csv file just output your echo with comma's !

        echo %username%,%computername%,%date%,%time% >> output.csv

        Job Done,
        * Shamelessly mentioning "Don't forget to add reputation!"

        Comment


        • #5
          Right then i'll have a pop at this and hopefully if it is anywhere near what i want it to be then ill post my script(s).

          Now i just need to set the security so that users are able to write their logon data but not read the file written!
          Server 2000 MCP
          Development: ASP, ASP.Net, PHP, VB, VB.Net, MySQL, MSSQL - Check out my blog http://tonyyeb.blogspot.com

          ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

          Comment


          • #6
            This is great. Are you planning on running it through AD in a script through the Logon and Logoff properties? I have managers that want me to keep tract on when a user logs on and off their computer. They charge hourly to clients and want to verify timesheets to actual computer time.

            Comment


            • #7
              Yes it runs in a login script. Works quite well but we are looking at other products as reporting is a bit of a pain and i cant be bothered to do it properley.
              Server 2000 MCP
              Development: ASP, ASP.Net, PHP, VB, VB.Net, MySQL, MSSQL - Check out my blog http://tonyyeb.blogspot.com

              ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

              Comment


              • #8
                Tonyyep

                please keep this topic in your mind as you make these changes and experiment with other products. I would love to know what you end up with and how it works. I have requests all the time for reports on log ons and log offs per computers...

                Take care..

                Comment


                • #9
                  No problem. Will do.
                  Server 2000 MCP
                  Development: ASP, ASP.Net, PHP, VB, VB.Net, MySQL, MSSQL - Check out my blog http://tonyyeb.blogspot.com

                  ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

                  Comment


                  • #10
                    If you have an Oracle database you can create an external table that uses your csv file as its source. this way a SQL report will always have up to date data. Although I think that I would just log this information directly to oracle.

                    Comment

                    Working...
                    X