cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
gdavid
Champion Sweeper
Which table do I have to add to get a software report on mac os software?

Is there a known way to report on java installed on both mac and windows?

Is there a way to report on both windows and mac software in a single report?


thanks

Gd.
1 REPLY 1
Hemoco
Lansweeper Alumni
gdavid wrote:
Which table do I have to add to get a software report on mac os software?

A sample report can be seen below.
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblSoftwareUni.softwareName,
tblMacApplications.Version,
tblMacApplications.InstallDate,
tblMacApplications.LastChanged
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblMacApplications
On tblAssets.AssetID = tblMacApplications.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblMacApplications.softid
Order By tblAssets.AssetUnique,
tblSoftwareUni.softwareName

gdavid wrote:
Is there a known way to report on java installed on both mac and windows?

You will have to create two reports for this, one for Windows and one for Mac.

gdavid wrote:
Is there a way to report on both windows and mac software in a single report?

You would have to create a union query for this, which is not easy.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now