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
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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

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
Answered 09/16/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity