
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-29-2016 03:33 PM
We are a school district with over 200 schools. I am compiling a report of all of the Windows Primary Domain Controllers in our district. However I would like to be able to change the report to only show assets from certain regions within the district. We have each schools IP ranges specified as an Asset Group under IP Address Range Locations. Looking for a way to use the Location Name (or Asset Group Name) to only show the assets for a set of schools within a specific region in the school district.
i.e. only show assets for schools whose Location Name (Asset Group name/IP Address Range Location) start with CR
Here is the report I have so far that shows all of the Windows Primary Domain Controllers for the entire district:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblComputersystem.Lastchanged,
tsysOS.Image As icon,
tblAssets.IPAddress
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.Domainrole = 5 And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
i.e. only show assets for schools whose Location Name (Asset Group name/IP Address Range Location) start with CR
Here is the report I have so far that shows all of the Windows Primary Domain Controllers for the entire district:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblComputersystem.Lastchanged,
tsysOS.Image As icon,
tblAssets.IPAddress
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.Domainrole = 5 And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-31-2016 01:45 PM
This forum topic explains how to correctly link the tsysIPLocations table that stores IP location information to the tblAssets table. Once you've linked the table and ticked the IPLocation field, you can add the following filter to the Criteria column of the field:
Keep in mind that this is standard SQL syntax, not specific to Lansweeper. If you are interested in building or modifying reports, we do recommend:
Like 'CR%'
Keep in mind that this is standard SQL syntax, not specific to Lansweeper. If you are interested in building or modifying reports, we do recommend:
- Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
- Making use of our database dictionary, more information on which can be found here. The dictionary explains in great detail what each table and field stores.
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-31-2016 02:47 PM
This worked, thanks so much for your help!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-31-2016 01:45 PM
This forum topic explains how to correctly link the tsysIPLocations table that stores IP location information to the tblAssets table. Once you've linked the table and ticked the IPLocation field, you can add the following filter to the Criteria column of the field:
Keep in mind that this is standard SQL syntax, not specific to Lansweeper. If you are interested in building or modifying reports, we do recommend:
Like 'CR%'
Keep in mind that this is standard SQL syntax, not specific to Lansweeper. If you are interested in building or modifying reports, we do recommend:
- Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
- Making use of our database dictionary, more information on which can be found here. The dictionary explains in great detail what each table and field stores.
