k1000 DB field reference for Inventory Fields
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?
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
Comments:
-
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? - Jbr32 11 years ago
