How to Create CSV Files Containing Assets

How to Create CSV Files Containing Assets

2936
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.

 

Screenshot 2023-07-31 at 9.26.31 AM.png


Then, go to CSP Assets page.  To navigate to Assets page, select Products > Assets.

 
Screenshot 2023-07-31 at 9.12.14 AM.png


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).

 
Screenshot 2023-07-31 at 9.17.10 AM.png

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.

 
Screenshot 2023-07-31 at 9.37.48 AM.png



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: 
  1. If your company is not an ASC Partner, CSP will not display menu Download CSV for ASC.
  2. 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.  
 
Screenshot 2023-07-31 at 9.46.39 AM.png
 


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 NameDescription
ACSP Acct Name
Name of CSP account where asset resides
 
BCSP Acct #
CSP account number where asset resides
 
C
Entitlement Type
Type of license, either Tenant or Serial Number
DSerial #
If field Entitlement Type equals Serial Number, use the serial number to identify the asset
 
EToken ID
If field Entitlement Type equals Token, use the token ID to identify the asset
 
FAsset SKU
SKU for the asset, note that add-on licenses may have additional SKUs
 
GAsset 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.

 
HAsset 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.
 
IAsset 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.
 
JOS Version
Operating system version running in the asset.
 
KLicense
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).
 
LAuth Code
Auth code associated with an add-on license in column K.
 
MExpiration
Expiration date of an add-on license in column K.
 
NPlatform
Platform hosting an asset.
 
OCPU ID
CPU ID for an asset running on platform in column N.
 
PUUID
UUID for an asset running on platform in column N.
 
QAuthorized Support Center
If this asset is supported by an Authorized Support Center (ASC), this field contains the name of the ASC.
 
RAddress 1
Address for the asset.
 
SAddress 2
Address for the asset.
 
TCity
Address for the asset.
 
UState/Region
Address for the asset.
 
VPostal Code
Address for the asset.
 
WCountry
Address for the asset.
 
XSupport Type
Type of support for the asset, e.g., Standard, Premium
 
YBundle Type
Type of bundle license, e.g., Active, Inactive (Future), Expired.
 
ZLicense Type
Type of license in a bundle, Primary.
 
AALicense DescriptionDescription of a license in a bundle.
ABStart Date
Start date of a license in a bundle.
 
ACExpiration Date
Expiration date of a license in a bundle.
 
ADRegion
Region for a license in a bundle.
 
AELicense FeaturesDescribes license features in a bundle.
 

 


Actions
  • Print
  • Copy Link

    https://knowledgebase.paloaltonetworks.com/KCSArticleDetail?id=kA14u000000XfsXCAS&refURL=http%3A%2F%2Fknowledgebase.paloaltonetworks.com%2FKCSArticleDetail

Choose Language