How customized display of specific Active Directory Domain assets

[PoWen_Cheng]

Hi everyone, My LANSWEEPER has two Active Directory Domains. I want to add a new tab to the Dashboard. How can I display the asset information of only one of the Active Directory Domains in this new tab or widgets? Can it be customized? Thanks

Standard and Custom Fields Active Directory view New Tabs/Companies 

[Mercedes_O]

Thanks for the feedback @PoWen_Cheng also 'accept as solution' if that answers the original query

[Mister_Nobody]

Firstly, tsysIPLocations.IPLocation is name of IP-location which you defined in the section "IP Address Range locations" on page /configuration/AssetGroups/. 

So I can recommend give name by DCHP Scopes or campus/building/floor

You can add WHERE  at the end of query for tsysIPLocations.IPLocation

If you want compare IP then you must add own decoder to convert different type of IP format in LS

example of decoder:

 tsysIPLocations.startip <= Right('000' +
      IsNull(ParseName(tsysIPScanRanges.Ipend, 4), ''), 3) + Right('000' +
      IsNull(ParseName(tsysIPScanRanges.Ipend, 3), ''), 3) + Right('000' +
      IsNull(ParseName(tsysIPScanRanges.Ipend, 2), ''), 3) + Right('000' +
      IsNull(ParseName(tsysIPScanRanges.Ipend, 1), ''), 3) And
      Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 4), ''), 3) +
      Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 3), ''), 3) +
      Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 2), ''), 3) +
      Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 1), ''), 3) <=
      tsysIPLocations.endip

[PoWen_Cheng]

HI Mister_Nobody,

I'm a newbie so I'm not familiar with it. I modified it myself and added a line, but the query showed no results. Did I add the wrong place or parameters? Thanks

Select Top 1000000 tsysIPLocations.IPLocation,
tsysIPLocations.Realstart,
tsysIPLocations.Realend,
(Select Distinct COUNT(*)
From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID =
tblAssetCustom.AssetID
Where tblAssetCustom.State = 1 And tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP)
As TotalAssets
From tsysIPLocations
Where tsysIPLocations.IPLocation In ('台中后科廠11', '台中后科廠22')
Order By TotalAssets

[Mister_Nobody · Accepted solution]

Try hint

Where tsysIPLocations.IPLocation In (N'台中后科廠11', N'台中后科廠22')

[PoWen_Cheng]

HI Mister_Nobody,

Thank you. This line of CODE is valid and can be queried. I would like to ask how to modify this REPORT so that the result of the query is only the computer assets of CFP Active Directory Domains? Thanks

[Mister_Nobody]

try this

Select Top 1000000 tsysIPLocations.IPLocation,
  tsysIPLocations.Realstart,
  tsysIPLocations.Realend,
  (Select Distinct COUNT(*)
    From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID =
          tblAssetCustom.AssetID
    Where tblAssetCustom.State = 1 And tblAssets.domain = 'your_domain' And
      tblAssets.IPNumeric >= tsysIPLocations.StartIP And tblAssets.IPNumeric <=
      tsysIPLocations.EndIP) As TotalAssets
From tsysIPLocations
Where tsysIPLocations.IPLocation In ('IPL1', 'IPL2')
Order By TotalAssets

[Mister_Nobody]

1. No solution for domain list.

2. You can create report for locations and add it as Data report.

For example,

Select Top 1000000 tsysIPLocations.IPLocation,
  tsysIPLocations.Realstart,
  tsysIPLocations.Realend,
  (Select Distinct COUNT(*)
    From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID =
          tblAssetCustom.AssetID
    Where tblAssetCustom.State = 1 And tblAssets.IPNumeric >=
      tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP)
  As TotalAssets
From tsysIPLocations
Order By TotalAssets

and filter by

where tsysIPLocations.IPLocation in ('IPL1','IPL2',...)

[PoWen_Cheng]

HI Mister_Nobody,

Thank you for your REPORT, but I don’t know where to modify the filtering IP conditions. I want the specific section, for example, I want to query 10.1.1.1-10.1.1.250, 10.1.2.1-10.1.2.250, 10.1.3.1-10.1. 3.250, 10.1.4.1-10.1.4.250, 10.1.5.1-10.1.5.250

How to modify the asset report? Thanks