/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Automating the Import/Export of Assets

03/16/2015 2046 views
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

Comments


All Answers

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

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