Report for Apple/Mac

[ifm]

Hi!

I Need to a report who summary:
All software installed on an Apple hardware.

\\Skalman

[Daniel_B · Accepted solution]

For a summary with count of software installations per software name and version, use the following report:

Select Top 1000000 tblSoftwareUni.SoftwarePublisher,
  tblSoftwareUni.softwareName,
  tblMacApplications.Version,
  Count(tblAssets.AssetID) As Count
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblMacApplications
    On tblAssets.AssetID = tblMacApplications.AssetID
  Inner Join tblSoftwareUni On tblMacApplications.softid = tblSoftwareUni.SoftID
Where tblAssetCustom.State = 1
Group By tblSoftwareUni.SoftwarePublisher,
  tblSoftwareUni.softwareName,
  tblMacApplications.Version
Order By tblSoftwareUni.softwareName

[Daniel_B]

In order to generate a report on Mac software, you'll need to add tables tblMacApplications and tblSoftwareUni to your report, like the following example:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblSoftwareUni.SoftwarePublisher,
  tblSoftwareUni.softwareName,
  tblMacApplications.Version,
  tblMacApplications.InstallDate
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblMacApplications
    On tblAssets.AssetID = tblMacApplications.AssetID
  Inner Join tblSoftwareUni On tblMacApplications.softid = tblSoftwareUni.SoftID
Where tblAssetCustom.State = 1