→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ifm
Champion Sweeper
Hi!

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

\\Skalman
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
Daniel_B
Lansweeper Alumni
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
Lansweeper Alumni
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