What are the exact columns that we need to include when importing directory assets using CSV file? Can you please provide a sample? Thanks.
- Products
- Solutions
- Resources
- Trials
- Support
- Partners
- Communities
What are the exact columns that we need to include when importing directory assets using CSV file? Can you please provide a sample? Thanks.
Hi Aalaa,
It may be easier to add an Active Directory Asset using the + button under Assets if you are only adding a single forest.
Since there are different options based on what your requirements are, there isn't a common template for everyone but you need at least the following columns to start:
AssetPartitionName
ConnectionProperties.ServiceAccountDomainName
ConnectionProperties.ServiceAccountCredentialType
ConnectionProperties.ServiceAccountName
ConnectionProperties.ServiceAccountPassword
Name
NetworkAddress
PlatformDisplayName
ProfileName
Thanks!
Hi Tawfiq,
Thanks for your reply.
We have already added an Active Directory asset. What we want to do is importing bulk of domain Windows Servers/Desktops using a CSV file instead of discovering them. And we want to specify a domain account as a service account for those servers in the csv. So, are the mentioned columns are sufficient to accomplish this? And if so, can you please populate them with a dummy data to clarify what should be written in each one of them?
Thanks again!
Hi Tawfiq,
Thanks for your reply.
We have already added an Active Directory asset. What we want to do is importing bulk of domain Windows Servers/Desktops using a CSV file instead of discovering them. And we want to specify a domain account as a service account for those servers in the csv. So, are the mentioned columns are sufficient to accomplish this? And if so, can you please populate them with a dummy data to clarify what should be written in each one of them?
Thanks again!
Hi Aalaa,
For Windows Server assets the following is a basic example:
AssetPartitionName = Test-Partition
ConnectionProperties.ServiceAccountCredentialType = DirectoryPassword
ConnectionProperties.ServiceAccountId = 1
Name = WindowsServerHostName
NetworkAddress = 10.10.10.10
PlatformDisplayName = Windows Server
ProfileName = Test-Partition Profile
Note:
- For Windows Desktop, you would replace the value in PlatformDisplayName to Windows Desktop
- For ServicAccountId, you can query the Core API for which directory account you will use and match the Account ID associated with it:
Login to the SPP API at: https://SPP_IPAddress/service/core/swagger/index.html
Click Authorize and login with an Admin equivalent user.
Expand AssetAccounts
Expand GET/v3/AssetAccounts
Click Try it Out
Filter: PlatformType eq 'MicrosoftAD'
Fields: id,name
Click Execute to get a list the Directory accounts and their IDs to use in the CSV template
You may also filter by Name eq 'YourADServiceAccountName' and replace with a specific AD account name.
Thanks!
Thanks, Tawfiq. It worked.