cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
leblanc_daniel_
Engaged Sweeper III
Hello,

I think these will be hard report to create or not, i need to know all the application installed on computer that have Windows 7 of all model of that os?

Thansk you again alot!!

Dan
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
I've posted a sample report below.
Select Top 1000000 tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
Count(tblSoftware.AssetID) 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
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1 And tsysOS.OSname = 'win 7'
Group By tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher
Order By Total Desc

View solution in original post

4 REPLIES 4
Susan_A
Lansweeper Alumni
This information is already included in the report. The Total column is the software installation count for Windows 7 machines.
leblanc_daniel_
Engaged Sweeper III
Is there a way to add how many times the application is installed in win7?

Thanks you again.

Dan
leblanc_daniel_
Engaged Sweeper III
Thank you,Thank you,Thank you,Thank you,Thank you,Thank you,Thank you,Thank you,Thank you,Thank you,Thank you,Thank you,Thank you,Thank you,Thank you,Thank you,Thank you,

Dan
Susan_A
Lansweeper Alumni
I've posted a sample report below.
Select Top 1000000 tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
Count(tblSoftware.AssetID) 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
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1 And tsysOS.OSname = 'win 7'
Group By tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher
Order By Total Desc