In our organization we are starting some sort of 're-inventariation' of
all the material, re-labelling that.
We need the info if a devices (monitor, printer, peripheral) was
'orphan', eg not connected to some PC.
We have solved with some query like:
select * from glpi_monitors where id not in (select end1 from
glpi_connect_wire where type=4) and deleted='N' and is_template=0;
but i think that this information will be better suited by a report,
that can also signal devices connected to a deleted item.
--
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/
Polo FVG - Via della Bontà , 7 - 33078 - San Vito al Tagliamento (PN)
marco.gaiarin(at)sv.lnf.it tel +39-0434-842711 fax +39-0434-842797
_______________________________________________
Glpi-dev mailing list
[email protected]
https://mail.gna.org/listinfo/glpi-dev
