Clear Primary User and Other Tag Fields



  • What would be the easiest way to blank out the fields for Primary User, Other Tag #1, and Other Tag #2 under the inventory tab for every host in FOG?



  • @Sebastian-Roth said in Clear Primary User and Other Tag Fields:

    actually clear those fields for ALL your hosts! If you don’t have a backup, there is no way back after running tho

    Perfect, exactly what I needed. Thank you!


  • Developer

    @Scott-B Probably best if you know your way around the mysql command line:

    shell> mysql -u root -p
    Password:
    ...
    mysql> use fog;
    ...
    mysql> UPDATE inventory SET iPrimaryUser='';
    ...
    mysql> UPDATE inventory SET iOtherTag='';
    ...
    mysql> UPDATE inventory SET iOtherTag1='';
    ...
    mysql> quit
    

    Notice: Be aware that those commands actually clear those fields for ALL your hosts! If you don’t have a backup, there is no way back after running those.


Log in to reply
 

481
Online

5.9k
Users

13.2k
Topics

124.1k
Posts