Hello together,
i am looking for two similar reports (one for notebooks and one for desktops).
It has to contain the following values:
- Name
- User
- PurchaseDate
- Model
- Processor
- Memory (RAM)
- IPLocation
- Size of the HDD or/and SSD Volumes
The background for these report is the planned rollout of a new software with new hardware requirements.
I already built an report (for Mobile Devices, Chassis Type 8 and 9). But there are multiple entries in the output?
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Model,
tblAssets.Processor,
tblAssets.Memory,
tsysIPLocations.IPLocation,
tblAssets.IPAddress,
tblDiskdrives.Size,
tblDiskdrives.Volumename,
tblDiskdrives.Caption
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Where tblDiskdrives.DriveType = 3 And (TsysChassisTypes.Chassistype = '9' Or
TsysChassisTypes.Chassistype = '8') And tsysAssetTypes.AssetTypename Like
'Windows' And tblAssetCustom.State = 1 And (tblDiskdrives.Caption = 'C:' Or
tblDiskdrives.Caption = 'D:')
