inject windows key for more than hundred machines

[lebrun78]

Hello,
I have imagine contrat licence and I have a licence key for each machine.
Could I inject via mysql the license keys list a text file.
I have a look on the hosts tables, I didn’t see a column licence key.

[Wayne Workman]

@lebrun78 It’s called hostProductKey in the hosts table. Also, instead of doing this via MySQL - just export all your hosts - modify the export - and then reimport. Web Interface -> Host Management -> Export Hosts -> Export. Make a backup copy of this, modify it with the key, and then re-import.

Tom Elliott posted recently on the arrangement of the import file… let me find that…
https://forums.fogproject.org/topic/9790/headers-for-csv-files-for-hosts-and-images-import/2

If you are unsure which field the product key should go into in the import, just put the product key into one host via the web interface manually, export again, find that host and see how the key is laid out.

[lebrun78]

I’ve tried the export, but I didn’t get any field containing ProductKey

Host ID, Host Name, Host Desc, Host MAC, Host Created, Image ID, Image Name, Image Desc ,AD Join, AD OU, AD Domain, Kernel, HD Device, OS Name

If I Export, modify and then import, how are treated duplications ?

[Wayne Workman]

@lebrun78 Well before we go that far, we should ask @Tom-Elliott why the product keys are not exported. It may be that they were simply over-looked. Tom is basically a one-man show for the fog 1.x backend.

[Tom Elliott]

@Wayne-Workman The product key’s are exported for hosts.

Remember, we store the product key in encrypted form. My guess is the output is in encrypted form.

You just have to find which field/column it’s under.

[Wayne Workman]

@Tom-Elliott Can the export be un-encrypted ? And can imports take an un-encrypted form and encrypt them?

Other systems are not going to export fields in the encrypted manner that FOG uses, and other systems won’t accept the encrypted fields that fog uses.

Also - this should be a scenario that prompts for re-auth.

[Tom Elliott]

@Wayne-Workman The export will not be un-encrypted, for now, but the import CAN take unencrypted form.