@Sebastian-Roth
25 an 36 PC in Multicast

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

@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

@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

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

@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

@vanfifty1
I have some simelar Problems maby read the post
https://forums.fogproject.org/topic/18157/windows-11-65x-hp-z2-tower-g1i-update/2
My problem is/was that Fog uses sometimes the wrong nvme …

@Tom-Elliott
Here’s something else funny—the serial numbers aren’t unique! I have a duplicate…
Two differnt PC’s CAD009 and CAD023

@Tom-Elliott
Tom Thank you for your great support.

@Tom-Elliott
I can confirm, that it works to insert the serial number in Host Management | Host gernal | Host Primary Disk. You can take the value you get from booting with a clonzilla stick (Switch to the second console) and use lsblk -pdno SERIAL,SIZE


I did a test and used the wrong number in Host Primary Disk and start to clone:

So it seems to work.