Hi,
if you have NPM 10.2 or higher you should check table SyLogNodes.
SELECT * FROM SysLogNodes
It contains list of all NodeIDs for SysLog. For more information about given node you can join it with Nodes table like this:
SELECT Nodes.IP_Address, Nodes.Caption FROM SysLogNodes AS SLNODES
INNER JOIN Nodes AS NODES
ON
NODES.NodeID = SLNODES.NodeID
Do you see all required nodes in result of these queries?
Another cause of this issue can be hidden in limitations applied for your account.
i assume this is looking at the sql database and running a query?
sadly thats not my area of expertese
