Forum GLPI-Project

Srubinsky

Member

Registered: 2025-03-07

Posts: 2

Obtaining asset history from database (glpi_logs table)

Hello,

I want to get the asset history from the "historical" tab for all asset types.
In the "historical" tab, the "field" value is visible. How can I get this information from the database? I can see the id_search_option field in the database (table glpi_logs), but I am unable to find the relationship between the tables.

`id_search_option` int(11) NOT NULL DEFAULT 0 COMMENT 'see search.constant.php for value', - there is no such file

I am looking in PHP files for a way this field is built, but I am unable to do so. Can I ask for help?

Kind regards

cconard96

Moderator

Registered: 2018-07-31

Posts: 3,268

Website

Re: Obtaining asset history from database (glpi_logs table)

This data is not intended to be readable in any way except in the Historical tabs.
id_search_option refers to the internal IDs used by the Search engine in GLPI. There hasn't been a single file for these in over 14 years.

---

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.

Srubinsky

Member

Registered: 2025-03-07

Posts: 2

Re: Obtaining asset history from database (glpi_logs table)

Thank you very much @cconard96
Is there a chance to obtain this data one way or another?
Do i need to use PHP and GLPI Search Engine to get info from column "Field"?
Right now i have all other info from "Historical" tab from DB fo all of my assets, I just need to add column "Field".