Pull a report for network devices

sreejith93 · ‎07-06-2017

Hi Experts,

I have a requirement to fetch a report from CMDB based on the device type i.e Server , Switches , Routers ,UPS etc. I have successfully extracted report for Load Balancer, Server, PDU,UPS devices.

However I am unable to fetch report for Router, Switch & Firewall. Could you guys please help me out which table will help me to fetch this report out from CMDB.

Thanks in advance.

SJ

VivekSattanatha · ‎07-06-2017

Hi Sreejith,

Your Report is not in the way I created.

The condition which I mentioned is not directly a class.

When you select condition, you have to click the class field by this order.

Show related fields-->Nic >>Network adapter fields--> Configuration Item >>Configuration item fields --> Class.

Also in the Slush bucket, it is not Manufacturer.class, it should be Nic.Configuration_item.class.

also, If you don't mention any condition you can see all the 273K records.

Regards,

Vivek

View solution in original post

anjalichoudhary · ‎07-06-2017

Hi Sreejith,

You will get the Network related data in Network Gear (cmdb_ci_netgear) table.

If it helps please mark helpful !!

Thanks,

Anjali

sreejith93 · ‎07-06-2017

Nope that din't work. Doesn't list out all the network devices

Sharique Azim · ‎07-06-2017

in the table , can you filter base on classes and later group by classes?

sreejith93 · ‎07-06-2017

Did.. but grouping by class just groups by IP Address which is not my requirement