Find RAM Memory Changes Made to Devices
Find out which devices had memory changes with this history report. Keeping track of hardware changes can be a tedious, manual task. When Lansweeper detects a change in RAM, it will keep track of what changes were made, removing the need to manually keep records for RAM changes. Aside from viewing changes, it can also be used for physical security. When RAM memory magically disappears, you can consult Lansweeper when memory changes were detected.
Click to Open - Computer Memory Changes Query
Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, Case tblPhysicalMemoryHist.Action When 1 Then 'Added' When 2 Then 'Removed' End As Action, tblPhysicalMemoryHist.DeviceLocator, Ceiling(tblPhysicalMemoryHist.Capacity / 1024 / 1024) As MB, TsysMemorytypes.MemoryName, tblPhysicalMemoryHist.Lastchanged From tblAssets Inner Join tblPhysicalMemoryHist On tblAssets.AssetID = tblPhysicalMemoryHist.AssetID Inner Join TsysMemorytypes On tblPhysicalMemoryHist.MemoryType = TsysMemorytypes.Memorytype Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Where tblAssetCustom.State = 1 Order By tblPhysicalMemoryHist.Lastchanged Desc, tblAssets.AssetID, tblPhysicalMemoryHist.DeviceLocator