You can try to run agent with DebugLevel = 6 in it's config - actual query and detail of execution should be visible in the log. Pls share the log part related to execution of the query.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts Menunxdbmgr -s -Z all -e hardware_inventory -e software_inventory export backup.sql
nxdbmgr import backup.sql
debug ncd.* 7