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


Please log in to comment


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.

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
Answered 03/17/2015 by: aragorn.2003
Red Belt

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