Software: All Installed Software by Location broken down further

[mattgbarnes]

Can anyone please create a report that breaks software down by location so we can see installed software numbers by location?

Thanks!!

[mattgbarnes]

Thanks, I tried that but you have to specify the software. I need a list of all software.

[MikeMc]

mattgbarnes wrote:
Thanks, I tried that but you have to specify the software. I need a list of all software.

You can remove the softwarename filter from my original query like below, but the report may take awhile to run depending on the number of assets and software scanned.

Select Top 1000000 T1.IPLocation,
  T1.softwareName As Software,
  T1.softwareVersion As Version,
  Count(T1.IPLocation) As SoftwareCount
From (Select Top 1000000 (Case
      When tsysIPLocations.IPLocation Is Not Null Then
      tsysIPLocations.IPLocation Else 'Undefined' End) As IPLocation,
    tblSoftwareUni.softwareName,
    tblSoftware.softwareVersion
  From tblAssets
    Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
    Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
      And tblAssets.IPNumeric <= tsysIPLocations.EndIP
    Inner Join tblSoftware On tblSoftware.AssetID = tblAssets.AssetID
    Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Where tblAssetCustom.State = 1) T1
Group By T1.IPLocation,
  T1.softwareName,
  T1.softwareVersion
Order By T1.IPLocation,
  Software,
  Version

[MikeMc]

Someone previously requested something similar, so check this thread out: http://www.lansweeper.com/Forum/yaf_postst13287_view-software-installed-by-location.aspx