/build/static/layout/Breadcrumb_cap_w.png

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)?

0 Comments   [ + ] Show comments

Answers (4)

Posted by: GillySpy 12 years ago
7th Degree Black Belt
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
Posted by: divya_dogra 12 years ago
Orange Belt
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.
Posted by: GillySpy 12 years ago
7th Degree Black Belt
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
Posted by: divya_dogra 12 years ago
Orange Belt
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ