‎05-29-2013 02:56 AM
‎05-27-2021 12:29 PM
Select IprangeID,
(Cast(PARSENAME(ipend, 4) as bigint) - Cast(PARSENAME(Ipstart, 4) as bigint)) * 16777216 + (Cast(PARSENAME(ipend, 3) as bigint) - Cast(PARSENAME(Ipstart, 3) as bigint)) * 65536 + (Cast(PARSENAME(ipend, 2) as bigint) - Cast(PARSENAME(Ipstart, 2) as bigint)) * 256 + (Cast(PARSENAME(ipend, 1) as bigint) - Cast(PARSENAME(Ipstart, 1) as bigint)) * 1 as size,
Enabled,
Servername
from tsysIPScanRanges
‎05-27-2021 09:20 AM
‎06-03-2021 05:28 PM
Hendrik.VE wrote:
Hope this works..
‎02-16-2021 03:16 PM
Select Top 1000000 tsysIPLocations.IPLocation,
tsysIPLocations.PackageShare As Subnet,
tsysIPLocations.Realstart As StartIP,
tsysIPLocations.Realend As EndIP,
tsysIPLocations.ShareUsername As Contact,
Count(tblAssets.AssetID) As [used IP],
Case
When Right(tsysIPLocations.PackageShare, 2) = 24 Then 254
When Right(tsysIPLocations.PackageShare, 2) = 25 Then 126
When Right(tsysIPLocations.PackageShare, 2) = 26 Then 62
When Right(tsysIPLocations.PackageShare, 2) = 27 Then 30
When Right(tsysIPLocations.PackageShare, 2) = 28 Then 14
Else 6
End As [Max IPs],
tsysIPScanRanges.Description As [Subnet Description]
From tsysIPLocations
Left Join tblAssets On tsysIPLocations.LocationID = tblAssets.LocationID
Left Join tsysIPScanRanges On tsysIPLocations.Realstart =
tsysIPScanRanges.Ipstart
Where tsysIPLocations.Realstart Like '%10.99.%'
Group By tsysIPLocations.IPLocation,
tsysIPLocations.PackageShare,
tsysIPLocations.Realstart,
tsysIPLocations.Realend,
tsysIPLocations.ShareUsername,
tsysIPScanRanges.Description
Order By StartIP
IPLocation Subnet StartIP EndIP Contact usedIP Max IPs Subnet Description
AAN1-B520-19 10.99.137.224/28 10.99.137.225 10.99.137.238 Barry E 1 14 SA SERVER Network
AAN1-B520-40 10.99.136.0/26 10.99.136.1 10.99.136.62 Freddy J 7 62 PIMS Test Servers
AAN1-B520-39 10.99.131.0/26 10.99.131.1 10.99.131.62 Bico VDS 51 62 PIMS Production Servers
‎05-26-2021 11:41 PM
Hence, I imported all our subnets under Asset Groups/IP Address Range Locations. Because we don't use the deployment feature (we have other tools for that), we inserted the subnet (CIDR notation) under Package Share en Subnet Responsible (contact) under Share Username.
Additionally, I've added for every subnet IP Range Scanning with the corresponding start IP address, and the Subnet Description under Scanning Targets. Of course, 'Save pinged IP' is activated.
‎10-25-2017 04:03 PM
‎05-16-2017 06:06 PM
‎05-29-2013 04:48 PM
‎05-29-2013 04:36 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now