/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: aragorn.2003 9 years ago
Red Belt
0
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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ