/bundles/itninjaweb/img/Breadcrumb_cap_w.png
I need to create custom report with machine name, IP address, and whether IP is static or DHCP enabled.
How to fill information in last coloumn (static or dynamic IP)?
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity

Answers

0
You would either have to have some custom inventory rule that stores whether DHCP is enabled on the client or not or if your DHCP addresses fall within a range then you could tell the report about that range.

A custom inventory rule would likely be in the form of a script that gathers this information on the client similar to this faq
Answered 06/10/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Thanks Gillispie. Since I am quite new to Dell KACe, would appreciate if you can provide any link/doc with steps to achieve the same.
I can see this information in Inventory, Network Interface heading. Not sure if can get this information directly from any table of KACE database.
Answered 06/10/2011 by: divya_dogra
Orange Belt

Please log in to comment
0
If you see it in inventory then you can get to it in reporting. For some fields it would have to be a custom report.

In this case you would have to join MACHINE to MACHINE_NICS via the MACHINE ID and IP address then you would have MACHINE_NICS.DHCP_ENABLED='True' when DHCP is on.
e.g

SELECT M.IP,M.NAME, MN.DHCP_ENABLED FROM MACHINE M JOIN MACHINE_NICS MN ON M.ID=MN.ID and MN.IP=M.IP
ORDER BY M.ID DESC
Answered 06/10/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Thanks Gllispie. That worked for me. Would appreciate if you can share the schema of KACE database, so that we can get desired table names and cloumn names by having a look at it.
Answered 06/13/2011 by: divya_dogra
Orange Belt

Please log in to comment