In the KACE SMA (Systems Management Appliance)/K1000 an export from the software inventory page results in an Oops page including a PHP error: Uncaught ADODB_exception in /kbox/kboxwww/adminui/software_inventory.php on line 318:mysqli error: [1052: Column 'ID' in group statement is ambiguous].
Status: This issue has been resolved in version 7.0 of the SMA/K1000. See instructions to update the SMA to the latest version.
Contact Support if upgrading from 6.3 or earlier, to the latest version.
Workaround: Go to Inventory | Software | Choose Action | Export All to CSV (without first checking any boxes in the list) and then filter within Excel to only see the desired software.
Alternatively, the user can go ahead and search for the specific list of software required and choose Create Report from the Choose Action drop-down. Name the report and save. The report can then be created in whatever format is most appropriate.