Software installed in last 7 days

[Wasique]

Hi All,

 

We have a sql query which gives the list of installed software in last 7 days. We want to generate a report using DSM reporter. 

 

Is there any way to import that sql query in DSM reporter or creating a query in DSM explorer and linking the same in DSM Reporter ?

 

Regards,

Mohd      

[Jean-Yves Guiblet]

Hello,

 

Please could you give us the sql query in order to research how to import it in the ITCM reporter ?

 

Thanks.

Regards,

Jean-Yves

[Wasique]

select dhw.host_name as 'Host',

def.name as 'Product',

def.sw_version_label as 'Version',

DATEADD(s, ds.creation_date, '19700101') as 'Installed On (GMT)'

from ca_discovered_hardware dhw

inner join ca_discovered_software ds on dhw.dis_hw_uuid=ds.asset_source_uuid

inner join ca_software_def def on ds.sw_def_uuid=def.sw_def_uuid

where ds.creation_date >= DATEDIFF(s, '19700101', GETUTCDATE()) - 604800

and ds.dis_source_type_id=1

and def.software_type_id=3

and dhw.creation_date <= DATEDIFF(s, '19700101', GETUTCDATE()) - 604800

order by dhw.host_name, def.name, def.sw_version_label, [Installed On (GMT)]