cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sailer
Engaged Sweeper
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?
1 ACCEPTED SOLUTION
Nick_VDB
Champion Sweeper III
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

View solution in original post

2 REPLIES 2
sailer
Engaged Sweeper
Thanks for your help.

I also add the following line for all Apple Mac.

tsysAssetTypes.AssetTypename = 'Apple Mac'
Nick_VDB
Champion Sweeper III
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