Hello @Diego Biondo, could Craig help you with the information provided?
Let us know if you have further questions!
Hi fellows where can i find an architecture diagram and prerrequisites for these 3 components
I'm not exactly sure what you are asking but.....
Here is an Inventory DB Structure Guide...
It may be a little outdated by not sure too much.
In General, I recommend building an AD HOC report with the desired data in the ZENworks Report Server. These allow you to export the query used. This gives you an idea how the data is stored in a much more direct way.
For ZCC Reports to get the SQL....
Be sure to "Like" My (and a few others) Cool Solutions below!