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.
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
