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?


  • Senior 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.



  • @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!


  • Senior 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
 

282
Online

7.4k
Users

14.5k
Topics

136.5k
Posts