Inventory Rule

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

Answers (2)

Posted by: SMal.tmcc 3 years ago
Red Belt

Does the service endate match your expected replacement date?

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

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. 

  • Chuck, could you give some more details about how you "created a field in the device asset"? I would like to setup a replacement cycle field also. Thanks! - cottonakin 2 years ago
    • In the admin console:
      In the left menu select Asset Management
      Click Asset Types
      Click Computer
      There will be a list of asset fields. At the top of the list on the right side, click the plus button
      Enter the parameters for the field. I used
      Name: Upgrade cycle (years)
      Type: Number
      Everything else I left as the default values.
      Click Add to add the field
      Click Save to save the changes to the asset type - chucksteel 2 years ago
      • Thanks Chuck. I have made the field but, so far, I don't really see it doing anything. I forced an inventory on my own system and under Asset, it shows the field but it is blank. What am I missing? - cottonakin 2 years ago
      • Creating a field in the asset won't auto populate it. We set ours using a custom ticket rule (custom ticket rules can act on things other than tickets). - chucksteel 2 years ago

Don't be a Stranger!

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

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ