Notification

Icon
Error

Report: All Apple Mac devices with Memory RAM asset - Report: All Apple Mac devices with Memory RAM asset

Posted: Thursday, March 4, 2021 8:19:19 PM(UTC)
QueryLSTech

QueryLSTech

Member Original PosterPosts: 2
0
Like
Hey, I do have a report to scan all Macbooks devices, which works great but when I've tried to add tblAssets.Memory it doesnt show anything, any suggestions?! Storage HD size would be great to have too.

Thanks.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Serialnumber,
tblAssets.Memory,
tsysAssetTypes.AssetTypename As Type,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssetCustom.PurchaseDate As PurchaseDate,
tblAssetCustom.Warrantydate As WarrantyExpiration
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
Where tsysAssetTypes.AssetTypename = 'Apple Mac' And tblAssetCustom.State = 1
Order By tblAssets.AssetID,
tblAssets.AssetName

Active Discussions

Report Center Hardware Inventory
by  Cori   Go to last post Go to first unread
Last post: 4/16/2021 4:05:02 PM(UTC)
Lansweeper Windows Activation
by  Hendrik.VE  
Go to last post Go to first unread
Last post: 4/16/2021 4:01:47 PM(UTC)
Lansweeper Microsoft True Up: Licenses combined with AD
by  swaelti  
Go to last post Go to first unread
Last post: 4/15/2021 12:25:41 PM(UTC)
Lansweeper Cisco Duo and associated registry keys
by  dhoward   Go to last post Go to first unread
Last post: 4/15/2021 12:30:14 AM(UTC)
Lansweeper Calls closed within SLA
by  TimHolmes1973   Go to last post Go to first unread
Last post: 4/13/2021 5:25:38 PM(UTC)
Lansweeper Report that ties O365 Group Member to Asset?
by  Chrisy Mullins  
Go to last post Go to first unread
Last post: 4/13/2021 1:34:26 PM(UTC)