Apple Mac hardware report

[sailer]

Hello, I need a report (AssetName; IP Adress; Model; Processor; Memory; OS; Serial) about our Apple Macs from a special ip range (192.168.123.1 to 192.168.123.254) because we have more subnets.

Can somebody help me please?

[sailer]

Thanks for your help.

I also add the following line for all Apple Mac.

tsysAssetTypes.AssetTypename = 'Apple Mac'

[Nick_VDB · Accepted solution]

You can use the report below to get back the information you need. Instructions for adding this report to your Lansweeper installation can be found in this post.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tblAssets.IPAddress,
  tblAssetCustom.Model,
  tblAssetCustom.Manufacturer,
  tblMacMemory.Size As Memory,
  tblMacOSInfo.SystemVersion,
  tblMacOSInfo.KernelVersion,
  tblAssetCustom.Serialnumber,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssets.IPNumeric
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
  Left Join tblMacMemory On tblAssets.AssetID = tblMacMemory.AssetID
Where tblAssets.IPNumeric >= 192168123001 And tblAssets.IPNumeric <=
  192168123254 And tblAssets.IPNumeric >= 192168123001 And
  tblAssets.IPNumeric <= 192168123254 And tblAssetCustom.State = 1