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.9.1 available

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

All software: “No data available in table”

  • OS Name : Linux x86_64
  • Version : 5.3.18-lp152.72-default
  • RAM installed : 3892 MB
  • Free RAM : 3082 MB
  • Distribution : openSUSE Leap 15.2
  • PHP Version : 7.4.6
  • Web Server : Apache
  • Database Server : MariaDB package version 10.4.17-MariaDB
  • Version OCSReports: 2.8.1
  • Agent Version: 2.8.1

Problem: Inventory -> All software: “No data available in table”, but there are 3 hosts in inventory and all three have software inventoried.

In the “All Sofware” page this SQL command is called but looks like it is not working:

MariaDB [ocsweb]> SELECT SQL_CALC_FOUND_ROWS n.NAME, p.PUBLISHER, v.VERSION, sl.IDENTIFIER as id, sc.CATEGORY_NAME, sl.COUNT as nb FROM software_link sl LEFT JOIN software_name n ON sl.NAME_ID = n.ID LEFT JOIN software_publisher p ON sl.PUBLISHER_ID = p.ID LEFT JOIN software_version v ON sl.VERSION_ID = v.ID LEFT JOIN software_categories sc ON sl.CATEGORY_ID = sc.ID order by nb desc limit 0 , 10;

Empty set (0.000 sec)

Is this a bug or I’m missing something?

All sofware empty: https://postimg.cc/rztjXy0Y

Host with sofware: https://postimg.cc/ftP87J3Y

Obs: On Ubuntu 20.04 has the same problem... Ocs server and agent installed from source

in OCS Inventory NG server for Unix by (400 points)
edited by

1 Answer

0 votes
by (2.9k points)
 
Powered by Question2Answer
...