/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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