05/06/2019 88 views

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.

0 Comments   [ + ] Show comments


All Answers


Does the service endate match your expected replacement date?

Answered 05/06/2019 by: SMal.tmcc
Red Belt

  • I'm not even seeing the Dell Service Information. Where do i find this info?
    • expand hardware under inventory information on a device detail page
      • Thank you! Now I found it and no it does not
      • Ok so much for the easy answer. will keep on thinking about it. Math in a CIR will take a little thought

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. 

Answered 05/07/2019 by: chucksteel
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login