K1000 Report on Old Data
I would like to run a report on what free drive space my test lab had a few weeks back. I could also see this being a good thing to report what a PC had installed before a hard drive died.
Thanks
1 Comment
[ + ] Show comment
-
Do you have a label for this lab? If not, I would suggest doing that to make it easier. And, of course, if there's any way to make it a smart label rather than manual label (maybe IP range?) do that since it is a best practice. - JasonEgg 7 years ago
Answers (2)
Please log in to answer
Posted by:
chucksteel
7 years ago
I don't think that this data is kept by default. What are your asset history settings for Computers?
Comments:
-
3 months - DLCurtis 7 years ago
-
There are options for which fields to track, are you tracking disk space? - chucksteel 7 years ago
-
I have all of the options turned on/checked.
Looks like that is the default as I have not been in this area before - DLCurtis 7 years ago
-
So if you want any info further than 3 months back you'll have to extend that window. You say "a few weeks back" in your post. What does that mean? 2 weeks? 3? A month? - JasonEgg 7 years ago
Posted by:
chucksteel
7 years ago
I ran the following query to see if the disk usage is kept historically and it doesn't look like it is:
SELECT * FROM ORG1.ASSET_HISTORY
WHERE FIELD_NAME = "MACHINE_DISKS"
and NAME like "testlab%"
and CHANGE_TYPE = "Usage"
ORDER BY TIME
Change the computer name to match your test lab machine names to see if the results are different. Although I am keeping history for disks, I only get one result per machine, so there is not historical information on disk usage there.
Comments:
-
I will give this a try. Thanks - DLCurtis 7 years ago
