Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.6 available

The official documentation can be found on http://wiki.ocsinventory-ng.org. Read it before asking your question.

no ID_REQ table network

Helo

My ocs inventory not displaing hardware, netowrk, devices and software

I've set up debugging options on my ocsreports and on the demo from ocsinventory
I noticed that in my case there are no affich_networks SQL statements in any of these categories. below the piece of the buzzer code and the demo page.

My code:

ID_REQ
csv
SQLNOLIMIT
list_show_allSELECT %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s from hardware h LEFT JOIN accountinfo a ON a.hardware_id=h.id LEFT JOIN networks n ON n.hardware_id=h.id LEFT JOIN bios e ON e.hardware_id=h.id LEFT JOIN memories m ON m.hardware_id=h.id LEFT JOIN assets_categories ac ON ac.ID = h.CATEGORY_ID LEFT JOIN videos v ON v.hardware_id=h.id where deviceid'_SYSTEMGROUP_' AND deviceid'_DOWNLOADGROUP_' AND n.STATUS = 'up' group by h.id order by h.lastdate desc
SQL
list_show_allSELECT %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s from hardware h LEFT JOIN accountinfo a ON a.hardware_id=h.id LEFT JOIN networks n ON n.hardware_id=h.id LEFT JOIN bios e ON e.hardware_id=h.id LEFT JOIN memories m ON m.hardware_id=h.id LEFT JOIN assets_categories ac ON ac.ID = h.CATEGORY_ID LEFT JOIN videos v ON v.hardware_id=h.id where deviceid'_SYSTEMGROUP_' AND deviceid'_DOWNLOADGROUP_' AND n.STATUS = 'up' group by h.id order by h.lastdate desc limit 0 , 10

Code in demo page:

88
99
2323
7777
8383
csv
SQLNOLIMIT
affich_multi_critSELECT %s.%s AS hardwareID , %s.%s AS hardwareDEVICEID , %s.%s AS hardwareNAME , %s.%s AS hardwareWORKGROUP , %s.%s AS hardwareUSERDOMAIN , %s.%s AS hardwareOSNAME , %s.%s AS hardwareOSVERSION , %s.%s AS hardwareOSCOMMENTS , %s.%s AS hardwarePROCESSORT , %s.%s AS hardwarePROCESSORS , %s.%s AS hardwarePROCESSORN , %s.%s AS hardwareMEMORY , %s.%s AS hardwareSWAP , %s.%s AS hardwareIPADDR , %s.%s AS hardwareDNS , %s.%s AS hardwareDEFAULTGATEWAY , %s.%s AS hardwareETIME , %s.%s AS hardwareLASTDATE , %s.%s AS hardwareLASTCOME , %s.%s AS hardwareQUALITY , %s.%s AS hardwareFIDELITY , %s.%s AS hardwareUSERID , %s.%s AS hardwareTYPE , %s.%s AS hardwareDESCRIPTION , %s.%s AS hardwareWINCOMPANY , %s.%s AS hardwareWINOWNER , %s.%s AS hardwareWINPRODID , %s.%s AS hardwareWINPRODKEY , %s.%s AS hardwareUSERAGENT , %s.%s AS hardwareCHECKSUM , %s.%s AS hardwareSSTATE , %s.%s AS hardwareIPSRC , %s.%s AS hardwareUUID , %s.%s AS hardwareARCH , %s.%s AS hardwareCATEGORY_ID FROM hardware WHERE %s.%s %s '%s' AND %s.%s %s '%s' GROUP BY hardware.id order by hardwareDEVICEID asc
affich_notesSELECT ID,DATE_INSERT,USER_INSERT,COMMENTS,ACTION FROM itmgmt_comments WHERE (visible is null or visible =1) and hardware_id=9 order by DATE_INSERT asc
affich_registrySELECT * FROM registry WHERE (hardware_id=9) order by NAME asc
list_show_allSELECT %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s from hardware h LEFT JOIN accountinfo a ON a.hardware_id=h.id LEFT JOIN networks n ON n.hardware_id=h.id LEFT JOIN bios e ON e.hardware_id=h.id LEFT JOIN memories m ON m.hardware_id=h.id LEFT JOIN videos v ON v.hardware_id=h.id where deviceid'_SYSTEMGROUP_' AND deviceid'_DOWNLOADGROUP_' group by h.id order by a.fields_17 asc

Please Help me

  • PHP 5.6.40
  • Web Server: Apache/2.4.39 (Unix) OpenSSL/1.0.2f PHP/5.6.40 mod_perl/2.0.10 Perl/v5.22.2
  • Database: MariaDB Server version 10.0.38-MariaDB
  • Ocsreports verion: 2.6
in OCS Inventory NG server for Unix by (360 points)

Please log in or register to answer this question.

 
Powered by Question2Answer
...