Get the version of the modules of all the agents


Derived from the number of agents registered in the NPAM console, it is difficult to visualize agent by agent if the packages or modules were updated correctly, so the following is required:

A report or query that displays all the packages and their versions, which contain all the agents that I have registered with NPAM.

I have made a query to the registry.db database located in /opt/netiq/npum/service/local/registry where with a join I get the agent and the packages it contains, but not its versions, how do I get the versions of each?.