Add software counts to Fleet usage statistics

[lucasmrod]

Why

We'd like our (simulated) loadtest environments to be as close to reality as possible.
We need information of software counts with respect to host counts. (We currently don't have this information)

What

We'd like to collect the following stats from Fleet users:

• Number of rows in software table.
• Number of rows in host_software table.
• Number of rows in software_titles table.
• Number of rows in host_software_installed_paths table.
• Number of rows in software_cpe.
• Number of rows in software_cve.

They should be added here:

fleet/server/datastore/mysql/statistics.go

Line 23 in bb310e6

func (ds *Datastore) ShouldSendStatistics(ctx context.Context, frequency time.Duration, config config.FleetConfig) (fleet.StatisticsPayload, bool, error) {

Next steps

After collecting this information, we need to update osquery-perf agents to reflect the software/host_software counts. In addition, we also need to lower the % of failing to fetch software from 50% to something more realistic like 5% or lower.

[noahtalerman]

@lucasmrod makes sense.

I think this issue meets the definition of ~engineering-initiated so it can go through the eng-initiated prioritization process instead of feature fest.

Pulling this off the feature fest board.

cc @lukeheath

[sharon-fdm]

@lukeheath @noahtalerman @lucasmrod I actually have a very similar PR for that from the hackathon. (minor adaptations)
#19078

[sharon-fdm]

FYI @eashaw, These metrics should be reported starting the next version.