DHCP, Task: Capture DHCP services scope usage statistics

Task: Capture DHCP services scope usage statistics

Purpose

The following activity captures empirical data on DHCP service utilization. This data, which is collected daily (or multiple times a day) should be reviewed weekly. It will also be used to create monthly reports that are reviewed quarterly for SLA/OLA compliance. Service utilization statistics are different from system performance in that they measure the usage characteristics of the DHCP service, not the underlying infrastructure such as disk, memory, or processor.

Procedure Option 1: Capture DHCP services scope usage statistics using DHCP management console

This collection should be performed on a consistent schedule, during key times of the day such as 08:00, 12:00, and 17:00. The information should be recorded in a log file with the date appended to the name, such as “DHCPScopeStats_200305.csv” (indicates a comma-separated log for the month of May 2003).

1. Start the DHCP management console by clicking the Start menu, then click Run and type dhcpmgmt.msc. Click OK.
2. If the appropriate DHCP server is not listed on the tree view on the left:

   a. Right-click DHCP (the first item), and select Add Server.

   b. Enter the hostname for the appropriate DHCP server or select from the authorized list and click OK.

3. Double-click the appropriate DHCP server on the tree view in the left pane.
4. Click [+] to expand Superscopes (if any) and select the scope from which to collect statistics.
5. Right-click the scope, and select Display Statistics.
6. Open the month’s csv log using WordPad and manually record the data as follows:

   “DATE TIME”,”DHCPServer Name”,”Scope IP”,”Total Addresses”,”IPs in Use”,“IPs Available”
   For example:
   05/24/2003 16:58:00.000,sea_dhcpsvr01,192.168.12.0,200,140,60
   05/24/2003 16:59:00.000,sea_dhcpsvr02,192.168.13.0,200,10,190
   

Procedure Option 2: Capture DHCP services scope usage statistics using Netsh command line utility

This collection should be performed on a consistent schedule, during key times of the day, such as 08:00, 12:00, and 17:00. The information should be recorded in a log file with the date appended to the name, such as “DHCPScopeStats_200305.csv” (indicates a comma separated log for the month of May 2003). Enterprise environments with many DHCP servers can adopt this option into a parsing script feeding a SQL Server database.

1. Open a command shell by clicking the Start menu. Click Run, type cmd and click OK.
2. Type the netsh command:

   Netsh DHCP Server \\<servername> show mibinfo where you replace <servername> with the name of an authorized DHCP server.

   
   
3. Open the month’s csv log using WordPad and manually record the data as follows:

   “DATE TIME”,”DHCPServer Name”,”Scope IP”,”Total Addresses”,”IPs in Use”, “IPs Available”
   For example:
   05/24/2003 16:58:00.000,sea_dhcpsvr01,192.168.12.0,200,140,60
   05/24/2003 16:59:00.000,sea_dhcpsvr02,192.168.13.0,200,10,190

Dependencies

None

Technology Required

Base DHCP Windows Server 2003