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].odbo].vAPP_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