Forum GLPI-Project

goddamnday

Member

Registered: 2023-10-09

Posts: 2

SQL query to get Serial Number of operating system

hi,

please I need the query in SQL to get the list of computers OS Serial number with associate computer's name (windows cd keys).

thank you

( i tried

select glpi_items_operatingsystems.serial, glpi_computers.name from glpi_items_operatingsystems, glpi_computers where glpi_items_operatingsystems.items_id=glpi_computers.id;

but don't work )

Last edited by goddamnday (2023-10-09 17:48:20)

goddamnday

Member

Registered: 2023-10-09

Posts: 2

Re: SQL query to get Serial Number of operating system

i just found the solution :
select glpi_items_operatingsystems.license_number, glpi_computers.name from glpi_items_operatingsystems, glpi_computers where glpi_items_operatingsystems.items_id=glpi_computers.id;

edit : added with the version of operating system

SELECT io.license_number, c.name, ov.name AS windows_version FROM glpi_items_operatingsystems AS io INNER JOIN glpi_computers AS c ON io.items_id = c.id LEFT JOIN glpi_operatingsystemversions AS ov ON io.operatingsystemversions_id = ov.id;

Last edited by goddamnday (2023-10-11 14:31:21)