3 weeks ago
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
Solved! Go to Solution.
2 weeks ago
2 weeks ago
Thanks for the feedback @PoWen_Cheng also 'accept as solution' if that answers the original query
2 weeks ago - last edited 2 weeks ago
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
2 weeks ago
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
2 weeks ago
Try hint
Where tsysIPLocations.IPLocation In (N'台中后科廠11', N'台中后科廠22')
2 weeks ago
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
2 weeks ago
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
2 weeks ago - last edited 2 weeks ago
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',...)
2 weeks ago
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now