I am using the following code to produce a report that shows me the machines that have installed software in the past 24 hours:

Select
ASSET.NAME As MACHINE_NAME,ASSET_HISTORY.TIME As TIME,ASSET_HISTORY.VALUE1 As 'Software Name'
From ASSET,ASSET_HISTORY
Where
ASSET_HISTORY.ASSET_ID = ASSET.ID And
(ASSET_HISTORY.TIME > Date_Sub(Now(), Interval 1 Day) And
ASSET_HISTORY.VALUE1 NOT LIKE '%(KB%' And
(ASSET_HISTORY.FIELD_NAME = "SOFTWARE" And
ASSET_HISTORY.CHANGE_TYPE = ("detected")))

It produces the following report:



The problem with this report is that it shows software that is already in the software catalog. Most, if not all of the entries on the report are updates to software that is already installed. I need to create a report that shows ONLY NEW software and not updates. I am thinking I can do this somehow with the software catalog.

So...my question. Is there a way to set up a report that will show me ONLY NEW software that was added to the software catalog, which machines installed the software and what time?

I appreciate the help!
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity