Systems Management Question

Inventory Rule

05/06/2019 407 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


  • This content is currently hidden from public view.
    Reason: Removed by member request For more information, visit our FAQ's.

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

  • 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!
    • 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
      • 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?
      • 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).

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