LMS report with information from specific ports

Answered Question
Aug 28th, 2009
User Badges:

Hi,

I need a report from Campus Manager or RME where I could see the status from some specific ports that I have to choose.

Is there any report preconfigured that I can use? I don't find anything that can help me...

Or is it possible to define a report with these requirements?

Many thanks.

Correct Answer by Joe Clarke about 7 years 8 months ago

Yes, this is possible with the new direct database access in LMS 3.2. See http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html#wp67348 for a list of available port attributes. With direct access, you can build your own reports using SQL to extract exactly the information required.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
Joe Clarke Fri, 08/28/2009 - 08:53
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

You mean link up/down status? There is the Port Attributes report in Campus Manager which shows all of the port details such as status, VLAN, trunk status, etc. The report is found under Campus Manager > Reports > Report Generator.

cmartinvalle Mon, 08/31/2009 - 01:19
User Badges:

We're using this Port Attributes report now but it shows too much information for our customer.

We would like a report like this but only with the information of some ports that we would choose because we only want to know the status from some important ports, not from all of them.

Is this possible?

Correct Answer
Joe Clarke Mon, 08/31/2009 - 10:20
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

Yes, this is possible with the new direct database access in LMS 3.2. See http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html#wp67348 for a list of available port attributes. With direct access, you can build your own reports using SQL to extract exactly the information required.

Actions

This Discussion