Does anyone have a reference for which DB fields correspond to the various line-items on the "Computer Inventory" page? Its frustrating as heck to see the system able to determine some property; but I cannot work that into my Smart Labels because I don't know the proper DB table/field to make the SQL query work! I don't have time to play trial-and-error games with the GUI query-build tool (with its 4-line limit) and the "schema" files on the KBOX support site haven't been updated in several releases... Help?

0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



What fields are you looking for? If you are having issues with the four lines you might try using regex.


This would get all OS's with windows 7 enterprise,windows 7 professional, and windows 7 ultimate.

OS Name > Matches Regex > windows 7 enterprise|windows 7 professional| windows 7 ultimate

Answered 06/18/2013 by: dugullett
Red Belt

  • Have you tried doing what you want to do within the reporting module and then I think you can bring the SQL from the reporting module into the SQL of a custom smart label?
Please log in to comment