OSX Software in Reports

[Notonyourradar]

Currently doing an inventory of all premium Adobe products and even though I can see our OSX computers with software from adobe on a scan page it does not show up in reporting, nor is the software when viewed on the OSX computer's asset page can't be clicked on. Are we not able to report OSX software in reports?

[Hemoco · Accepted solution]

Can you please try to use the following report:

Select Top 1000000 tblSoftwareUni.softwareName As Software,
Count(tblSoftware.SoftwareID) + Count(tblMacApplications.AssetID) As Total
From tblAssets
Left Join tblSoftware On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tblMacApplications On tblAssets.AssetID = tblMacApplications.AssetID
And tblMacApplications.softid = tblSoftwareUni.SoftID
Where (tblSoftwareUni.softwareName Like N'%Acrobat Pro 10.0 %') Or
(tblSoftwareUni.softwareName Like N'%Acrobat Std 10.0%') Or
(tblSoftwareUni.softwareName Like N'%Adobe%' And tblAssetCustom.State = 1)
Group By tblSoftwareUni.softwareName
Order By Total Desc,
Software

[Notonyourradar]

Hate to be a bother, but how would this start for example looking for a count of Adobe products on OSX machines? Also would it be possible to get the count of adobe products joined with Windows counts? My current report code (product abridged):

 Select Top 1000000 tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  Count(tblSoftware.SoftwareID) As Total
From tblSoftware
  Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where (tblSoftwareUni.softwareName Like N'%Acrobat Pro 10.0 %') Or
  (tblSoftwareUni.softwareName Like N'%Acrobat Std 10.0%') Or
  (tblSoftwareUni.softwareName Like N'%Adobe%') And
    tblAssetCustom.State = 1))
Group By tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion
Order By Total Desc,
  Software 

[Hemoco]

You can find the scaned software from mac devices in the table tblmacaplications. You will need to make a custom report if you want to put this data in a report.