Filtering and exporting data from NIOS (1504)

Scenario

Your team has added a new Extensible Attribute (EA) called Building to the NIOS Grid. Many objects have been updated with this data. Your manager asked you to send her a list of all the networks in the Building London Branch. Please use the filter and export functions in NIOS to generate this list.

Estimate Completion Time

  • 20 to 30 minutes

Credentials

Description

Username

Password

URL or IP

Grid Manager UI

ops

infoblox

https://10.100.0.100/

Requirements

  • Read-only access to Grid

Learning Content

Lab Initiation

Access jump-desktop

Once the lab is deployed, you can access the virtual machines required to complete this lab activity. To initiate the lab, click on the jump-desktop tile and login to the Linux UI:

image-20231130-134540.png

Username: training

Password: infoblox

Initiate lab

To initiate the lab, double-click the Launch Lab icon on the Desktop.

Launch Lab
Launch Lab

Choose the lab number from the list and click OK.

image-20231122-140156.png

After clicking OK, you will see a pop-up message with a brief description of the lab task. If the description looks correct, click Yes to continue lab initiation.

image-20231122-140739.png

Lab initiation will take a couple of minutes to finish.

Once complete, you will see another pop-up message with the login credentials and the URL for the Grid Manager’s User Interface. Note that the credentials may differ from those from prior labs.

Screenshot 2024-05-06 at 3.16.57 PM.png


Tasks

Task 1: Displaying networks with city column and exporting results

Login to the GM web interface. Ensure the column Building is visible for the network objects, then create a filter to display only networks in the Building London Branch. Use the CSV export function to export all visible data as CSV.



Solutions

Task 1 Solution: Displaying networks with Building column and exporting results

Login to the GM web interface. Ensure the new column Building is visible for the network objects, then create a filter to display only networks in the Building London Branch. Use the CSV export function to export all visible data as CSV.

Displaying Building column

  1. Login to NIOS GM web interface

  2. Navigate to Data ManagementIPAM . In any of the columns, click the drop-down menu and select Columns → Edit Columns.

    Screenshot 2023-07-19 at 10.50.42 AM.png
  3. Scroll down to find the Building Column and check the box to make it Visible
    1504 Solutions Task 1 - 2.png

  4. Click Apply to save changes to the workspace

Creating a filter for networks in London Branch

  1. Login to NIOS GM web interface

  2. Navigate to Data ManagementIPAM
    1504 Solutions Task 1 - 3.png

  3. Click Show Filter to see filter options
    1504 Solutions Task 1 - 4.png

  4. Create a filter using the logic of Building equals London Branch
    1504 Solutions Task 1 - 5.png

  5. Apply the filter

Exporting visible data in CSV format

  1. Click Export button and choose Export visible data
    1504 Solutions Task 1 - 6.png
    Read the warning message and click Start
    1504 Solutions Task 1 - 7.png

  2. Once the export finishes, click Download
    1504 Solutions Task 1 - 8.png

  3. The exported file can be viewed in text and spreadsheet applications
    1504 Solutions Task 1 - 9.png