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.
