ITNinja

I have a report that will generate Disk Usage for our Servers on K1100 set up to run a weekly report. So far everything is working correct. My Supervisor now wants me to generate a report to show Last Weeks Report in this Weeks Report for comparison...Does anyone know if this is possible, if so, what do I need to do to get both reports to run on the same report.

This is the SQL Select Statement I have for the report to run on a weekly basis. (However, it doesn't ever seem like the numbers change at all from week to week).

SELECT MACHINE_DISKS.DISK_SIZE AS MACHINE_DISKS_DISK_SIZE, MACHINE_DISKS.DISK_USED AS MACHINE_DISKS_DISK_USED, MACHINE.NAME AS SYSTEM_NAME FROM MACHINE_DISKS JOIN MACHINE ON (MACHINE.ID = MACHINE_DISKS.ID) WHERE (MACHINE.NAME LIKE '%Apple%') or (MACHINE.NAME LIKE '%Orange%') or (MACHINE.NAME LIKE '%Banana%') or (MACHINE.NAME LIKE '%Grape%') or (MACHINE.NAME LIKE '%Kiwi%') or (MACHINE.NAME LIKE '%Pineapple%') or (MACHINE.NAME LIKE '%Strawberry%') or (MACHINE.NAME LIKE '%Blueberry%') ORDER BY MACHINE_DISKS.DISK_SIZE asc,MACHINE_DISKS.DISK_USED asc,MACHINE.NAME asc

Sorry had to change server names to names of fruit for asking this question. if someone has a code for me just use the fruit names i used and i can change them back to the server names for our company.

Is doing a comparison report for 2 weeks on the same report even possible? If so please help me!

Thanks in advance,

Becky

Asked 13 years ago 1648 views