cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Notonyourradar
Engaged Sweeper III
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?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

3 REPLIES 3
Hemoco
Lansweeper Alumni
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
Engaged Sweeper III
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
Lansweeper Alumni
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.