- 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
