Select Top 1000000 tblSoftwareUni.softwareName As Software, tblSoftware.softwareVersion As Version, tblSoftwareUni.SoftwarePublisher As Publisher, tsysIPLocations.IPLocation, 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 Left Outer Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP Where tblAssetCustom.State = 1 Group By tblSoftwareUni.softwareName, tblSoftware.softwareVersion, tblSoftwareUni.SoftwarePublisher, tsysIPLocations.IPLocation Order By Software, Version, tsysIPLocations.IPLocation
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.Domain, tblSoftwareUni.softwareName As software, tblSoftware.softwareVersion As version, tblSoftwareUni.SoftwarePublisher As publisher, tsysOS.Image As icon, tsysIPLocations.IPLocation 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 tblAssets.OScode = tsysOS.OScode Left Outer Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP Where tblAssetCustom.State = 1 Order By tsysIPLocations.IPLocation, tblAssets.AssetName, tblSoftwareUni.softwareName, tblSoftware.softwareVersion
Archive
This board contains archived posts from the retired Lansweeper Forum and Insiders Community.