Need a custom report with Network details
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)?
How to fill information in last coloumn (static or dynamic IP)?
0 Comments
[ + ] Show comments
Answers (4)
Please log in to answer
Posted by:
GillySpy
13 years ago
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
A custom inventory rule would likely be in the form of a script that gathers this information on the client similar to this faq
Posted by:
divya_dogra
13 years ago
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.
I can see this information in Inventory, Network Interface heading. Not sure if can get this information directly from any table of KACE database.
Posted by:
GillySpy
13 years ago
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
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
Posted by:
divya_dogra
13 years ago
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.