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 Latest LsAgent version for Windows?
by  KevinA-REJIS  
Go to last post Go to first unread
Last post: Yesterday at 2:03:46 PM(UTC)
Lansweeper No incoming Mails after update 8.4.100.9
by  SB2021   Go to last post Go to first unread
Last post: Yesterday at 6:21:20 AM(UTC)
Lansweeper Assigned Assets
by  anpatterson03  
Go to last post Go to first unread
Last post: 7/29/2021 11:50:46 PM(UTC)
Lansweeper Troubleshooting Helpdesk
by  brodiemac-too   Go to last post Go to first unread
Last post: 7/29/2021 8:46:21 PM(UTC)
Lansweeper Make agents regular users
by  JP-CPC  
Go to last post Go to first unread
Last post: 7/29/2021 7:32:54 PM(UTC)
Lansweeper Lansweeper updates without stopping whole IIS service
by  Hstr   Go to last post Go to first unread
Last post: 7/29/2021 10:32:17 AM(UTC)
Lansweeper Active Directory Groups not scanned properly
by  SCH  
Go to last post Go to first unread
Last post: 7/29/2021 7:10:23 AM(UTC)