KACE1000 MACHINEs vs COMPUTERs vs SYSTEMs
Within the KACE1000/1200 console :: when I goto the only Organization I have (sans System) as Admin, I select | Inventory | from the Menu-Ribbon then tab /Computers\ , the current Computer Inventory lists 12 Named "SYSTEMS" under the Computer Inventory datagrid.i hope this information benefits not only me but all Custom Report Developers within the community.
... 1) First, I understand from studying documentation, "MACHINES" which were once scanned and even if they are not currently actively sync'd they will still display in this list (correct?)
... 2) Second I understand from KACE support replies, the Organization I am currently authenticated within [namely SA] DIRECTLY corresponds to ORG1 datatable and since I only have this table set; that there is no ORG2 in SQL only KBSYS accompanying ORG1 there should be no other Organization.
...3) Thirdly I understand that a any "MACHINE" is a scanned "SYSTEM" that is automatically added in Computer Inventory? This consitutes it is a valid "COMPUTER" to track ? or am I missing a step that assigns the ASSET TYPE ... not including Labels... is there a manual step with the ASSET assignment ?
So what mainly dumbfounds me is why when I perform a SELECT * FROM MACHINE I get two systems returned in MySQL studio from the Command Line Query Lookup... One of which IS listed in Computer Inventory in the KACE console, the latter I cannot find it at all anywhere in fact; NOT even when I try to Browse all data tables ?!?!?
So is there a way in KACE console I can find to listout MACHINES w/ TYPES table along with 11 other "Computers" is there a way to drill-down into them and see if they are perhaps "mis-categorized" with wrong type [not ASSET TYPE 5 = "Computer"] thus not coming up listed within Machines in Console Computer Inventory ?
does that make sense ?
once I understand all that I have been self 'taught' above,
My GOAL is to Qualify my lookup of MACHINES which consist of only active valid COMPUTERS and list critical windows updates with a pseudo Query Lookup like so:
SELECT * FROM MACHINE WHERE M.NAME = ASSET.TYPE='5' /*Computer*/ AND CRITICAL = 'Un-PATCHED'
The data-table topology is incomplete not listing ASSETs tables among other items... So Im really in the dark to piece the unknown qualifiers JoinTables JT to flush this out... I shouldnt have to be billable more than my support Im paying on already just to uncover a table structure issue. ...many thanks