LMS report with information from specific ports

[Guest]

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.

[Guest]

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.

[Guest]

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?

[Guest]

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.