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.

Query custom fields in SQL Report?

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?

Comments

2 comments

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
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