→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SebastianR7
Engaged Sweeper
Is there a report that will show the OS version running on just Macintosh?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Mac OS data is stored in tblMacOSInfo. A sample report can be seen below.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblMacOSInfo.SystemVersion,
tblAssets.Firstseen,
tblAssets.Lastseen,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Order By tblAssets.IPNumeric

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
Mac OS data is stored in tblMacOSInfo. A sample report can be seen below.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblMacOSInfo.SystemVersion,
tblAssets.Firstseen,
tblAssets.Lastseen,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Order By tblAssets.IPNumeric

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now