KACE Product Support

What happened:

What to try next:

Contact support and let them know what you were doing when this happened.

Reload the page that caused the error.

When i click (more Info) i see this:

PHP Error: Uncaught ADODB_Exception in /kbox/kboxwww/adminui/computer_inventory.php on line 584: mysqli error: [1052: Column 'CREATED' in order clause is ambiguous] in EXECUTE("select (CASE WHEN MACHINE.MANUAL_ENTRY = 1 THEN 'Manually added device'
WHEN MACHINE.MANUAL_ENTRY = 2 THEN 'Manually added device'
WHEN MACHINE.MANUAL_ENTRY = 3 and UNIX_TIMESTAMP(MACHINE.LAST_SYNC) > (UNIX_TIMESTAMP()-(SELECT VALUE*60 FROM SETTINGS WHERE NAME ='AGENTLESS_INVENTORY_INTERVAL')) THEN 'Agentless device'
WHEN MACHINE.MANUAL_ENTRY = 3 and UNIX_TIMESTAMP(MACHINE.LAST_SYNC) <= (UNIX_TIMESTAMP()-(SELECT VALUE*60 FROM SETTINGS WHERE NAME ='AGENTLESS_INVENTORY_INTERVAL'))
THEN 'Unable to reach this agentless device'
WHEN CLIENT_CONNECTED =1 THEN 'Agent-managed device'
WHEN CLIENT_CONNECTED =0 THEN 'Unable to reach this agentless device'
ELSE 'Unable to reach this agentless device'
END) AS 'Status',MACHINE.NAME as SYSTEM_NAME,MACHINE.IP,MACHINE.SYSTEM_DESCRIPTION, MACHINE.DOMAIN,MACHINE.MAC,
MACHINE.NOTES,OS_NAME,MACHINE.OS_VERSION,MACHINE.SERVICE_PACK,
MACHINE.SYSTEM_DIRECTORY,MACHINE.USER_LOGGED, MACHINE.LAST_SYNC as LAST_SYNC,
UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS, MACHINE.USER_DOMAIN,
MACHINE.USER,MACHINE.CS_MANUFACTURER,MACHINE.CS_MODEL,MACHINE.CS_DOMAIN,
MACHINE.BIOS_NAME,MACHINE.BIOS_VERSION,MACHINE.BIOS_MANUFACTURER,MACHINE.BIOS_DESCRIPTION,
MACHINE.BIOS_IDENTIFICATION_CODE,MACHINE.BIOS_SERIAL_NUMBER,MACHINE.PROCESSORS,
MACHINE.RAM_TOTAL,MACHINE.REGISTRY_SIZE, MACHINE.CLIENT_VERSION,
CASE MACHINE.MANUAL_ENTRY
WHEN 0 THEN 'Agent'
WHEN 1 THEN 'Manual'
WHEN 2 THEN 'WSAPI'
WHEN 3 THEN
CASE REMOTE_HOST.PROTOCOL
WHEN 1 THEN 'SSH/Telnet'
WHEN 2 THEN 'SNMP'
WHEN 3 THEN 'WinRM'
WHEN 4 THEN 'Google Admin Console'
WHEN 5 THEN 'Dell Mobility Management'
ELSE 'Agentless'
END
ELSE 'Unknown'
END AS SOURCE,
MACHINE.KUID,MACHINE.TZ_AGENT, MACHINE.VIRTUAL,
MACHINE.ID AS ID
,GROUP_CONCAT(MACHINE_DISKS.NAME) as DNAME from MACHINE left join MACHINE_DISKS on MACHINE.ID = MACHINE_DISKS.ID LEFT JOIN KBSYS.KUID_ORGANIZATION KUID_ORG ON KUID_ORG.KUID = MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION SC ON MACHINE.KUID = SC.KUID AND substring(SCHEMA(),4) = KUID_ORG.ORGANIZATION_ID LEFT JOIN REMOTE_HOST_KUID ON REMOTE_HOST_KUID.KUID = MACHINE.KUID LEFT JOIN REMOTE_HOST ON REMOTE_HOST.REMOTE_HOST_ID = REMOTE_HOST_KUID.REMOTE_HOST_ID LEFT JOIN ASSET ON ASSET.MAPPED_ID = MACHINE.ID AND ASSET.ASSET_TYPE_ID=5 LEFT JOIN ASSET_CLASS ON ASSET_CLASS.ID = ASSET.ASSET_CLASS_ID LEFT JOIN ASSET_DATA_5 ON ASSET_DATA_5.ID = ASSET.ASSET_DATA_ID GROUP BY MACHINE.ID order by CREATED desc")

I get this on every machine i try to export on. I have used IE, Chrome and Firefox. Anyone have any idea what is causing this?

Thanks for any help.

Chris