KACE Product Support

So I have created the following scripts which appear to work:

SELECT
ID,
NAME,
OS_NAME,
SERVICE_PACK,
OS_VERSION,
OS_BUILD,
CS_MANUFACTURER,
CS_MODEL,
BIOS_SERIAL_NUMBER,
RAM_TOTAL,
RAM_USED,
IP,
MAC
 FROM MACHINE

Select
ID,
NAME,
DISK_USED,
DISK_FREE,
DISK_SIZE,
PERCENT_USED
 FROM MACHINE_DISKS

Select
ID,
DISPLAY_NAME,
PUBLISHER,
DISPLAY_VERSION
 From SOFTWARE

What I need to work out is how to join them together into a neat report.

If you can't produce the report you want using the report wizard, then I would start by setting up MySQL Workbench on your machine so that you can experiment with the SQL code you'll need. Copy the code from one report, say the Computer Export report and start experimenting with the SQL to get it to the place you want. For instance, if you don't want to export all of the same fields, remove the select statements that choose those fields. Then look at the Software Export report and figure out which fields you need to add to the select statement. You'll probably also need to add some table joins to get the proper information.

Feel free to post what SQL you come up with and we can help from there.

The built-in report titled 'Software on Computer' appears to do close to what you want (Lists all software on each computer on your server).

If you wanted more detail on the machine, you would just want to create a report gathering more fields, such as:

SELECT * FROM MACHINE
LEFT JOIN MACHINE_SOFTWARE_JT ON MACHINE_SOFTWARE_JT.MACHINE_ID=MACHINE.ID
LEFT JOIN SOFTWARE ON SOFTWARE.ID=MACHINE_SOFTWARE_JT.SOFTWARE_ID

and include Break on Columns: MACHINE.ID

***Beware that a report with this much detail can take a little while to run, depending on the size of your database.***