Scripting : KACE report of all assets with their last modified date

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

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 6 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 6 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 5 years ago

Answers (0)

Be the first to answer this question

Answer this question

Posted by:

View more:

Scripting Questions

question

KACE report of all assets with their last modified date

Answers (0)

Posted by:

View more:

Related Questions

Related Links

Related Posts

Scripting

KACE report of all assets with their last modified date

Answers (0)

Posted by:

Don't be a Stranger!

View more:

Related Questions

Related Links

Related Posts

Share