Aminns wrote:
I have been handed the task of finding all of our win 7 machines. Along with that i have to know the type of ram and processor to see if they are worth upgrading to win 10. Thanks for the help.
Hi, I think something like below would work for you. It shows OS, Memory, Processesor, Last Seen, Last Tried, and IP.
I've used something similar in the past so it wasn't hard to make a few changes to fit what you asked for. Hope this helps.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption,
tblAssets.Memory,
tblAssets.Processor,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblOperatingsystem On
tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblOperatingsystem.Caption Like '%Windows 7%' And tblAssetCustom.State = 1
