Commserv sql statement client installed software table or view

​Hi guys!

I’m newbie here and trying to write a sql statement on commserv database returning all clients where operating system is MS Windows. It’s not a big deal - i’ve got something like below

SELECT id, componentNameId,attrName,attrVal
  FROM [CommServ].[dbo].[APP_ClientProp]
  where attrName='Operating System Name' and
  attrVal like 'Windows%';

Now i would like to join table or view where information about installed agent/components are kept. I mean when you click on a commcell brower and expand client computes you can see
 

Any idea where, in what table/view installed software on a particular clients can be found?

I’m expecting results like:

Or maybe i should use reports- if so what kind?

Regards,
Michal

​