Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

image.png

Hi community :slightly_smiling_face:

I installed Fleet on AWS EKS.
Software information is not collected from Agent.
Do you know the solution?

Hello <@U06V52WE8QZ>! Do you have `enable_software_inventory` set in your config file? <https://fleetdm.com/docs/configuration/yaml-files#features>

Hello <@U045LRCCF7U>!

It's set. :smiling_face_with_tear:

```  features:
    enable_host_users: true
    enable_software_inventory: true```

'software' tables contain data.

The table below is Empty set.
• software_host_counts 
• software_titles
• software_titles_host_counts

Hi <@U06V52WE8QZ>. Here are a few questions I have for you to try and diagnose your issue:
1. What version of Fleet are you running?
2. Can you check the server logs for any errors and screenshot them at possible? You may need to filter the logs by 'titles' to give us a better view.

1. What version of Fleet are you running?
&gt; image: <http://docker.io/fleetdm/fleet:v4.50.0|docker.io/fleetdm/fleet:v4.50.0>
I'm trying to downgrade to version 4.4.

2. Can you check the server logs for any errors and screenshot them at possible? You may need to filter the logs by 'titles' to give us a better view.
&gt; There are no errors in the web console.

I think the problem is that there is data in the 'software' table, but no data in the 'software_titles' table.

fleetctl get software
```Warning: Version mismatch.
Client Version:   4.56.0
Server Version:  4.50.0
No software titles found```


Thank you for that information. Yes, the `software_titles` table is one of the relevant tables in this case. Could you please:
1. Run `fleetctl debug archive`
2. Email the archive that's generated to <mailto:support@fleetdm.com|support@fleetdm.com>


<@U06V52WE8QZ> Please update MySQL to version 8.0.36 and  Fleet to the latest version (v4.56.0) and let us know if the issue still persists.

After updating the version, the problem was resolved.
thank you