→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Cristian_Blanco
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
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.

View solution in original post

3 REPLIES 3
WWFI-LUISL
Engaged Sweeper
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
Engaged Sweeper II
Thank you very much, that was exactly what I needed
RCorbeil
Honored Sweeper II
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.