How to create a report on software signature scan date?

Document ID : KB000011118
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

The SQL query should be able to pull the software signature scan date information.

This option is not available by default via DSM reporter. 

Question:

How to create a report on software signature scan date?

Environment:
CA Client Automation - All Versions
Answer:

The ability to create a Report based on Software Signature Scan Data is not available by default.

The workaround is to run the following SQL Query against the MDB database:

 

use mdb
select distinct dhw.label, DATEADD(s, smod.stdate, '1/1/1970'), mod.moname, smod.sttext,
smod.status, smod.stcount, mod.moname from ca_discovered_hardware as dhw
join statmod as smod on dhw.dis_hw_uuid = smod.object_uuid
join ncmodcfg as mod on smod.moid = mod.moid and smod.mdomid = mod.domainid

where mod.moname = 'Software Inventory Configuration'