Bulk Inventory Security Groups Creation using vRA + vRO + NSX-T REST API

-

 

Objective

Enable automated bulk creation of NSX-T Security Groups and VM membership assignment by uploading a .csv file through vRA catalog request.

This solution leverages:

  • vRA → For self-service catalog & request handling.

  • vRO → Workflow logic, parsing CSV, and REST API communication.

  • NSX-T REST API → To validate, create, and update Security Groups.

Input CSV Example

The CSV file contains the following columns:

SecurityGroupName,Criterion1,Criterion2

App-Frontend,VM.Name=web*,Tag=env:dev

App-Backend,VM.Name=app*,Tag=env:qa

DB-Servers,VM.Name=db*,Tag=env:prod


SecurityGroupName → Name of the NSX-T security group

Criterion1, Criterion2 → Membership conditions (VM names, Tags, IPs, etc.)


Workflow Logic

  1. vRA Catalog Request

    • User uploads CSV file with GroupName,Criterion1,Criterion2.

    • vRA triggers a vRO workflow via Event Subscription or custom catalog item.

  2. vRO Workflow Steps

    • Parse CSV file (using Properties or ResourceElement).

    • For each line:

      • Validate VM exists in NSX-T inventory via API.

      • Check if Security Group exists.

        • If yes → Add VM to the group with Criterion.

  3. REST API Calls to NSX-T Manager

    • GET /api/v1/fabric/virtual-machines → Validate VM in NSX inventory.

    • GET /policy/api/v1/infra/domains/default/groups → Validate existing groups.

    • PATCH /policy/api/v1/infra/domains/default/groups/<groupName> → Create/Update group with VM membership criteria.

  4. Update Status to vRA

    • Return result summary:

      • ✅ Groups created

      • ✅ VMs added

      • ❌ Any VM not found

Process Flow Diagram

Benefits

  • Bulk Automation: No manual clicks in NSX-T Manager.
  • Consistency: Security groups are created and updated following policy standards.
  • Scalability: Handle large CSV input (hundreds of VMs/groups).
  • Integration: Single-click request from vRA catalog.

Solution Approach

We’ll build a vRO workflow that:

  1. Reads the CSV input file.
  2. Iterates through each row.
  3. Prepares a REST API JSON payload for the NSX-T Security Group.
  4. Calls the NSX-T Policy API to create the Security Group with its criteria.
  5. Logs the success/failure of each creation.

Demo



Comments

Post a Comment

Popular posts from this blog

Creating Snapshots for Unmanaged VMs in Aria Automation (vRealize Automation)

-
Image
 In multi-tenant environments powered by Aria Automation (vRealize Automation) , it's common for tenants to occasionally request snapshots for unmanaged virtual machines (VMs) . These unmanaged VMs exist in vCenter but are not provisioned through vRA and therefore fall outside the standard automation lifecycle. To address this need without impacting the broader environment or other tenants, we implemented a dedicated catalog item that allows tenants to safely request snapshots for their unmanaged VMs— securely, in isolation, and with auditability . Here’s how we approached this solution using a custom workflow and catalog configuration in Aria Automation. The Challenge Tenants may operate legacy or externally imported VMs that are not managed via vRA’s provisioning engine. Creating snapshots for these VMs traditionally requires manual intervention from infrastructure teams, which: Increases support overhead Introduces potential human errors Offers ...
Read more

Bulk import security policies into Palo Alto Networks firewalls

-
Image
To bulk import security policies into Palo Alto Networks firewalls, you'll typically need to leverage the Palo Alto API or CLI with a script. I am using an Excel file (XLS), IP address validation, and mapping source and destination zones, for comprehensive solution to automate the process. 1. Input from XLSX File : You will first need to read the data from the XLS file. 2. Check for Existing Rules : Before creating new rules, you should check if similar rules already exist on the firewall. This could be done by comparing the rule names, source, and destination IPs, and zones. 3. Mapping Source Zone and Destination Zone : Ensure that the source and destination zones are correctly mapped according to your firewall configuration. 4. IP Address Validation : Before adding a rule, you'll need to validate that the IP addresses specified in the file are valid 📝  Flow Diagram  (Text Representation) Further Automation If you need enhancements or additional automation features , fee...
Read more

Automating Tag Creation & Assignment to VMs with vRA + vRO

-
Image
  Use Case Summary A user provisions a VM from vRA. Once the VM is deployed in vCenter , a vRO workflow is triggered via Event Broker subscription. The workflow: Checks if the Tag exists (using REST API to NSX-T). If not found, creates the Tag under the correct category. Assigns the Tag to the newly provisioned VM. This eliminates the need for manual intervention and ensures every VM is tagged correctly for policies, automation, and visibility . High-Level Flow VM Provisioning in vRA User requests VM with required details (e.g., Environment, Owner, Application). Event Broker Subscription After provisioning, vRA triggers a vRO workflow . vRO Workflow Actions Connects to vCenter using REST API. Checks if Tag exists. If exists → Skip creation. If not exists → Create new Tag under category. Assigns Tag to the VM. Result VM is provisioned with the right tags automatically applied . Flow Diagram Steps Start VM Prov...
Read more