获取软件及其所在机器、关联用户以及安装时间的数据

获取软件及其所在机器、关联用户以及安装时间的数据



select swl.softwarename "软件名称",si.workstationname "工作站名称" , aaaUser.FIRST_NAME "所有者", LONGTODATE(swi.filecreatedtime)  "安装时间" from softwarelist swl left join softwareinfo swi on swl.softwareid=swi.softwareid left join systeminfo si on swi.workstationid=si.workstationid left join Resources resource ON si.WORKSTATIONID=resource.RESOURCEID LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID  where swl.softwarename like '%<软件名称>%'

    • Related Articles

    • DC生成禁用软件报表的查询语句

      语句可直接查询禁用软件内容包括： 软件名称，软件版本，软件厂商，许可类型，计算机名称，安装账户，域名称，远程办公室名称 select   SOFTWARE_NAME,   SOFTWARE_VERSION,   MANUFACTURER_NAME,   (     case when sw_type = 0 then 'Unidentified' when sw_type = 1 then 'Commercial' when sw_type = 2 then 'Non Commercial' ...

    • workstation或者server的软件报表清单

      select swl.softwarename "软件名称",si.workstationname "工作站名称" from softwarelist swl left join softwareinfo swi on swl.softwareid=swi.softwareid left join systeminfo si on swi.workstationid=si.workstationid