Forum GLPI-Project

sIBajHYG

Member

From: Mission [KS]

Registered: 2023-08-18

Posts: 75

[SOLVED] Search for renamed PCs by Name

Please tell me if there is a quick way to somehow search for old PC names in all logs at once?
For example. The PC was renamed a long time ago. I only know the old name.. Now I have to look for the serial number for a long time. Then look for the current PC using the serial number. I find the PC and check its logs - and already there I find confirmation that the PC has been renamed.

Last edited by sIBajHYG (2023-12-13 23:01:57)

---

Linux ubuntu-22.04.2-live-server-amd64, PHP 8.1.2, Apache 2.4.52, MariaDB 10.6.12, GLPI 10.0.15.
GLPI Inventory 1.3.5, PHP SAML 1.3.0,  Oauth IMAP 1.4.3, Additional Fields, 1.21.8,Ticket Cleaner.

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,813

Website

Re: [SOLVED] Search for renamed PCs by Name

The only way currently is directly through the database.

SELECT * FROM glpi_logs WHERE itemtype="Computer" AND id_search_option=6 AND old_value="OLD_NAME";

The items_id field will have the ID of the computer. The new_value field will show you the new name that was set during that particular update.

---

GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.

sIBajHYG

Member

From: Mission [KS]

Registered: 2023-08-18

Posts: 75

Re: [SOLVED] Search for renamed PCs by Name

database

Yeah... I thought about that too... phpMyAdmin is already configured... Thanks!

---

Linux ubuntu-22.04.2-live-server-amd64, PHP 8.1.2, Apache 2.4.52, MariaDB 10.6.12, GLPI 10.0.15.
GLPI Inventory 1.3.5, PHP SAML 1.3.0,  Oauth IMAP 1.4.3, Additional Fields, 1.21.8,Ticket Cleaner.