User Login Hist truncation



  • Server
    • FOG Version: 120
    • OS: Ubuntu 10.04
    Description

    Hi all, was just wondering is there a way to truncate the user login hist table, I’m not the best with mysql and it has grown considerably due to the size of the company so rather than upping max mem in php.ini thought I would have a clean up :)

    Just in the process of building a new environment but wanted to undertake this to allow some of the support guys to use the user history to identify what machines they are using.

    As always thanks in advance,
    Robbie



  • Hi Wayne,

    Fantastic thank you just what I needed :)

    Cheers
    Robbie



  • First, you can get into FOG’s db via CLI with:
    mysql -D fog
    and leave with:
    quit

    I think it’s stored in the userTracking table. You should check with:
    select * from userTracking;

    If that’s the one, you can truncate it with:
    truncate table userTracking;

    Some other commands that may help you in the future are:
    You can get a listing of tables with:
    show tables;

    and you can get a description of a table with:
    describe userTracking;


 

456
Online

41.8k
Users

12.4k
Topics

116.6k
Posts