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

VivekSattanatha · ‎07-06-2017

Also, If you take a report on cmdb_ci_hardware table then you can get all kind of hardware's like Servers, Network components altogether.

Regards,

Vivek

sreejith93 · ‎07-06-2017

I did that seems to be correct but the type of asset doesn't showup like Router, Switch etc

Below is the screenshot

VivekSattanatha · ‎07-06-2017

Try to add the Class attribute in the slush bucket.

sreejith93 · ‎07-06-2017

yupp.. That solved my initial query.. but one more query why is it showing only 100k records in the cmdb_ci_hardware table while cmdb_ci_ip_address has around approx 273k entries.

Any idea?

VivekSattanatha · ‎07-06-2017

Hi Sreejith,

Then your report should be on cmdb_ci_ip_address table like below

Regards,

Vivek

Based on the impact hit like, helpul or correct