Clear Primary User and Other Tag Fields

[Scott B]

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]

@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.

[Scott B]

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