Can computed fields be created in inventory?



  • Luke Nichols


    As far as I know this cannot be done directly in Inventory, but you could calculate this using a SQL report. Whenever managers want this information just generate a SQL report that has a generated field based on doing math on the date field.

    Alternatively depending on your use case you could have separate reports for computers that are <1 year old, 1+ years old, 2+ years old, etc. based on filtering on date values. It wouldn't give the exact age but it would effectively accomplish the same thing.

    Comment actions Permalink
  • Craig Mohr

    Yeah I figured the SQL report might be able to but looking at it made my eyes water and head hurt :D. I was trying to pretend it didn't exist.

    Comment actions Permalink

Please sign in to leave a comment.