Query Report - Looking For A List of Sub-Modules & Their Objects
The Desktop Central example for a query report is:
select SOFTWARE_NAME, LONG_TO_DATE(DETECTED_TIME) from invsw where DETECTED_TIME <= DATE_TO_LONG(09/29/2009 00:00:00) or (DETECTED_TIME <= <from_lastmonth> and DETECTED_TIME>= <to_lastmonth>)
The item "invsw" tells the query that your pulling information from the "Software" sub-module. What other sub-modules exist and what are their names (e.g. Computers, Hardware, ect)? Also, where can I find a list of objects are available to select from for each sub-module? For example, SOFTWARE_NAME goes with "Software Name", DETECTED_TIME goes with "Software Detected Time".
If I had a more comprehensive list of sub-modules and their selectable objects than I could start building some query reports.