bava
asked on
DHCP Reports
Hi
l have a DHCP server and we configred for around 350 pc
and l have geting in DHCP server manager l am geting full
details of m/c like computer name and hardware address and
ip address . l want to take print out of that how can l get the print out of that database .it is not possible to go arround each pc and take it . please help on this
l have a DHCP server and we configred for around 350 pc
and l have geting in DHCP server manager l am geting full
details of m/c like computer name and hardware address and
ip address . l want to take print out of that how can l get the print out of that database .it is not possible to go arround each pc and take it . please help on this
It is a Msjet database but access will not beable to open it, even if it has a mdb extension. The 2 data formats are different.
shucks, it was worth a try.
ASKER
Hi
l took the DHCP.mdp database triyed to open in MS ACCESS but it not opening there
it tells it not a ms access database .. is it any other way to take print out of that database , or
any other utility to take print out
l took the DHCP.mdp database triyed to open in MS ACCESS but it not opening there
it tells it not a ms access database .. is it any other way to take print out of that database , or
any other utility to take print out
dhcpcmd from ResKit
what'S wrong with my answer?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
.. not the way a admin would do it :-[
ASKER
Hi
l am to understand rlesh answer please explain detail ,dhcpcmd from ResKit, for that l dont have reskit
l am to understand rlesh answer please explain detail ,dhcpcmd from ResKit, for that l dont have reskit
DHCP writes a log file of all assignments and renewals. But, the log is opened in exclusive mode by DHCP while active. To view or copy the log, you must stop DHCP services.
I have written a command file, like the one I posted as the answer. I use the AT command scheduler to run the command each week, late at night, when I expect no one is using the system. The command file:
Stops DHCP services: NET STOP DHCPSERVER
Renames the logfile: REN DHCPSRV.LOG DHCPSRV.001
Restarts DHCP: NET START DHCPSERVER
The whole process runs very fast. You can execute it as necessary to create a log.
I have written a command file, like the one I posted as the answer. I use the AT command scheduler to run the command each week, late at night, when I expect no one is using the system. The command file:
Stops DHCP services: NET STOP DHCPSERVER
Renames the logfile: REN DHCPSRV.LOG DHCPSRV.001
Restarts DHCP: NET START DHCPSERVER
The whole process runs very fast. You can execute it as necessary to create a log.
Here's something. The DHCP server uses an MS "Access-like" database. But here's the catch, if you open the current version of that database with Access you will undoubtedly corrupt it. So make a copy of the original and then open the copy. Print to your hearts desire. The file is called dhcp.mdb, and its in the \systemroot\system32\dhcp folder.
D
Remarks
-Remember to make a copy and work on the copied version--or you'll corrupt your original by opening it in MS Access.