"How to report on which hosts are enrolled in software and hardware asset management"
Using the normal GUI it would need to be two separate tables. One would have the distinct list of all the node captions from the hardware table, and the second widget would have the captions from the software asset inventory.
Or you could combine both into one widget using SWQL and left joining each table with something like a
....case when software.nodeid is not null then 'Enabled' else 'Disabled' end as Software_Status
....