can you try to use SWQL studio from SDK and run the query that you run from Java also there? Does it also give you only one record instead of expected number?
Can you try to run following query in SQL directly?
SELECT [T1].[NodeID] AS C1, [T1].[SpeedMHz] AS C2, [T1].[NumberOfCores] AS C3, [T1].[NumberOfThreads] AS C4, [T1].[Name] AS C5, [T1].[Stepping] AS C6, [T1].[Model] AS C7, [T1].[Caption] AS C8, [T1].[Manufacturer] AS C9 FROM dbo.AssetInventory_ProcessorView AS T1 WHERE [T1].[NodeID] = 411
This is what SWIS executes when you run
SELECT NodeID, SpeedMHz, NumberOfCores, NumberOfThreads, Name, Stepping, Model, Caption, Manufacturer FROM Orion.AssetInventory.Processor WHERE NodeID = 411
throught SDK so they should both give the same results.