→ 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: 
sudhakar
Engaged Sweeper
Hello,
I have created IP locations groups and want to generate report IP locations wise,

While generating report single IP showing multiple IP locations groups

Please help me how to create the report.

Regards,
Sudhakar
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please try the following:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Order By tsysIPLocations.IPLocation,
tblAssets.IPNumeric

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
Please try the following:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Order By tsysIPLocations.IPLocation,
tblAssets.IPNumeric