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   [ + ] Show 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.

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
Answer this question or Comment on this question for clarity

Share