/build/static/layout/Breadcrumb_cap_w.png

KACE report of all assets with their last modified date

Hi folks!

Does anyone have a sql query to report on all assets and include their last modified date? We're running reports on all assets right now, sorting by serial number, and seem to have a number of assets with duplicate serial numbers. The most accurate entry seems to be the asset with the latest modified date.


Thanks in advance for any help

Asked 5 years ago 798 views
3 Comments   [ + ] Show comments
  • Are your assets only computer devices. And are they computers with agents on them and an inventory in the K1.
    or do you have many different assets not showing up in inventory? - akmagnum 5 years ago
  • No, they are computer (with agent) and mobile devices (agentless). Everything is showing up in inventory. I just would like to take an asset report of all assets with their last modified dates under the Reporting section of K1000 - cjohnson@pandora.com 5 years ago
  • I would like to use the Modified date in a view so that I can order them by that. The field is populated in the asset but is not available in the view - kiwiblue 4 years ago

Answers (0)

Be the first to answer this question

 
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