Query custom fields in SQL Report?

Follow

Dennis Heijnemans

• March 20, 2019 17:40

Is there a way to query custom fields using a SQL Report? We have a custom field called Role (to indicate what role/function a computer plays in the company). When I try so SELECT Computers.Role in a SQL Report, the report always fails with "no such column". Am I missing something here?

0

• 

  Colby Bouma

  • March 21, 2019 22:33

  You have to left join the CustomComputerValues table, and it can get a little tricky depending on exactly what you want your report to do. Here are a couple of examples:

  https://community.pdq.com/posts/10732/#10838

  https://community.pdq.com/posts/10000/#10220

  0

  Comment actions Permalink
• 

  Dennis Heijnemans

  • April 16, 2019 14:21

  Thanks! I've had a chance to play around with it, and it works a treat. Spitting out reports and finding more and more handy custom values to put in (like warranty info, reseller etc).

  0

  Comment actions Permalink

Please sign in to leave a comment.