How can I achieve this scenario with NCM

adecisco1

I need to develop a template that will give me the detail below:

1. In Single VLAN, how many ports are configured/used in whole environment.

I will appreciate any clue to this.

Thanks.

Find more posts tagged with

ncm

Accepted answers

All comments

mrxinu

If you have inventories running you should be able to pull that right out of the database with a report. Try the query below in a report (or Custom Query resource) of type SWQL:

SELECT EntityID, VLANID, VLANName, VLANMTU, VLANType, VLANState, NodeID, LastDiscovery, FirstDiscovery, MissingFROM NCM.VLANs

To get a count of each VLAN:

SELECT VLANID, COUNT(1) AS QtyFROM NCM.VLANsGROUP BY VLANID

Sample output:

Steven W. Klassen

Programmer Analyst @ Loop1 Systems

http://www.loop1systems.com/

http://www.linkedin.com/in/mrxinu

adecisco1

Thank you so much for this insight. It there a way I could add third column to contain interfaces assigned to the vlan across the environment?

Your input is really appreciate.

regards,

mrxinu

You're very welcome. Give this one a try:

SELECT n.NodeCaption, n.AgentIP, i.InterfaceName, i.VLANIDFROM NCM.Nodes nLEFT JOIN NCM.Interfaces i ON n.NodeID = i.NodeID

Steven W. Klassen

Programmer Analyst @ Loop1 Systems

http://www.loop1systems.com/

http://www.linkedin.com/in/mrxinu

adecisco1

Can you assist on why I am having an empty report after I have run download job?

Or am I missing any steps?

Thanks.

mrxinu

Did you run the inventory job? I believe that's where this information comes from.

Steven W. Klassen

Programmer Analyst @ Loop1 Systems

http://www.loop1systems.com/

http://www.linkedin.com/in/mrxinu

adecisco1

Thanks I was able to get out this..

I also need this to include non forwarding interface i.e both administrative down interfaces and non connected interfaces.

Any help on this?

Thanks for your time.

mrxinu

What query produced what you've got there?

Steven W. Klassen

Programmer Analyst @ Loop1 Systems

http://www.loop1systems.com/

http://www.linkedin.com/in/mrxinu

adecisco1

Here is something close to what I am looking for. I used web builtin report. But it read no activity to report. Any ideal why?

Regards,

christopher.a.thornton

I would check the Data source and see if the rule is there correctly. Below is a screenshot of what is should look like, though it should be this as default. I believe the report also runs off of the configs in NCM so if your nodes do not have a backed up copy of the configuration that may be why there is no activity to report. Can you check in your NCM instance and see if you have any configs back up?