Zscaler CSV

This guide explains how to export Zscaler data for devices and software into CSV files.

Objective

The Zscaler connector allows you to export IT infrastructure information into CSV files generated by PowerShell commands. These files are then integrated via a CSV connector on our platform.

Prerequisites

• Administrative access to Zscaler.
• PowerShell installed on the administrator's machine.
• Necessary permissions to execute PowerShell commands and access Zscaler information.

Steps to Generate CSV Files

Devices (endpoints/terminals)

In Device Management page > Enrolled Devices > Device Overview > Export.

• Include the following fields:
  • All device details fields.
  • Custom device details fields (User, OS Type, Device Model, OS Version, and VPN State).
  • Disable Reasons
  • Service status

Software

In Inventory > Software Inventory > Export with the following fields:

• Device
• User
• Software version
• Vendor
• OS
• Location
• Install Date
• Version history

Export Configuration

Device Export Fields

When exporting device information, ensure the following data is included:

Basic Device Information:

• Device ID and Name
• User associated with the device
• Operating System Type and Version
• Device Model and Manufacturer
• Last seen/connection timestamp

Security and Compliance:

• VPN connection state
• Security policy compliance status
• Device enrollment status
• Service status (active/inactive)

Management Information:

• Disable reasons (if applicable)
• Management agent version
• Location information (if available)

Software Inventory Export

The software inventory should capture:

Application Details:

• Software name and version
• Vendor/Publisher information
• Installation date and history
• License information (if available)

Device Association:

• Associated device and user
• Operating system where installed
• Installation location/path

Data Processing

1. Export Preparation

1. Access the Zscaler admin console
2. Navigate to the appropriate section (Device Management or Inventory)
3. Configure export filters if needed
4. Select all required fields for export

2. CSV Generation

1. Initiate the export process
2. Download the generated CSV files
3. Verify data completeness and accuracy
4. Prepare files for connector integration

3. Data Validation

• Ensure all required fields are present
• Verify data format consistency
• Check for any missing or corrupted entries
• Validate date formats and special characters

Information to provide in OverView

To configure the Zscaler CSV connector, please provide:

1. Device Export CSV: Complete device inventory with all specified fields
2. Software Export CSV: Software inventory with installation and version details
3. Export Schedule: Frequency of data updates (daily, weekly, etc.)
4. Data Delivery Method: How CSV files will be transferred (SFTP, email, etc.)

Troubleshooting

Common Export Issues

• Incomplete Data: Verify all required fields are selected before export
• Permission Errors: Ensure your account has necessary permissions for device and software inventory access
• Large File Sizes: Consider filtering or segmenting large exports for easier processing

Data Quality Checks

• Verify device counts match expected inventory
• Check for duplicate entries or missing devices
• Validate software installation dates and versions
• Ensure user associations are correct

For any questions or additional assistance, please contact our technical support team.

# Upload a file to the zscaler bucket
aws s3 cp devices.csv s3://zscaler/devices.csv --profile ovs_your_org

# Or sync a whole local folder
aws s3 sync ./exports/ s3://zscaler/ --profile ovs_your_org

import boto3

s3 = boto3.client(
    "s3",
    endpoint_url="https://s3.oversoc.com",
    region_name="fr-par",
    aws_access_key_id="YOUR_ACCESS_KEY",
    aws_secret_access_key="YOUR_SECRET_KEY",
)

# Push the export into the zscaler bucket
s3.upload_file("devices.csv", "zscaler", "devices.csv")