Reporting, or alerting on devices that change
Is it possible to have a report that lists all the devices that have changed over the past 24 hours.
What I would be looking for would be hardware changes (memory/disk, etc) and installation of new software.
Regards
What I would be looking for would be hardware changes (memory/disk, etc) and installation of new software.
Regards
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
GillySpy
12 years ago
The changes in inventory are capture in ASSET_HISTORY. So you could write a report to summary, extract, reformat that data. It would be a custom query as it is often non-trivial
For example, this query we wrote for a customer gives you the software items installed in the last 7 days
For example, this query we wrote for a customer gives you the software items installed in the last 7 days
select A.NAME as Computer,
FoundSoftware,
S.DISPLAY_NAME,
S.DISPLAY_VERSION,
S.ID, AH.TIME asTimestamp, M.USER as 'Last Logged-in User'
from ASSET A
left join(select SUBSTRING_INDEX(DESCRIPTION,'\nSoftware item ',1) FoundSoftware,
ASSET_ID,TIMEfromASSET_HISTORY) AH on AH.ASSET_ID=A.ID
left join SOFTWARE S ON LOCATE(CONCAT(S.DISPLAY_NAME,' ',S.DISPLAY_VERSION),FoundSoftware)>0
left join MACHINE M on M.ID=A.IDwhere A.ASSET_TYPE_ID=5and FoundSoftware like 'Foundsoftware item%'
and AH.TIME >DATE_SUB(now(),INTERVAL 7 DAY)
order by M.NAME, AH.TIME desc,S.DISPLAY_NAME,S.DISPLAY_VERSION
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
