Report not working

[JasonBDM]

Good Morning

I introduce myself, am Jason Colimalay from Mauritius
We recently bought a premium license.

I creating reports on the software am facing issues that every time i have to do the first run to scan our different ip range. i dont know how to scan an own ip range.

2.when am creating reports it is detecting more than 100000 equipment when i create the report to find on a specific IP range the

IPAddress, Displayname user, Model, Memory, Processor, Serialnumber, Ostype eg (Windows 7 windows xp),


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tblAssetCustom.Model,
tblADusers.Displayname,
tblAssets.Memory,
tblAssets.Mac,
tblAssetCustom.Serialnumber,
tblOperatingsystem.OSType
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblADusers On tblAssets.Username = tblADusers.Username
Inner Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
And tblAssetCustom.State = 1

[Hemoco]

Your first question is not clear for us.


For your second question.
You can use the following report. If you want to filter on IP ranges then we recommend that you use IP locations. You can read how to configure IP locations on the page 118 of our documentation.You can download our documentation from: http://www.lansweeper.com/Download.aspx


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tblAssetCustom.Model,
tblADusers.Displayname,
tblAssets.Memory,
tblAssets.Mac,
tblAssetCustom.Serialnumber,
tblOperatingsystem.OSType,
tsysIPLocations.IPLocation
From tblAssets
Inner Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblADusers On tblAssets.Username = tblADusers.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tsysIPLocations.IPLocation = 'ip location' And tblAssetCustom.State = 1

If you have any further questions on this report please send them to support@lansweeper.com