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
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

Answer this question or Comment on this question for clarity