Hi
i use 2 metod
using WMIC query
wmic product get Name, RegOwner, InstallDate |
using SqL
use mdb
SELECT hw.host_name AS Equipo, def.name AS Software, def.sw_version_label AS Version, --DATEADD(SS, def.creation_date, '19700101') as 'Colectado en fecha',
DATEADD(s, disc.creation_date, '19700101') as 'Software Instalado' ,
DATEADD(s, hw.creation_date, '19700101') as 'Agente instalado'
FROM dbo.ca_software_def AS def
INNER JOIN dbo.ca_discovered_software AS disc ON def.sw_def_uuid=disc.sw_def_uuid
INNER JOIN dbo.ca_discovered_hardware AS hw ON disc.asset_source_uuid=hw.dis_hw_uuid
WHERE
--def.name LIKE 'Adobe Flash Player%'
def.name LIKE '%java%'
--and
--hw.host_name like'%227801%'
--and def.sw_version_label LIKE '8.0.2010.9'
ORDER BY 'software instalado'