‎01-14-2015 01:38 AM
Solved! Go to Solution.
‎01-16-2015 01:47 PM
Select Top 1000000 OSKeys.IPLocation,
Count(OSKeys.ProductKey) As [OS Keys]
From (Select Distinct Top 1000000 tblSerialnumber.ProductKey,
tsysIPLocations.IPLocation
From tblSerialnumber
Inner Join tblAssets On tblAssets.AssetID = tblSerialnumber.AssetID
Inner Join tsysIPLocations
On tblAssets.IPNumeric Between tsysIPLocations.StartIP And
tsysIPLocations.EndIP
Where tblSerialnumber.Product Like '%Windows%') OSKeys
Group By OSKeys.IPLocation
‎01-30-2015 12:13 PM
‎01-29-2015 07:57 PM
‎01-29-2015 03:34 PM
Select Top 1000000 OSKeys.IPLocation,
OSKeys.CountOSKeys As [OS Keys],
OfficeKeys.CountOfficeKeys As [Office Keys]
From (Select Distinct Top 1000000 Count(tblSerialnumber.ProductKey) As
CountOSKeys,
tsysIPLocations.IPLocation
From tblSerialnumber
Inner Join tblAssets On tblAssets.AssetID = tblSerialnumber.AssetID
Inner Join tsysIPLocations
On tblAssets.IPNumeric Between tsysIPLocations.StartIP And
tsysIPLocations.EndIP
Where tblSerialnumber.Product Like '%Windows%'
Group By tsysIPLocations.IPLocation) OSKeys
Left Join (Select Distinct Top 1000000 Count(tblSerialnumber.ProductKey) As
CountOfficeKeys,
tsysIPLocations.IPLocation
From tblSerialnumber
Inner Join tblAssets On tblAssets.AssetID = tblSerialnumber.AssetID
Inner Join tsysIPLocations
On tblAssets.IPNumeric Between tsysIPLocations.StartIP And
tsysIPLocations.EndIP
Where tblSerialnumber.Product Like '%Office%'
Group By tsysIPLocations.IPLocation) OfficeKeys On OSKeys.IPLocation =
OfficeKeys.IPLocation
Order By OSKeys.IPLocation
‎01-26-2015 08:05 PM
‎01-16-2015 01:47 PM
Select Top 1000000 OSKeys.IPLocation,
Count(OSKeys.ProductKey) As [OS Keys]
From (Select Distinct Top 1000000 tblSerialnumber.ProductKey,
tsysIPLocations.IPLocation
From tblSerialnumber
Inner Join tblAssets On tblAssets.AssetID = tblSerialnumber.AssetID
Inner Join tsysIPLocations
On tblAssets.IPNumeric Between tsysIPLocations.StartIP And
tsysIPLocations.EndIP
Where tblSerialnumber.Product Like '%Windows%') OSKeys
Group By OSKeys.IPLocation
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now