Table Definition - DHCPLease
Submitted by Synthetic Dreams on Fri, 08/15/2014 - 15:13
| Field | Type | Read-only | Description |
|---|---|---|---|
| ID | Integer | Yes | Primary Key (unique ID) for row |
| ScopeID | Integer | Yes | Foreign Key of parent scope |
| IP | Char | Yes* | IP address of lease. *Must be specified for INSERT statements |
| Hardware | Char | No | Hardware (MAC) address of lease in hexadecimal. Must be specified for INSERT statements |
| Name | Char | No | Name. Must be specified for INSERT statements |
| Comment | Char | No | Comment/Description |
| Expiration | Timestamp | No | Expiration date of lease. NULL indicates inactive reservation. 0000-00-0000 00:00:00 indicates active reservation/infinite lease |
| Owner | Char | Yes | DHCP server where lease resides |
| Type | Char | Yes | Lease type ("None", "DHCP", "BOOTP", etc) |
| Reservation | Integer | No | Lease is a reservation (0 = No, 1 = Yes). UPDATE statements changing 1 to 0 will cause the lease to be deleted |
Usage Notes
- INSERT and DELETE statements run against the 'DHCPLease' table will create and delete DHCP leases on the target server, respectively
- The appropriate scope (address and mask) must exist to create a lease
- As noted, the 'IP', 'Hardware', 'Name' fields must be specified, at minimum, for INSERT statements. Any non read-only field may also be specified in INSERT statements to be applied to newly created leases
