cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
lbutler
Engaged Sweeper
The software license compliance view doesn't appear to pick up any of our Macs.
We use a lot of Microsoft office365 products and it's not been picked up. They are mostly installed on our Mac machines.

I've enabled SSH on each of the Macs and added the credentials to /Configuration/Credentials
I've re-run the scan and it's still not picking them up even though I can see in the asset type that all Macs are registered.

Can someone advise why the Macs aren't showing in the software license compliance screen?
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
Moved this from the Actions center to Lansweeper Questions. Please note that the Actions center is for posting finished Lansweeper actions, not questions.

Your question was received and answered via email as well:
The license compliance module only supports Windows computers for now. Linux/Mac support is on our customer wish list, but we do not have a release date for this feature. To get a count of software packages installed on Linux/Mac, you can build custom reports for now. Sample reports can be seen below. You can submit software names in the parts of the queries we've highlighted.

Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:
  • Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
  • Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder.

Linux report

Select Top 1000000 tblSoftwareUni.softwareName,
tblLinuxSoftware.Version As softwareVersion,
Count(tblAssets.AssetID) As Count
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblLinuxSoftware.SoftwareUniID
Where tblAssetCustom.State = 1
Group By tblSoftwareUni.softwareName,
tblLinuxSoftware.Version
Having tblSoftwareUni.softwareName In ('name software 1', 'name software 2')


Mac report

Select Top 1000000 tblSoftwareUni.softwareName,
tblMacApplications.Version as softwareVersion,
Count(tblAssets.AssetID) As Count
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblMacApplications
On tblAssets.AssetID = tblMacApplications.AssetID
Inner Join tblSoftwareUni On tblMacApplications.softid = tblSoftwareUni.SoftID
Where tblAssetCustom.State = 1
Group By tblSoftwareUni.softwareName,
tblMacApplications.Version
Having tblSoftwareUni.softwareName In ('name software 1', 'name software 2')

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
Moved this from the Actions center to Lansweeper Questions. Please note that the Actions center is for posting finished Lansweeper actions, not questions.

Your question was received and answered via email as well:
The license compliance module only supports Windows computers for now. Linux/Mac support is on our customer wish list, but we do not have a release date for this feature. To get a count of software packages installed on Linux/Mac, you can build custom reports for now. Sample reports can be seen below. You can submit software names in the parts of the queries we've highlighted.

Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:
  • Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
  • Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder.

Linux report

Select Top 1000000 tblSoftwareUni.softwareName,
tblLinuxSoftware.Version As softwareVersion,
Count(tblAssets.AssetID) As Count
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblLinuxSoftware.SoftwareUniID
Where tblAssetCustom.State = 1
Group By tblSoftwareUni.softwareName,
tblLinuxSoftware.Version
Having tblSoftwareUni.softwareName In ('name software 1', 'name software 2')


Mac report

Select Top 1000000 tblSoftwareUni.softwareName,
tblMacApplications.Version as softwareVersion,
Count(tblAssets.AssetID) As Count
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblMacApplications
On tblAssets.AssetID = tblMacApplications.AssetID
Inner Join tblSoftwareUni On tblMacApplications.softid = tblSoftwareUni.SoftID
Where tblAssetCustom.State = 1
Group By tblSoftwareUni.softwareName,
tblMacApplications.Version
Having tblSoftwareUni.softwareName In ('name software 1', 'name software 2')