Forum GLPI-Project

victor.diana

Member

Registered: 2016-04-22

Posts: 3

Dernier inventaire

Bonjour,

Je souhaiterais savoir la table dans la BD qui contient les données du "dernier inventaire", afin de la récupérer.
Un listing complet m'est demandé et savoir les dates m'est indispensable pour un travail bien fait.

Cordialement

victor.diana

Member

Registered: 2016-04-22

Posts: 3

Re: Dernier inventaire

UP ↕

btw voici mon sql pour la requête,

SELECT DISTINCT g_c.name AS nom_ordinateur,g_c.contact AS login, g_s.name AS nom_logiciel, g_pfa.last_contact AS dernier_inventaire
FROM glpi_computers g_c, glpi_softwares g_s, glpi_softwareversions g_sv, glpi_computers_softwareversions g_csv, glpi_plugin_fusioninventory_agents g_pfa

WHERE g_s.id = g_sv.softwares_id
AND g_sv.id = g_csv.softwareversions_id
AND g_csv.computers_id = g_c.id
AND g_pfa.id = g_pfa.last_contact

AND(

g_s.name LIKE "ABBYY%"

    OR
g_s.name LIKE "ACDSee Pro%"

    OR
g_s.name LIKE "Acoubat Sound%"

    OR
g_s.name LIKE "Adobe Acrobat X%"

OR
g_s.name LIKE "Adobe Acrobat X Pro%"

OR
g_s.name LIKE "Acrobat X Suite"

OR
g_s.name LIKE "Acrobat_Pro_9.0.0"

OR
g_s.name LIKE "Adobe Acrobat Reader%"

    OR
g_s.name LIKE "Adobe Creative Suite%"

    OR
g_s.name LIKE "Adobe Dreamweaver C%"

    OR
g_s.name LIKE "Adobe Fireworks CS5"

    OR
g_s.name LIKE "Adobe Illustrator%"

    OR
g_s.name LIKE "Adobe InDesign CS4"

OR
g_s.name LIKE "Adobe InDesign CS5"

OR
g_s.name LIKE "Adobe InDesign CC 2015 (32-bit)"

    OR
g_s.name LIKE "Adobe Lightroom"

    OR
g_s.name LIKE "Adobe Photoshop CS%"

OR
g_s.name LIKE "Adobe Photoshop CC 2015"

OR
g_s.name LIKE "Adobe Photoshop Elements 1%"

    OR
g_s.name LIKE "Adobe Premiere Elements 10"

    OR
g_s.name LIKE "AIMSUN%"

    OR
g_s.name LIKE "Antidote 8"

    OR
g_s.name LIKE "Any PDF to DWG Converter 2010"

    OR
g_s.name LIKE "AnyLogic%"

    OR
g_s.name LIKE "ArcGIS Explorer%"

OR
g_s.name LIKE "ArcGIS Pro"

OR
g_s.name LIKE "ArcGIS Diagrammer"

OR
g_s.name LIKE "ArcGIS ArcReader 10"

OR
g_s.name LIKE "ArcGIS 9.3 - Version française"

    OR
g_s.name LIKE "ArcGIS 10.2 for Desktop"

OR
g_s.name LIKE "ArcGIS 10.1 for Desktop"

OR
g_s.name LIKE "ArcGIS 10.3.1 for Desktop"

OR
g_s.name LIKE "ArcGIS 10.1 Engine"

OR
g_s.name LIKE "ArcGIS Engine Runtime"

OR
g_s.name LIKE "ArcGIS 10.3 Engine"

    OR
g_s.name LIKE "Artlantis%"

    OR
g_s.name LIKE "AutoCAD LT 2013 – Français (French)"

OR
g_s.name LIKE "AutoCAD 2012 - French"

OR   
g_s.name LIKE "AutoCAD 2004"

OR   
g_s.name LIKE "AutoCAD 2008 - Français"

OR   
g_s.name LIKE "AutoCAD 2010 - Français"

OR   
g_s.name LIKE "AutoCAD 2011 - Français"

OR   
g_s.name LIKE "%VBA Enabler"

OR   
g_s.name LIKE "AutoCAD 2013 – Français (French)"

OR   
g_s.name LIKE "AutoCAD 2014 - Français (French)"

OR   
g_s.name LIKE "AutoCAD 2015 - Français (French)"

OR   
g_s.name LIKE "AutoCAD 2016"

OR   
g_s.name LIKE "AutoCAD 2017"

OR   
g_s.name LIKE "Autodesk AutoCAD 2014 - Français (French)"

OR   
g_s.name LIKE "Autodesk AutoCAD 2015 - Français (French)"

OR   
g_s.name LIKE "Autodesk AutoCAD 2017 - Français (French)"

    OR   
g_s.name LIKE "AutoCAD Map 3D 2013"

OR   
g_s.name LIKE "AutoCAD Map 3D 2012"

    OR
g_s.name LIKE "AutoCAD Civil 3D 2011 - Français (French)"

OR
g_s.name LIKE "AutoCAD Civil 3D 2011 PISTE"

OR
g_s.name LIKE "AutoCAD Civil 3D 2013 - Français (French)"

OR
g_s.name LIKE "Autodesk AutoCAD Civil 3D 2015 - French"

OR
g_s.name LIKE "Autodesk AutoCAD Civil 3D 2015 - Français (French)"

OR
g_s.name LIKE "Autodesk AutoCAD Civil 3D 2016"

OR
g_s.name LIKE "Autodesk AutoCAD Civil 3D 2016 - Français (French)"

OR
g_s.name LIKE "Autodesk AutoCAD Civil 3D 2015"

OR
g_s.name LIKE "Autodesk AutoCAD Civil 3D 2015 - English"

    OR   
g_s.name LIKE "GeoMacao v8 - 2004 Edition"

    OR
g_s.name LIKE "Bentley MX V8 XM Edition"

OR
g_s.name LIKE "Bentley MX V8i (SELECTseries 2) 08.11.07.566"

OR
g_s.name LIKE "Bentley MX V8i (SELECTseries 2) 08.11.07.496"

OR
g_s.name LIKE "Bentley MicroStation (V 08.05.02.70) - 1"

    OR
g_s.name LIKE "Mensura genius 6.0"

OR
g_s.name LIKE "Mensura genius 7.0"
   
OR
g_s.name LIKE "Mensura genius 8.0"

    OR
g_s.name LIKE "COVADIS x64"

OR
g_s.name LIKE "COVADIS"

    OR
g_s.name LIKE "MicroStation V8i (SELECTseries 2) 08.11.07.446"

    OR
g_s.name LIKE "MapInfo Professional%"

OR
g_s.name LIKE "MapInfo"

OR
g_s.name LIKE "MapInfo Professional 8.0"

OR
g_s.name LIKE "MapInfo Professional 11.0"

OR
g_s.name LIKE "MapInfo Professional 10.0"

OR
g_s.name LIKE "MapInfo Professional 10.5"

    OR
g_s.name LIKE "Alize-lcpc"

OR
g_s.name LIKE "Alize-Lcpc Routes V1.4"

    OR
g_s.name LIKE "Talren97"

OR
g_s.name LIKE "TALREN 4"

OR
g_s.name LIKE "Talren v5"

    OR
g_s.name LIKE "Giration"

    OR
g_s.name LIKE "Girabase"

    OR
g_s.name LIKE "Signal"

    OR
g_s.name LIKE "Cadnaa%"

    OR
g_s.name LIKE "CAD-Earth (AutoCAD 2013-2014)"

    OR
g_s.name LIKE "Mithra%"

    OR
g_s.name LIKE "PathPlanner Airside+ 6.05/6.006-"

OR
g_s.name LIKE "PathPlanner A5%"

    OR
g_s.name LIKE "Canal_9"

    OR
g_s.name LIKE "Cube Voyager"

    OR
g_s.name LIKE "Cube 6.4.0"

    OR
g_s.name LIKE "SPSS pour Windows 10.0"

    OR
g_s.name LIKE "TransCAD 4.8 (Full)"

OR
g_s.name LIKE "TransCAD 5.0 (Full)"

OR
g_s.name LIKE "TransCAD 6.0%"

OR
g_s.name LIKE "TransCAD 7.0%"

    OR
g_s.name LIKE "Novapoint VDC Explorer"

OR
g_s.name LIKE "Novapoint Viewer - Beta"

    OR
g_s.name LIKE "anylogic%"

    OR
g_s.name LIKE "Microsoft Office project%"

    OR
g_s.name LIKE "Microsoft Office Project Professional 2003"

OR
g_s.name LIKE "Microsoft Office Project Standard 2007"

OR
g_s.name LIKE "Microsoft Office Project Standard 2010"

    OR
g_s.name LIKE "foxta%"

    OR
g_s.name LIKE "DAVISUM 8.1 (813005)"

    OR
g_s.name LIKE "ER Mapper%"

    OR
g_s.name LIKE "ER Viewer%"

    OR
g_s.name LIKE "AutoTurn%"

    OR
g_s.name LIKE "Paint Shop Pro%"

    OR
g_s.name LIKE "CorelDRAW Home & Student Suite X6"
OR
g_s.name LIKE "CorelDRAW Graphics Suite X3"
OR
g_s.name LIKE "CorelDRAW Graphics Suite X6 - Setup Files (x64)"

    OR
g_s.name LIKE "dBBati"
OR
g_s.name LIKE "dBInside"
OR
g_s.name LIKE "dBSolo-B"
OR
g_s.name LIKE "dBTrait"

    OR
g_s.name LIKE "DraftSight%"

    OR
g_s.name LIKE "Dragon NaturallySpeaking 10"

    OR
g_s.name LIKE "Nuance Omnipage 18"

OR
g_s.name LIKE "ScanSoft Omnipage 15.0"

OR
g_s.name LIKE "Nuance Omnipage Ultimate"

    OR
g_s.name LIKE "FARO LS 1.1.406.58"

OR
g_s.name LIKE "FARO LS 1.1.501.0 (64bit)"

    OR
g_s.name LIKE "FileZilla Client%"

    OR
g_s.name LIKE "GIMP%"

    OR
g_s.name LIKE "Google Earth Pro"

OR
g_s.name LIKE "Google Earth"

OR
g_s.name LIKE "Google Sketchup 8"

OR
g_s.name LIKE "Google Sketchup Pro 8"

    OR
g_s.name LIKE "HEC-HMS 3.5"
OR
g_s.name LIKE "HEC-RAS%"

    OR
g_s.name LIKE "HY-8.7%"

    OR
g_s.name LIKE "I.R.I.S OCR"

    OR
g_s.name LIKE "IBM SPSS Statistics%"

    OR
g_s.name LIKE "PASW Statistics 18"

    OR
g_s.name LIKE "Kaspersky Anti-Virus"

OR
g_s.name LIKE "Kaspersky Endpoint Security 10 for Windows"

    OR
g_s.name LIKE "Kolor Autopano Pro 3.0"

    OR
g_s.name LIKE "LibreOffice 5.0.3.2"

    OR
g_s.name LIKE "MATLAB Compiler Runtime 8.0 (32-bit)"

    OR
g_s.name LIKE "MATLAB Component Runtime"

    OR
g_s.name LIKE "Micrografx PhotoMagic 6"

OR
g_s.name LIKE "Micrografx Windows Draw 6"

    OR
g_s.name LIKE "Microsoft Access%"

    OR
g_s.name LIKE "Microsoft Lync Basic 2013"

OR
g_s.name LIKE "Microsoft LyncEntry 2013"

OR
g_s.name LIKE "Microsoft Lync 2010 Attendee"

OR
g_s.name LIKE "Microsoft Lync 2013"

    OR
g_s.name LIKE "Microsoft Office Word%"

OR
g_s.name LIKE "Microsoft Office Excel%"

OR
g_s.name LIKE "Microsoft Office Powerpoint%"

OR
g_s.name LIKE "Microsoft Office Project Standard 2010"

OR
g_s.name LIKE "Microsoft Office Project Standard 2007"

    OR
g_s.name LIKE "Mozilla Thunderbird%"

    OR
g_s.name LIKE "MUR%"

    OR
g_s.name LIKE "NICI (64 bit)"

    OR
g_s.name LIKE "Skype™%"

OR
g_s.name LIKE "Skype Entreprise Basic 2016 - fr-fr"

    OR
g_s.name LIKE "OducV6.1"

    OR
g_s.name LIKE "OpenOffice%"

    OR
g_s.name LIKE "PDFSam%"

    OR
g_s.name LIKE "PhotoShowExpress"

OR
g_s.name LIKE "Plex.Earth Tools%"

    OR
g_s.name LIKE "PROMT Professional 10 English Multilingual"

OR
g_s.name LIKE "PROMT Professional 9.5 French Giant"

    OR
g_s.name LIKE "VISSIM 5.40-12 32 Bit"

    OR
g_s.name LIKE "PTV Visum%"

    OR
g_s.name LIKE "VISUM%"

    OR
g_s.name LIKE "QGIS Brighton%"
OR
g_s.name LIKE "QGIS Wien%"
OR
g_s.name LIKE "QGIS Chugiak 2.4.0 Chugiak"
OR
g_s.name LIKE "QGIS Dufour 2.0.1 Dufour"
OR
g_s.name LIKE "QGIS Essen 2.14.1 Essen"
OR
g_s.name LIKE "QGIS Lyon%"
OR
g_s.name LIKE "QGIS Pisa 2.10.1 Pisa"
OR
g_s.name LIKE "QGIS Valmiera 2.2.0 Valmiera"

    OR
g_s.name LIKE "Rhinoceros 5"

    OR
g_s.name LIKE "ScanSoft Omnipage 15.0"

    OR
g_s.name LIKE "Transmodeler%"

    OR
g_s.name LIKE "SI TSS"

    OR
g_s.name LIKE "TORUS 4"

    OR
g_s.name LIKE "Sketchup Pro 8"

OR
g_s.name LIKE "Sketchup 201%"

    OR
g_s.name LIKE "SYSTRAN"

    OR
g_s.name LIKE "ZWCAD Classic Français"

    OR
g_s.name LIKE "VPN_SETEC"

    OR
g_s.name LIKE "Polycom Telepresence m100"

    OR
g_s.name LIKE "Polycom PVX"

)
ORDER BY nom_ordinateur;

Cordialement

kevinG

Member

From: Paris

Registered: 2014-02-26

Posts: 423

Re: Dernier inventaire

Bonjour,

Si je ne me trompe pas (moi j'utilise cette table en tout cas), il s'agit de la table "glpi_plugin_fusioninventory_inventorycomputercomputers" dedans tu as la colonne "computers_id" pour faire la liaison avec la table "glpi_computers" et la colonne "last_fusioninventory_update" pour la date de dernier inventaire.

---

Version en production GLPI 9.4.5 - Agent FI 2.5
Version en production Fusion Inventory 9.4+2.4
Version PHP 7.2.16
Zend Engine v3.2.0 - Zend OPcache v7.2.16

victor.diana

Member

Registered: 2016-04-22

Posts: 3

Re: Dernier inventaire

Merci bien cela fonctionne
Vous pouvez clore ce topic

Cordialement