Forum GLPI-Project

alvaroarb

Member

From: Colombia

Registered: 2007-08-29

Posts: 7

glpi_inst_software table

Good Evening
i'm in need to extract some info directly from the database, specifically the software installed on every machine, i know the table glpi_computers will tell me the ID of every computer and the table glpi_software will tell me the ID of every software, now the relationship between this two tables (what computer has what software) seems to be table glpi_inst_software, is this right? if so what is the meaning of the fields? i ask this beacuse i've tried manually to locate the id of a specific computer with a specific software ID and can't find it, am i looking in the wrong place?
Thanks

---

You? ... Yes, me ... me, me, me ... me too !

JMD

GLPI - Lead

Registered: 2004-09-13

Posts: 9,180

Website

Re: glpi_inst_software table

Put GLPI in debug mode and have a look on the request sql  that glpi done in search to have good examples

---

JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

remi

GLPI-DEV

From: Champagne

Registered: 2007-04-28

Posts: 7,127

Website

Re: glpi_inst_software table

In 0.71 : inst_software is a link between a computer and a license
In 0.72 : inst_software is a link between a computer and a softwareversion

++

---

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/