Report - Showing Last Weeks Disk Usage and This Weeks for a Comparison?
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
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 '%
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
Answers (2)
Please log in to answer
Posted by:
cblake
13 years ago
Here's the report forum: http://www.appdeploy.com/messageboards/tt.asp?forumid=39
I'd ask there as well.
I'd ask there as well.
Posted by:
dchristian
13 years ago
Off the top of my head the biggest problem with this is we're not storing the historical data.
If you wanted to do some kind of weekly comparison, the "old" info would need to be saved some where.
Maybe assets would be a good place.
A help desk rule could be setup to run on a schedule that would take a "snapshot" of the disks.
Then a report could compare what was in the historical asset location to the real time machine_disk table.
Problem with this is, since assets get generated on the fly, this would need to be custom for each kbox implemtation.
I think it would work though.
If you wanted to do some kind of weekly comparison, the "old" info would need to be saved some where.
Maybe assets would be a good place.
A help desk rule could be setup to run on a schedule that would take a "snapshot" of the disks.
Then a report could compare what was in the historical asset location to the real time machine_disk table.
Problem with this is, since assets get generated on the fly, this would need to be custom for each kbox implemtation.
I think it would work though.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
