K1000 report that shows recently added software to the software catalog
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
Answers (0)
Please log in to answer
Be the first to answer this question
