Asset Report based on Installed Software

Hello,

I want to report on workstation specification for all workstations running a certain piece of software. This is something we regularly do on our existing system (SDP not yet live).

I can't see how to do this because the workstation spec and the software are in different tables and the new custom query option only works with one table at a time (I think????).

I don't know much about SQL reporting but I guess this is why I see all so many requests for bespoke reports in this forum. (I also agree with the sticky, why not put them all in one place ?)

Is there a guide to creating such reports? I'd be happy to try myself.

If not, can I have a report please (I can insert the software name). (MS SQL)

Thanks in advance.