Is there a way to create a inventory rule to add a custom field that gives me a replacement date? I have the SQL query ready but is there not a way to use that in the custom inventory rule? I need it to be 3 years after the ship date for Laptops and 4 years after the ship date for Desktops.
Instead of storing this in the Inventory we created a field in the device asset for replacement cycle. Our reports then include projected replacement dates of the purchase date plus the replacement cycle. One advantage to doing it this way is when our replacement cycle changes (due to budget constraints) we can update the replacement cycle number on the affected assets and the reports are still accurate. The replacement cycle information from the asset can be displayed in the inventory, too, so techs can see the purchase date and the replacement cycle on the same page.
In order to use a custom inventory rule, you would need to have a script run on the local machine that queries the database for purchase info, adds the appropriate number of years, and then returns that value.