Notification

Icon
Error

Dynamic group in query

Posted: Wednesday, June 24, 2015 10:27:18 AM(UTC)
EStarshinov

EStarshinov

Member Original PosterPosts: 17
0
Like
This issue has been solved! Click here to view the solution
I'm create Dynamic Group "MSK" consisting of a lists ip addresses and same other parameters. May i use it in report query?
Daniel.B
#1Daniel.B Member Posts: 1,150  
posted: 6/25/2015 1:56:28 PM(UTC)
Using Dynamic Asset groups for reports is not possible. In fact, through custom reports you can do everything what you can do with dynamic asset groups (plus much more). If you would like to filter on IP addresses, create a report like the following examples:
Code:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssets.IPAddress In ('192.168.10.1', '192.168.10.5', '192.168.10.6')

Code:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssets.IPNumeric Between 192168010005 And 192168010010

Code:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysIPLocations
    On tblAssets.IPNumeric Between tsysIPLocations.StartIP And
    tsysIPLocations.EndIP
Where tsysIPLocations.IPLocation = 'Example IP location'
EStarshinov
#2EStarshinov Member Original PosterPosts: 17  
posted: 6/25/2015 2:02:04 PM(UTC)
All clear, thanks for examples!

Active Discussions

Lansweeper Server software history
by  mjbliss  
Go to last post Go to first unread
Last post: 10/22/2021 10:22:03 AM(UTC)
Lansweeper WinRAR 5.70
by  Esben.D   Go to last post Go to first unread
Last post: 10/22/2021 10:01:08 AM(UTC)
Lansweeper error in SSD or HDD Audit
by  Borek  
Go to last post Go to first unread
Last post: 10/22/2021 9:02:22 AM(UTC)
Lansweeper Chrome 95 Audit
by  Esben.D  
Go to last post Go to first unread
Last post: 10/21/2021 11:14:31 AM(UTC)
Lansweeper Detecting and Reporting on Programs in Apps & Features
by  LANGuy  
Go to last post Go to first unread
Last post: 10/18/2021 6:09:11 PM(UTC)