/build/static/layout/Breadcrumb_cap_w.png
11/11/2018 157 views

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

2 Comments   [ + ] Show comments

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?
  • 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

There are no answers at this time