Skip to main content

​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

 

Hi @DisplayName 

Please check this thread. 

 

You may need to join with App_IdaName and APP_IdaType tables.

 

Thanks,

Sunil-


Hi @Sunil 
thanks a lot for table names and tips. That’s what i was looking for!

sql query:

 select c.name, p.attrName, p.attrVal, it.displayName from
  APP_Client C,
  APP_ClientProp P,
  APP_IDAName I,
  APP_iDAType IT
  where 1=1
  and c.id=p.componentNameId
  and C.id = I.clientId
  and I.appTypeId = IT.type
 -- and c.id=119
  and p.attrName='Operating System Name'
  and p.attrVal like 'Windows%';   

Regards,
Michal


Reply