Hi,
  When i try to export all devices to csv i get this error:

Oops! Something went wrong.

What happened:

The KACE appliance has encountered an unhandled error. (more info)

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



Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

0
Multiple tables in your query have a column labeled "CREATED".  You'll need to specify which table you want to use for the "order by", such as MACHINE.CREATED or ASSET.CREATED.
Answered 02/23/2016 by: grayematter
Fourth Degree Black Belt

  • Thanks. How do i tell it which one to use?
    • MACHINE.CREATED will indicate when the inventory record was created. ASSET.CREATED will indicate when the asset record was created. In our instance, asset records are created as the systems are received. This could be some time before the machines are deployed and check in to created the inventory record.
Please log in to comment

Answers

Answer this question or Comment on this question for clarity

Share