Need to get group interface listings

Products

• CA Performance Management - Usage and Administration

Issue/Introduction

 need to list/print out group interfaces to an excel spreadsheet.  Using querybuilder I can list the interfaces but I do not get the device they are on in the listing? 

How can I add both the device and interface so that I can capture it? 

Environment

Release : 20.2

Component :

Cause

Query was configured with group as the endpoint, which only contained interfaces

Resolution

Reconfigure query in querybuilder as follows

 

1. Choose interface end point, all interfaces.

2. Then choose select ID and Name

3. Then expand to device then choose primaryipaddress and name for device

4. Then add filter and choose group/Name, and enter group name.

5. Run.

You should now have a list which includes one interface name and device name per column