Monitor Computer Age

[Guest]

Is it possible to create an internal monitor that looks for computers with an asset date older than 4 years?

I see I can look at the computer table, and the field assetdate - but how do I trigger if the date is older than 4 years from todays date?

Thank you!

[waremi.tabinc]

For the Check Condition pick "LessThan" and for the Result use: DATE_ADD(NOW(),INTERVAL -4 YEAR)

-Mike

[peter.intellisystems]

But AssetDate broke at some point. Now it usually has the date of the agent install instead of the original OS install date. I've opened a ticket with LT and they say talk to consulting.

It's very difficult to get computer age from LT now. I've done a complicated query to do some of that, but it's not 100%.

[erin.simplysmarttech]

Same same... called LT Support and they say contact consulting.

BIOS date is a half step in that direction:
http://support.labtechsoftware.com/home ... ate#p28342

[ed.factoryinfotech]

I opened a ticket w/ support in the last month or so, they say the OS Start Date field, which currently returns the LT install date instead, will be fixed in the next release. We shall see...

[matt.rohler.myitpros]

We use a product called UpdateWarranty.

http://www.updatewarranty.com/updatewar ... erver/home

It can update the purchase date/warranty date on most PC's and stores it in an EDF