Hello everyone, is there a way with osquery to get the number of all outdated packages from apt package manager, for example or even better from all package managers?

Not directly. Either you’d need a custom table to interface with the package manager, if that information can be exposed. Or you’d need to collect the information from external sources and correlate it. (Depending on how you expose it, that might also be available to the osquery sql)