NetXMS Support Forum

Hi,

i would like to create some Reports with JASPER Reports.
But my Problem is, that my knowledge of the Databasestructure is not good enough.

At first i would like to write a Report About the Installed Software on the nodes.
Can someone help me to undestand the Databasetablestructure?

SQL is not my Problem.

thanks
Markus

Hi!

There are data dictionary: https://www.netxms.org/documentation/NetXMS_data_dictionary.pdf (https://www.netxms.org/documentation/NetXMS_data_dictionary.pdf). It's a bit outdated, but for most tables information is correct.

Best regards,
Victor

Hi,

thanks for this link.
I already know this PDF, and i can see all tables in Postgresql, but my Problem is, that i
dont know how to set the right relations for such a query.

In NetXMS i created a Container for 1 of my Customer. So i would like to create a report, for all of his nodes.
For example all Nodes and some Hardwareinformations, Software or something like that.
But i have no Idea how to get this Information out of the Database.

So it would be great, if you can give me a sample query.

Thanks
Markus

Nodes linked to containers via container_members table. For example, query to read all nodes in container with ID 111 will looks like


SELECT * FROM nodes
INNER JOIN container_members ON container_members.object_id=nodes.id
WHERE container_members.container_id=111


Best regards,
Victor

Hi Victor, i prepared a report designed in jrxml, but now when i try to create a report dont appears the "New report" button.  :-\
Do you know why? 

Thanks