Three month power saving report now only shows current month
I ran the 3 month power saving report. Now only see July but not June and May. Any Ideas?
Community Chosen Answer
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