We have a problem with search about different software name that "name". In 2.1.2 version we didn't have any problem with that. Perhaps, we have now 2.8 version and we have this problem.
We try with different option and it shows all computers (we think it is "normal" because all computers have some software different that "name"). We also try with "doesn't contain" but it show nothing.
If we try the query of "doesn't contain" option
(SELECT DISTINCT hardware.ID FROM hardware INNER JOIN software on hardware.id = software.hardware_id LEFT JOIN software_name on software_name.id = software.name_id LEFT JOIN software_publisher on software_publisher.id = software.publisher_id LEFT JOIN software_version on software_version.id = software.version_id WHERE software_name.HARDWARE_ID NOT IN (0) GROUP BY hardware.id;) we have an error (ERROR 1054 (42S22): Unknown column 'software_name.HARDWARE_ID' in 'where clause'). If we change the last software_name.HARDWARE_ID to software_name.ID (hardware_id not exist in this table) it shows all computers.
We have also tried to search with dynamics groups. We search all computers that have "x" software, we create a dynamic group with this computers. But when we try to search computers that not belong to this group it's not possible select the name of group (not shown any group and is not possible write the name).
Are there any bug with that?
Thank you very much.