How to Create CSV Files Containing Assets
4636
Created On 07/31/23 15:57 PM - Last Modified 08/11/23 17:41 PM
Environment
Customer Support Portal
Resolution
Overview
To generate a CSV file containing your portfolio of Palo Alto Networks assets, use CSP Account Selector to select a CSP account.
If you are a member of multiple CSP accounts, Account Selector displays a list of your CSP accounts; select the "current" account. If you are not a member of multiple CSP accounts, Account Selector displays your CSP account.
Then, go to CSP Assets page. To navigate to Assets page, select Products > Assets.
Account Wide Features - Download CSV
To create a CSV file containing assets in this CSP account, click Account Actions button in Assets page to see a drop-down menu of account-wide features. Select Download CSV.
NOTE: If your company is an Authorized Support Center (ASC) Partner, and you want to create a CSV file containing all assets for all of your ASC Customers (and not assets in your own ASC Partner account), go to the next section labelled Account Wide Features - Download CSV for ASC (Authorized Support Center).
CSP will then create a CSV file containing assets in your "selected current" CSP account.
The GUI widget to find your downloaded CSV file may differ, depending on your browser of choice. By default, the current Chrome browser displays the GUI widget in the lower left corner of your browser window (newer versions of Chrome may have use different GUI widgets). Click the GUI widget to access the downloaded CSV file. If you use a different browser, the GUI widget may be different.
Account Wide Features (Authorized Support Centers)
If your company is an Authorized Support Center (ASC) Partner, and you want to create a CSV file containing all assets for all of your ASC Customers, continue reading.
Keep in mind you must also be assigned CSP role ASC User to create a CSV file for ASCs. If you do not have role ASC User, ask your Super User to assign you role ASC User.
If you instead want to create a CSV file containing assets in your ASC Partner account, go to the previous section labelled Account Wide Features - Download CSV, after choosing your ASC Partner account using Account Selector.
Click Account Actions button in Assets page to see a drop-down menu of account-wide features. Select Download CSV for ASV. This feature scans all ASC Customer accounts for all assets supported by your ASC Partner company, and inserts these assets in the CSV file.
The GUI widget to find your downloaded CSV file may differ, depending on your browser of choice. By default, the current Chrome browser displays the GUI widget in the lower left corner of your browser window (newer versions of Chrome may have use different GUI widgets). Click the GUI widget to access the downloaded CSV file. If you use a different browser, the GUI widget may be different.
IMPORTANT NOTES:
- If your company is not an ASC Partner, CSP will not display menu Download CSV for ASC.
- If your company is an ASC Partner, CSP displays menu Download CSV for ASC in your ASC Partner CSP Account only if you are assigned CSP role ASC User. CSP does not display menu Download CSV for ASC when you are in other CSP accounts.
Format of Comma Separated Value (CSV) Files
The format of CSV files created in Assets page is identical, whether the CSV file is created for non-ASC accounts or ASC accounts.
The name of the CSV files is "AssetData_yyyymmdd.csv". If multiple CSV files are created on the same day, CSP adds a qualifier to the name, e.g., "Asset Data_20231103 (1).csv".
Keep in mind an asset may have multiple embedded licenses. For example, a PA-Series firewall may have five embedded CDSS licenses as well as a support license; these five CDSS licenses and one support licenses are listed in separate rows -- one row per CDSS and support license -- and mapped to the same product serial number.
How do you know which embedded licenses and support licenses belong to the same asset? Look in column D, "Serial #" for a common serial number that ties together the licenses described in the previous paragraph.
Row 1 in the CSV file contains column names. The following table lists each column name with brief descriptions.
CSV Column Descriptions
Column | Column Name | Description |
| A | CSP Acct Name | Name of CSP account where asset resides |
| B | CSP Acct # | CSP account number where asset resides |
| C | Entitlement Type | Type of license, either Tenant or Serial Number |
| D | Serial # | If field Entitlement Type equals Serial Number, use the serial number to identify the asset |
| E | Token ID | If field Entitlement Type equals Token, use the token ID to identify the asset |
| F | Asset SKU | SKU for the asset, note that add-on licenses may have additional SKUs |
| G | Asset Type | Type of asset, e.g., PA-Series for physical NGFWs, VM-Series for virtual NGFWs, Panorama, Prima Cloud, Cortex Data Lake, etc. Use the Add New Filter feature in Assets page to find assets by asset type. |
| H | Asset Model | Asset model for an asset type. For example, if Asset Type is PA-Series, Asset Model indicates PA-Series model, e.g., PA-4050. |
| I | Asset Name | Name assigned by customer to an asset. Note Asset Name can currently only be assigned to asset types PA-Series, VM-Series, CN-Series, Panorama, Prisma Access and Prisma SD-WAN asset types. |
| J | OS Version | Operating system version running in the asset. |
| K | License | License name of an add-on running in the asset, e.g., Wildfire, Threat Prevention, Global Protect. Use column D, Serial # to identify the host running an add-on license (a host may have many add-on licenses). |
| L | Auth Code | Auth code associated with an add-on license in column K. |
| M | Expiration | Expiration date of an add-on license in column K. |
| N | Platform | Platform hosting an asset. |
| O | CPU ID | CPU ID for an asset running on platform in column N. |
| P | UUID | UUID for an asset running on platform in column N. |
| Q | Authorized Support Center | If this asset is supported by an Authorized Support Center (ASC), this field contains the name of the ASC. |
| R | Address 1 | Address for the asset. |
| S | Address 2 | Address for the asset. |
| T | City | Address for the asset. |
| U | State/Region | Address for the asset. |
| V | Postal Code | Address for the asset. |
| W | Country | Address for the asset. |
| X | Support Type | Type of support for the asset, e.g., Standard, Premium |
| Y | Bundle Type | Type of bundle license, e.g., Active, Inactive (Future), Expired. |
| Z | License Type | Type of license in a bundle, Primary. |
| AA | License Description | Description of a license in a bundle. |
| AB | Start Date | Start date of a license in a bundle. |
| AC | Expiration Date | Expiration date of a license in a bundle. |
| AD | Region | Region for a license in a bundle. |
| AE | License Features | Describes license features in a bundle. |