Automating the Import/Export of Assets
I know it is possible to manually add a csv of asset information in to the k1000. Is it possible to automate this process, via a ticket rule or some other means? Like on a weekly or nightly basis similar to the User import function? Also using reporting would it be possible to export out any assets that have had information changed using the record last modified date?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
aragorn.2003
9 years ago
I think you can´t do this by a cronjob or anything else. the best way would be a report and send it to the needed location.
Another way could be a script that connects to the database and selects the needed data.
eg. all computer assets modified since yesterday.
select a.NAME, a.MAPPED_ID, a.CREATED, a.MODIFIED
from ASSET as a, ASSET_DATA_5 as ad, MACHINE as m
where a.ASSET_DATA_ID = ad.ID
and a.ASSET_TYPE_ID = 5
and a.MAPPED_ID = m.ID
and a.MODIFIED >= subdate(current_date, 1)
order by a.MODIFIED desc
