I am using the following code to produce a report that shows all software that was installed over 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")))

This code produces the following report:



The problem I am having is that the report shows software that is already installed. It's basically reporting the software that was updated. I need to create a report that shows ONLY NEW software that was installed. Is there a way to do this?

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