Ok so im trying to come up with a report to show if someone removes ram from a computer. I then though might want to show if memory was added. I figure if a machine was powered off, ram removed and not powered back on, it will not report in that memory is missing. But we would see a computer with added ram. Our machines come with all hardware including ram when they come in.
soooo any help would be appreciative. I do not really even know what tables show this...
NS 6.0 SP3 + R8 (going to R13 soon)
What I have so far will give me computers with memory sorted by modified date... is that enough? no way to know if a machine went from 2gb to 1gb......
So far I have
select *
from Inv_AeX_HW_Memory_Changes
where [Total Physical Memory] <> '0'
order by [last modified] desc