Memory Upgrade

[Cristian_Blanco]

Hi,
I am trying to create a report, similar to Memory Upgrade Report, but I want it to show me all the computers, not just the one that can be upgraded.
My idea is to see, the assetname, OSname, Model, MaxCapacity, Memory, Slots used, Slots available and Slots free.
This is the SQL I have, I would like to add the missing data

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tsysOS.OSname,
tblAssetCustom.Model,
tblAssets.Lastseen,
tsysOS.Image As icon,
tblAssets.Memory,
tblPhysicalMemoryArray.MemoryDevices
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblPhysicalMemoryArray On tblAssets.AssetID =
tblPhysicalMemoryArray.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName

[WWFI-LUISL]

Tried the same thing it did not work for me can you send me the report or paste it completely. That way i can paste it and run it ?
this would be so helpful been trying to crack it down for one week already

Thanks

[Cristian_Blanco]

Thank you very much, that was exactly what I needed

[RCorbeil · Accepted solution]

Since you say that the Memory Upgrade report has most of what you want, why not start with that? Copy the query to a new report, remove the condition that limits the results to machines with empty memory slots

Where
  (tblPhysicalMemoryArray.MemoryDevices - CorrectMemory.Used > 0)
  And (tblPhysicalMemoryArray.[Use] = 3
  And tblAssetCustom.State = 1)

becomes

Where
  (tblPhysicalMemoryArray.[Use] = 3
  And tblAssetCustom.State = 1)

and add the extra fields you want.