Unable to Update Database

Unable to Update Database

How to monitor DHCP scope?

The DHCP scope monitoring OIDs are present in the DHCP mib.Hence the following DHCP mib and MSFT mib has to be placed in the OpManager\mibs folder.Find them attached in this KB article.

The OIDs are .1.3.6.1.4.1.311.1.3.2.1.1.3 for FREE IPs and .1.3.6.1.4.1.311.1.3.2.1.1.2 for IN USE IPs in a network address

Verifying the OIDs

Run the mibbrowser.bat in the OpManager\bin folder and load the DHCP mib.

Fill the details of the HOST,community with the details of the DHCP server

Paste the OID for FREE IPs in the ObjectID field and click on Operations -> Get

If you get the output of the FREE IPs available in every network in the DHCP pool,create custom SNMP monitors using the procedure in the how-to link below

https://www.manageengine.com/network-monitoring/custom-SNMP-monitors.htm

As you can see the OIDs above are numeric as well as tabular hence they give output for multiple networks in every poll.

Updating changes in Database

Once you have created the SNMP monitors (Free IPs and IN USE IPs) in the Windows template and applied it to servers,type the following in the browser

http://OpManager server:port/SubmitQuery.do

Paste and run the following query after inputting the DHCP server name and DHCP monitor name.

update polleddata set saveabsolutes='true' where name like '%DHCP monitor name%' and agent like '%DHCP server name%'


Note : After performing all above steps Database is unable to Update but in MIB Browser i am able to fetch output value & the same is unable in Templates kinldy provide a way.

Showing Error: You are not authorized to execute this query on admin account as well.


              New to ADManager Plus?

                New to ADSelfService Plus?