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