Forum GLPI-Project

johisariias

Member

Registered: 2008-06-12

Posts: 2

Managing historic data

Hello, I'm trying to create an application based on the database from glpi but now my problem is that I can`t know what kind on change has been done over the computer, I´m using the table glpi_history, there are fields like old_value and new_value containing the detail of the change but there is a field "link action" that I think that could contain the descripcion of the action, for example "Adding of a component", "Remove of a component", etc. I think that the field link action has a relation with another table but I can´t find which one. Please help me it´s very important.

The same thing is happening with the field device_type in the table glpi_computer_device, I don´t understand how to know to which table to look in, for example device_type has a 4 and I discovered that the 4 represents the table glpi_device_hdd. But I can´t discover any other table.

I´m sorry my English is not very good, I´m from Ecuador.
Help me please as soon as posible.

thanks

remi

GLPI-DEV

From: Champagne

Registered: 2007-04-28

Posts: 7,127

Website

Re: Managing historic data

For device_type, see define.php

++

---

Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

johisariias

Member

Registered: 2008-06-12

Posts: 2

Re: Managing historic data

Thank you very much I checked device_type and I think It would be very useful. Please could you help me with another problem, I can´t find the monitor of the computer, in which table can I find it and what field is the key for the relationship with the table glpi_computers.
Please help me