Windows 11 | 65x HP Z2 Tower G1i | UPDATE -

[kratkale]

@Tom-Elliott
Today again the Serial numbers of the nvme are lost in the FOG Database - I don’t know why …
Thats why I again cloned the file system to the wrong nvme

[kratkale]

@Tom-Elliott
to make a backup I use now sql in bash

root@fog:~# mysql -u root -N -B -e “USE fog; SELECT CONCAT(‘UPDATE hosts SET hostDevice = ‘’’, hostDevice, ‘’’ WHERE hostID = ', hostID, ‘;’)FROM hosts;” > restore_hostdevice.sql

and restore with
root@fog:~# mysql -u root fog < restore_hostdevice.sql

[kratkale]

@Tom-Elliott
Again Serial Numbers lost: checking with:

mysql -u root fog -e “SELECT hostName FROM hosts WHERE hostDevice IS NULL OR hostDevice = ‘’;”

root@fog:~/NVME_Problem# ./anzeigen
±---------+
| hostName |
±---------+
| PC116CAD |
| PC118CAD |
| PC121CAD |
| PC110CAD |
| PC112CAD |
| PC034CAD |
| PC026CAD |
| PC015CAD |
| PC016CAD |
| pc101cad |
| pc008cad |
±---------+
root@fog:~/NVME_Problem#

I’ve no idea what happend.

[Tom Elliott]

@kratkale I’m confused what you mean their serial numbers are erased?

FOG isn’t overwriting the serial numbers on these devices.

Furthermore, Serial numbers aren’t stored directly on the host, they’re stored on the inventory table.

That column (hostDevice) is about storing what device a host will be using to image against.

If somebody is updating the group, the empty hostDevice (Group device for groups) would likely be overwriting it.

I’ve pushed a code change to hopefully address this particular issue in the latest dev-branch.

[kratkale]

@Tom-Elliott
I need the Serial Number of the nvme to clone to the correct device. (2 nvme in every PC)
As I had problems I now use the following command to check if all Serial Numbers are available:
mysql -u root fog -e “SELECT hostName FROM hosts WHERE hostDevice IS NULL OR hostDevice = ‘’;”
Yesterday finally (see previous post) there was no number missing - now one is missing again:
±---------+
| hostName |
±---------+
| PC002CAD |
±---------+
As I can also see it in the host general:

There was no interaction between yesterday and today on the web interface … Fog an the PC’s where on their own … Booting in the morning …
now I replace it again with:
UPDATE hosts SET hostDevice = ‘BNE7N774910207S3G’ WHERE hostID = 61;

So some update

[kratkale]

@Tom-Elliott
in the inventorry table mostly the other (for me wrong - secondarry Data) nvme is stored
Here are also some without an IHdserial
mysql -u root fog -e “SELECT iCASEserial FROM inventory WHERE iHdserial IS NULL OR iHdserial = ‘’;”
root@fog:~/NVME_Problem/inventory# ./anzeigen
±------------+
| iCASEserial |
±------------+
| CZC5477HVZ |
| CZC5477HT0 |
| CZC5477HTK |
| CZC5477JMZ |
±------------+
The Host now lost the Serial Number is the CZC5477HSX
CZC5477HSX
WDGreenSN350250GB2G0C
236050WD
260227800933
so in the inventory table the Data Disk is stored

[kratkale]

@Tom-Elliott
Your version of FOG is up to date. You’re running the latest stable version: 1.5.10.1826

[Tom Elliott]

@kratkale Install using dev-branch

[kratkale]

@Tom-Elliott
fyi:
again no interaction with the web interface - today another PC lost the hostDevice.
root@fog:~/NVME_Problem/hostDevice# ./anzeigen
±---------+
| hostName |
±---------+
| PC102CAD |
±---------+

Yesterday it was PC002CAD today PC102CAD.

@Tom-Elliott said in Windows 11 | 65x HP Z2 Tower G1i | UPDATE -:

dev-branch

ok
Your version of FOG is up to date.
You’re running the latest dev-branch version: 1.5.10.1858

[kratkale]

@Tom-Elliott
since yesterday no devices lost