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   [ + ] Show Comments

Comments

Please log in to comment

Answers

1

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
Answer this question or Comment on this question for clarity

Share