KACE Product Support

I know this might be an obvious answer, but did you have the client installed in May and June?

This will give you all records created in the past month. Does this return anything?

select NAME, IP, USER, CREATED
FROM MACHINE
WHERE CREATED BETWEEN (ADDDATE(LAST_DAY(SUBDATE(NOW(), INTERVAL 2 MONTH)), INTERVAL 1 DAY))
AND LAST_DAY(SUBDATE(NOW(), INTERVAL 1 MONTH))
ORDER BY CREATED DESC

What changed a month ago?  Did you upgrade or export?  Did someone break the report on you?

Mine works

this is what is in the SQL box

SELECT NAME, MAC, CUR_MONTH, CUR_HOURS, PREV_MONTH_HOURS, PREV_MONTH2_HOURS,
    (PREV_MONTH_HOURS-CUR_HOURS) AS CUR_HOURS_SAVED,
    (PREV_MONTH_HOURS-CUR_HOURS)*150/1000 AS kWh_SAVED,
    (PREV_MONTH_HOURS-CUR_HOURS)*150/1000*.15 AS SAVED,
    (PREV_MONTH_HOURS-CUR_HOURS)/PREV_MONTH_HOURS*100 as CUR_PCT_SAVED,
    (PREV_MONTH2_HOURS-PREV_MONTH_HOURS) as PREV_HOURS_SAVED,
    (PREV_MONTH2_HOURS-PREV_MONTH_HOURS)*150/1000 as PREV_kWh_SAVED,
    (PREV_MONTH2_HOURS-PREV_MONTH_HOURS)*150/1000*.15 as PREV_SAVED,
    (PREV_MONTH2_HOURS-PREV_MONTH_HOURS)/PREV_MONTH2_HOURS*100 as PREV_PCT_SAVED
    FROM (SELECT NAME, MAC, DATE_FORMAT(NOW(), '%Y-%m') AS CUR_MONTH,

    (select AVG(HOURS)
    from MACHINE_DAILY_UPTIME MDU
    WHERE DAY > LAST_DAY(SUBDATE(NOW(), INTERVAL 1 MONTH))
    AND M.ID = MDU.MACHINE_ID
    ) AS CUR_HOURS,

    (select AVG(HOURS)
    from MACHINE_DAILY_UPTIME MDU
    WHERE DAY BETWEEN (ADDDATE(LAST_DAY(SUBDATE(NOW(), INTERVAL 2 MONTH)), INTERVAL 1 DAY)) AND LAST_DAY(SUBDATE(NOW(), INTERVAL 1 MONTH))
    AND M.ID = MDU.MACHINE_ID
    ) AS PREV_MONTH_HOURS,

    (select AVG(HOURS)
    from MACHINE_DAILY_UPTIME MDU
    WHERE DAY BETWEEN (ADDDATE(LAST_DAY(SUBDATE(NOW(), INTERVAL 3 MONTH)), INTERVAL 1 DAY)) AND LAST_DAY(SUBDATE(NOW(), INTERVAL 2 MONTH))
    AND M.ID = MDU.MACHINE_ID
    ) AS PREV_MONTH2_HOURS

    from MACHINE M
    WHERE M.CHASSIS_TYPE = 'desktop') AS AVERAGES
    ORDER BY NAME