Chirs Medico
New member
- Local time
- Today, 06:59
- Joined
- Sep 21, 2004
- Messages
- 5
Hello,
I'm working on generating a report that will summarize our network IPs.
I'm trying to make groups in the report but keep the IP addresses sequential. Also I want to show the first and last IP of a common group and not have a large report taken up by "unassigned" or "DHCP" IP addresses.
I've included some data and the jist of what I'm trying to accomplish with the report. I hope it makes sense.
Any help would be greatly appreciated!
Chris
The data looks like this:
Key Description IP
1 Network ID 10.143.72.0
2 Do not use 10.143.72.1
3 Router 10.143.72.2
4 Firewall 10.143.72.3
5 HSRP 10.143.72.4
6 MSFC1 10.143.72.5
7 MSFC2 10.143.72.6
8 Medico's PC 10.143.72.7
9 Medico's Webcam 10.143.72.8
10 Unassigned 10.143.72.9
11 Unassigned 10.143.72.10
12 Unassigned 10.143.72.11
13 Unassigned 10.143.72.12
14 Unassigned 10.143.72.13
15 Unassigned 10.143.72.14
16 Unassigned 10.143.72.15
17 Unassigned 10.143.72.16
18 Unassigned 10.143.72.17
19 Unassigned 10.143.72.18
20 Unassigned 10.143.72.19
21 Unassigned 10.143.72.20
22 Unassigned 10.143.72.21
23 Unassigned 10.143.72.22
24 Unassigned 10.143.72.23
25 Unassigned 10.143.72.24
26 Unassigned 10.143.72.25
27 Unassigned 10.143.72.26
28 Unassigned 10.143.72.27
29 Unassigned 10.143.72.28
30 Unassigned 10.143.72.29
31 Unassigned 10.143.72.30
32 Ted's PC 10.143.72.31
33 Unassigned 10.143.72.32
34 Unassigned 10.143.72.33
35 Unassigned 10.143.72.34
36 Unassigned 10.143.72.35
37 Unassigned 10.143.72.36
38 Unassigned 10.143.72.37
39 Unassigned 10.143.72.38
40 Unassigned 10.143.72.39
41 Unassigned 10.143.72.40
42 Unassigned 10.143.72.41
43 Unassigned 10.143.72.42
44 Unassigned 10.143.72.43
45 Unassigned 10.143.72.44
46 DHCP 10.143.72.45
47 DHCP 10.143.72.46
48 DHCP 10.143.72.47
49 DHCP 10.143.72.48
50 DHCP 10.143.72.49
51 Unassigned 10.143.72.50
52 Unassigned 10.143.72.51
53 Unassigned 10.143.72.52
54 Unassigned 10.143.72.53
55 DHCP 10.143.72.54
56 DHCP 10.143.72.55
I want the report to look like this:
Description IP
Network ID 10.143.72.0
Do not use 10.143.72.1
Router 10.143.72.2
Firewall 10.143.72.3
HSRP 10.143.72.4
MSFC1 10.143.72.5
MSFC2 10.143.72.6
Medico's PC 10.143.72.7
Medico's Webcam 10.143.72.8
Unassigned 10.143.72.9 - 10.143.72.30
Ted's PC 10.143.72.31
Unassigned 10.143.72.32 - 10.143.72.44
DHCP 10.143.72.45 - 10.143.72.49
Unassigned 10.143.72.50 - 10.143.72.53
DHCP 10.143.72.54 - 10.143.72.55
I'm working on generating a report that will summarize our network IPs.
I'm trying to make groups in the report but keep the IP addresses sequential. Also I want to show the first and last IP of a common group and not have a large report taken up by "unassigned" or "DHCP" IP addresses.
I've included some data and the jist of what I'm trying to accomplish with the report. I hope it makes sense.

Any help would be greatly appreciated!
Chris
The data looks like this:
Key Description IP
1 Network ID 10.143.72.0
2 Do not use 10.143.72.1
3 Router 10.143.72.2
4 Firewall 10.143.72.3
5 HSRP 10.143.72.4
6 MSFC1 10.143.72.5
7 MSFC2 10.143.72.6
8 Medico's PC 10.143.72.7
9 Medico's Webcam 10.143.72.8
10 Unassigned 10.143.72.9
11 Unassigned 10.143.72.10
12 Unassigned 10.143.72.11
13 Unassigned 10.143.72.12
14 Unassigned 10.143.72.13
15 Unassigned 10.143.72.14
16 Unassigned 10.143.72.15
17 Unassigned 10.143.72.16
18 Unassigned 10.143.72.17
19 Unassigned 10.143.72.18
20 Unassigned 10.143.72.19
21 Unassigned 10.143.72.20
22 Unassigned 10.143.72.21
23 Unassigned 10.143.72.22
24 Unassigned 10.143.72.23
25 Unassigned 10.143.72.24
26 Unassigned 10.143.72.25
27 Unassigned 10.143.72.26
28 Unassigned 10.143.72.27
29 Unassigned 10.143.72.28
30 Unassigned 10.143.72.29
31 Unassigned 10.143.72.30
32 Ted's PC 10.143.72.31
33 Unassigned 10.143.72.32
34 Unassigned 10.143.72.33
35 Unassigned 10.143.72.34
36 Unassigned 10.143.72.35
37 Unassigned 10.143.72.36
38 Unassigned 10.143.72.37
39 Unassigned 10.143.72.38
40 Unassigned 10.143.72.39
41 Unassigned 10.143.72.40
42 Unassigned 10.143.72.41
43 Unassigned 10.143.72.42
44 Unassigned 10.143.72.43
45 Unassigned 10.143.72.44
46 DHCP 10.143.72.45
47 DHCP 10.143.72.46
48 DHCP 10.143.72.47
49 DHCP 10.143.72.48
50 DHCP 10.143.72.49
51 Unassigned 10.143.72.50
52 Unassigned 10.143.72.51
53 Unassigned 10.143.72.52
54 Unassigned 10.143.72.53
55 DHCP 10.143.72.54
56 DHCP 10.143.72.55
I want the report to look like this:
Description IP
Network ID 10.143.72.0
Do not use 10.143.72.1
Router 10.143.72.2
Firewall 10.143.72.3
HSRP 10.143.72.4
MSFC1 10.143.72.5
MSFC2 10.143.72.6
Medico's PC 10.143.72.7
Medico's Webcam 10.143.72.8
Unassigned 10.143.72.9 - 10.143.72.30
Ted's PC 10.143.72.31
Unassigned 10.143.72.32 - 10.143.72.44
DHCP 10.143.72.45 - 10.143.72.49
Unassigned 10.143.72.50 - 10.143.72.53
DHCP 10.143.72.54 - 10.143.72.55