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: 4
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
gabrielo
#1gabrielo Member Posts: 1  
posted: 6/16/2021 3:17:24 PM(UTC)
Hello. This is the script I use

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
RTrim(SubString(tblMacOSInfo.ComputerName, CharIndex(' de ',
tblMacOSInfo.ComputerName, 0) + 4, 25)) As Usuario,
tblAssetCustom.Serialnumber,
tsysAssetTypes.AssetTypeIcon10 As icon,
SubString(tblAssetCustom.Model, 0, PatIndex('%[0-9]%', tblAssetCustom.Model))
As Modelo,
RTrim(SubString(tblAssetCustom.Model, PatIndex('%[0-9]%',
tblAssetCustom.Model), 5)) As Version,
Case
When ((SubString(tblAssetCustom.Model, 0, PatIndex('%[0-9]%',
tblAssetCustom.Model)) Like '%iMac%' And
RTrim(SubString(tblAssetCustom.Model, PatIndex('%[0-9]%',
tblAssetCustom.Model), 5)) < '14,1') Or
(SubString(tblAssetCustom.Model, 0, PatIndex('%[0-9]%',
tblAssetCustom.Model)) Like '%Macmini%' And
RTrim(SubString(tblAssetCustom.Model, PatIndex('%[0-9]%',
tblAssetCustom.Model), 5)) < '6,2') Or
(SubString(tblAssetCustom.Model, 0, PatIndex('%[0-9]%',
tblAssetCustom.Model)) Like '%MacPro%' And
RTrim(SubString(tblAssetCustom.Model, PatIndex('%[0-9]%',
tblAssetCustom.Model), 5)) < '6,1') Or
(SubString(tblAssetCustom.Model, 0, PatIndex('%[0-9]%',
tblAssetCustom.Model)) Like '%MacBook%' And
RTrim(SubString(tblAssetCustom.Model, PatIndex('%[0-9]%',
tblAssetCustom.Model), 5)) < '8,1') Or
(SubString(tblAssetCustom.Model, 0, PatIndex('%[0-9]%',
tblAssetCustom.Model)) Like '%MacBookAir%' And
RTrim(SubString(tblAssetCustom.Model, PatIndex('%[0-9]%',
tblAssetCustom.Model), 5)) < '5,2') Or
(SubString(tblAssetCustom.Model, 0, PatIndex('%[0-9]%',
tblAssetCustom.Model)) Like '%MacBookPro%' And
RTrim(SubString(tblAssetCustom.Model, PatIndex('%[0-9]%',
tblAssetCustom.Model), 5)) < '10,2')) Then 'NO'
Else 'SI'
End As [Actualizable (BigSur) ?],
tblMacOSInfo.KernelVersion,
tblMacHwOverview.Memory As [Memoria RAM],
SubString(tblMacPartitions.Size, 0, PatIndex('%G%', tblMacPartitions.Size)) As
Disco,
tblAssets.Processor,
tblAssets.Lastseen
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 lansweeperdb.dbo.tblMacOSInfo On tblAssets.AssetID =
tblMacOSInfo.AssetID
Inner Join lansweeperdb.dbo.tblMacHwOverview On tblAssets.AssetID =
tblMacHwOverview.AssetID
Inner Join lansweeperdb.dbo.tblAssetCustom tblAssetCustom1 On
tblAssets.AssetID = tblAssetCustom1.AssetID
Inner Join lansweeperdb.dbo.tblMacPartitions On tblAssets.AssetID =
tblMacPartitions.AssetID
Where tblMacPartitions.MountedOn Like '%/' And tsysAssetTypes.AssetTypename =
'Apple Mac' And tblAssetCustom.State = 1
Order By tblAssets.AssetID,
tblAssets.AssetName

Active Discussions

Lansweeper Monitor history showing only last monitors
by  cross_eur   Go to last post Go to first unread
Last post: 7/23/2021 6:06:51 PM(UTC)
Lansweeper Report Login time reduces number of computers by 300
by  cross_eur  
Go to last post Go to first unread
Last post: 7/23/2021 6:05:42 PM(UTC)
Lansweeper Merging 2 reports
by  Apaulcolypse   Go to last post Go to first unread
Last post: 7/22/2021 10:02:59 PM(UTC)
Lansweeper HELP - Add Registry Key Values to Asset Report
by  Apaulcolypse  
Go to last post Go to first unread
Last post: 7/22/2021 9:26:43 PM(UTC)
Lansweeper Can I request a custom report here?
by  Brian G   Go to last post Go to first unread
Last post: 7/22/2021 7:20:56 PM(UTC)
Lansweeper List all users with E-mail address
by  Brandon  
Go to last post Go to first unread
Last post: 7/21/2021 7:06:36 PM(UTC)
Lansweeper Identifying users of Windows legacy authentication
by  Baronet   Go to last post Go to first unread
Last post: 7/21/2021 5:26:38 PM(UTC)
Lansweeper Windows Version different between reports
by  RC62N  
Go to last post Go to first unread
Last post: 7/21/2021 3:27:04 PM(UTC)