1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Can computed fields be created in inventory?

Avatar
Craig Mohr

I'm guessing this is not possible but is there a way to display a "computed field" in inventory? Specifically managers want to know how old a PC is without having to convert a date so would like a field that displays a age field with a value like 2.3 or 5 for how many years old it is.

1

Comments

2 comments
Date Votes
  • Avatar
    lnichols

    Craig,

    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.

    0
  • Avatar
    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.

    0