Security

hi Airheads,

customer has Fortinac and can exports Host endpoints into CSV file.

anyone know if we can import a CSV file into Clearpass policy manager endpoint datatbase ?

cheers

Pete

Hi Peter

As far as I know it's not possible to import csv to the Endpoints repository. But you have an option to import Endpoints with XML. If you export a few Endpoints as a template maybe you can utilize a script to build the needed XML file for import.

Another option is to import the endpoints from the csv to the Guest Device Repository under ClearPass Guest and utilize this source as your authentication source instead of the Endpoints repository.

With the Guest Device Repository you can also quite easily assign roles to the clients during the import.

hi Airheads,

customer has Fortinac and can exports Host endpoints into CSV file.

anyone know if we can import a CSV file into Clearpass policy manager endpoint datatbase ?

cheers

Pete

Thank for getting back Jonas,

Good idea using Guest device repository, could be worth a try.

Cheers

Pete

 

	Peter Elms Network Engineer Tel: +44 (0) 345 272 0910 Mob: +44 (0)7425 565490 Email: peter.elms@khipu-networks.com
KHIPU Networks Ltd is an ISO 9001 (Quality Management), ISO 27001 (Security Management), ISO 14001 (Environmental Management) and ISO 45001 (Occupational Health & Safety) certified company. KHIPU Networks Ltd supports the National Apprenticeship Scheme and employs and develops apprentices within all sectors of the company. This message is confidential and may contain privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to them), you may not copy or deliver this message to anyone or take any action in reliance on it. If you have received this e-mail in error, please delete it and notify the sender as soon as possible. KHIPU Networks Ltd does not accept any liability for any harm that may be caused to the recipient's system or data by this message. Please carry out virus and other such checks as you consider appropriate. KHIPU emails are secured via SPF, DKIM and DMARC to reduce the risk of forgery. KHIPU Networks Limited, Registered Office: 3 Waterfront Business Park, Fleet, Hampshire GU51 3TW Registered in England. Company Number 5218573 KHIPU Networks South Africa Limited, Registered Office:13 Waterford Mews, Century City, Cape Town, South Africa. Company number 2012/180716/07 GDPR - Our privacy policy can be found here

Hi Peter

As far as I know it's not possible to import csv to the Endpoints repository. But you have an option to import Endpoints with XML. If you export a few Endpoints as a template maybe you can utilize a script to build the needed XML file for import.

Another option is to import the endpoints from the csv to the Guest Device Repository under ClearPass Guest and utilize this source as your authentication source instead of the Endpoints repository.

With the Guest Device Repository you can also quite easily assign roles to the clients during the import.

hi Airheads,

customer has Fortinac and can exports Host endpoints into CSV file.

anyone know if we can import a CSV file into Clearpass policy manager endpoint datatbase ?

cheers

Pete

If using the device repository, look at csv2api for a tool that will simplify the process of importing from the CSV.

Thank for getting back Jonas,

Good idea using Guest device repository, could be worth a try.

Cheers

Pete

 

	Peter Elms Network Engineer Tel: +44 (0) 345 272 0910 Mob: +44 (0)7425 565490 Email: peter.elms@khipu-networks.com
KHIPU Networks Ltd is an ISO 9001 (Quality Management), ISO 27001 (Security Management), ISO 14001 (Environmental Management) and ISO 45001 (Occupational Health & Safety) certified company. KHIPU Networks Ltd supports the National Apprenticeship Scheme and employs and develops apprentices within all sectors of the company. This message is confidential and may contain privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to them), you may not copy or deliver this message to anyone or take any action in reliance on it. If you have received this e-mail in error, please delete it and notify the sender as soon as possible. KHIPU Networks Ltd does not accept any liability for any harm that may be caused to the recipient's system or data by this message. Please carry out virus and other such checks as you consider appropriate. KHIPU emails are secured via SPF, DKIM and DMARC to reduce the risk of forgery. KHIPU Networks Limited, Registered Office: 3 Waterfront Business Park, Fleet, Hampshire GU51 3TW Registered in England. Company Number 5218573 KHIPU Networks South Africa Limited, Registered Office:13 Waterford Mews, Century City, Cape Town, South Africa. Company number 2012/180716/07 GDPR - Our privacy policy can be found here

Hi Peter

As far as I know it's not possible to import csv to the Endpoints repository. But you have an option to import Endpoints with XML. If you export a few Endpoints as a template maybe you can utilize a script to build the needed XML file for import.

Another option is to import the endpoints from the csv to the Guest Device Repository under ClearPass Guest and utilize this source as your authentication source instead of the Endpoints repository.

With the Guest Device Repository you can also quite easily assign roles to the clients during the import.

hi Airheads,

customer has Fortinac and can exports Host endpoints into CSV file.

anyone know if we can import a CSV file into Clearpass policy manager endpoint datatbase ?

cheers

Pete

Hello,

Thanks for getting back to me.

When you say device repository, which one are you referring to ?

Regards

Pete

 

	Peter Elms Network Engineer Tel: +44 (0) 345 272 0910 Mob: +44 (0)7425 565490 Email: peter.elms@khipu-networks.com
KHIPU Networks Ltd is an ISO 9001 (Quality Management), ISO 27001 (Security Management), ISO 14001 (Environmental Management) and ISO 45001 (Occupational Health & Safety) certified company. KHIPU Networks Ltd supports the National Apprenticeship Scheme and employs and develops apprentices within all sectors of the company. This message is confidential and may contain privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to them), you may not copy or deliver this message to anyone or take any action in reliance on it. If you have received this e-mail in error, please delete it and notify the sender as soon as possible. KHIPU Networks Ltd does not accept any liability for any harm that may be caused to the recipient's system or data by this message. Please carry out virus and other such checks as you consider appropriate. KHIPU emails are secured via SPF, DKIM and DMARC to reduce the risk of forgery. KHIPU Networks Limited, Registered Office: 3 Waterfront Business Park, Fleet, Hampshire GU51 3TW Registered in England. Company Number 5218573 KHIPU Networks South Africa Limited, Registered Office:13 Waterford Mews, Century City, Cape Town, South Africa. Company number 2012/180716/07 GDPR - Our privacy policy can be found here

If using the device repository, look at csv2api for a tool that will simplify the process of importing from the CSV.

Thank for getting back Jonas,

Good idea using Guest device repository, could be worth a try.

Cheers

Pete

 

	Peter Elms Network Engineer Tel: +44 (0) 345 272 0910 Mob: +44 (0)7425 565490 Email: peter.elms@khipu-networks.com
KHIPU Networks Ltd is an ISO 9001 (Quality Management), ISO 27001 (Security Management), ISO 14001 (Environmental Management) and ISO 45001 (Occupational Health & Safety) certified company. KHIPU Networks Ltd supports the National Apprenticeship Scheme and employs and develops apprentices within all sectors of the company. This message is confidential and may contain privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to them), you may not copy or deliver this message to anyone or take any action in reliance on it. If you have received this e-mail in error, please delete it and notify the sender as soon as possible. KHIPU Networks Ltd does not accept any liability for any harm that may be caused to the recipient's system or data by this message. Please carry out virus and other such checks as you consider appropriate. KHIPU emails are secured via SPF, DKIM and DMARC to reduce the risk of forgery. KHIPU Networks Limited, Registered Office: 3 Waterfront Business Park, Fleet, Hampshire GU51 3TW Registered in England. Company Number 5218573 KHIPU Networks South Africa Limited, Registered Office:13 Waterford Mews, Century City, Cape Town, South Africa. Company number 2012/180716/07 GDPR - Our privacy policy can be found here

Hi Peter

As far as I know it's not possible to import csv to the Endpoints repository. But you have an option to import Endpoints with XML. If you export a few Endpoints as a template maybe you can utilize a script to build the needed XML file for import.

Another option is to import the endpoints from the csv to the Guest Device Repository under ClearPass Guest and utilize this source as your authentication source instead of the Endpoints repository.

With the Guest Device Repository you can also quite easily assign roles to the clients during the import.

hi Airheads,

customer has Fortinac and can exports Host endpoints into CSV file.

anyone know if we can import a CSV file into Clearpass policy manager endpoint datatbase ?

cheers

Pete

In ClearPass Guest you have one repository for guest users, and one for the guest devices.

You can find it under Devices section in the left navigation.

In the MAC authentication Service you have to add the default authentication source Guest Device Repository as either authentication source or authorizatione source if you are usinf the [MAC Auth All] authentication method.

Hello,

Thanks for getting back to me.

When you say device repository, which one are you referring to ?

Regards

Pete

 

	Peter Elms Network Engineer Tel: +44 (0) 345 272 0910 Mob: +44 (0)7425 565490 Email: peter.elms@khipu-networks.com
KHIPU Networks Ltd is an ISO 9001 (Quality Management), ISO 27001 (Security Management), ISO 14001 (Environmental Management) and ISO 45001 (Occupational Health & Safety) certified company. KHIPU Networks Ltd supports the National Apprenticeship Scheme and employs and develops apprentices within all sectors of the company. This message is confidential and may contain privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to them), you may not copy or deliver this message to anyone or take any action in reliance on it. If you have received this e-mail in error, please delete it and notify the sender as soon as possible. KHIPU Networks Ltd does not accept any liability for any harm that may be caused to the recipient's system or data by this message. Please carry out virus and other such checks as you consider appropriate. KHIPU emails are secured via SPF, DKIM and DMARC to reduce the risk of forgery. KHIPU Networks Limited, Registered Office: 3 Waterfront Business Park, Fleet, Hampshire GU51 3TW Registered in England. Company Number 5218573 KHIPU Networks South Africa Limited, Registered Office:13 Waterford Mews, Century City, Cape Town, South Africa. Company number 2012/180716/07 GDPR - Our privacy policy can be found here

If using the device repository, look at csv2api for a tool that will simplify the process of importing from the CSV.

Thank for getting back Jonas,

Good idea using Guest device repository, could be worth a try.

Cheers

Pete

 

	Peter Elms Network Engineer Tel: +44 (0) 345 272 0910 Mob: +44 (0)7425 565490 Email: peter.elms@khipu-networks.com
KHIPU Networks Ltd is an ISO 9001 (Quality Management), ISO 27001 (Security Management), ISO 14001 (Environmental Management) and ISO 45001 (Occupational Health & Safety) certified company. KHIPU Networks Ltd supports the National Apprenticeship Scheme and employs and develops apprentices within all sectors of the company. This message is confidential and may contain privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to them), you may not copy or deliver this message to anyone or take any action in reliance on it. If you have received this e-mail in error, please delete it and notify the sender as soon as possible. KHIPU Networks Ltd does not accept any liability for any harm that may be caused to the recipient's system or data by this message. Please carry out virus and other such checks as you consider appropriate. KHIPU emails are secured via SPF, DKIM and DMARC to reduce the risk of forgery. KHIPU Networks Limited, Registered Office: 3 Waterfront Business Park, Fleet, Hampshire GU51 3TW Registered in England. Company Number 5218573 KHIPU Networks South Africa Limited, Registered Office:13 Waterford Mews, Century City, Cape Town, South Africa. Company number 2012/180716/07 GDPR - Our privacy policy can be found here

Hi Peter

As far as I know it's not possible to import csv to the Endpoints repository. But you have an option to import Endpoints with XML. If you export a few Endpoints as a template maybe you can utilize a script to build the needed XML file for import.

Another option is to import the endpoints from the csv to the Guest Device Repository under ClearPass Guest and utilize this source as your authentication source instead of the Endpoints repository.

With the Guest Device Repository you can also quite easily assign roles to the clients during the import.

hi Airheads,

customer has Fortinac and can exports Host endpoints into CSV file.

anyone know if we can import a CSV file into Clearpass policy manager endpoint datatbase ?

cheers

Pete

Hi Peter

As far as I know it's not possible to import csv to the Endpoints repository. But you have an option to import Endpoints with XML. If you export a few Endpoints as a template maybe you can utilize a script to build the needed XML file for import.

Another option is to import the endpoints from the csv to the Guest Device Repository under ClearPass Guest and utilize this source as your authentication source instead of the Endpoints repository.

With the Guest Device Repository you can also quite easily assign roles to the clients during the import.

hi Airheads,

customer has Fortinac and can exports Host endpoints into CSV file.

anyone know if we can import a CSV file into Clearpass policy manager endpoint datatbase ?

cheers

Pete

hi Airheads,

customer has Fortinac and can exports Host endpoints into CSV file.

anyone know if we can import a CSV file into Clearpass policy manager endpoint datatbase ?

cheers

Pete

And one other solution is online via Aruba Solution Exchange, which creates an XML that can be imported from CSV or TSV.

hi Airheads,

customer has Fortinac and can exports Host endpoints into CSV file.

anyone know if we can import a CSV file into Clearpass policy manager endpoint datatbase ?

cheers

Pete

Hi Herman,

I believe this tool has now been retired since Dec 2024.

Doesn't anyone know of any replacement tool since the previous one worked so well for our organisation.

Thanks 

And one other solution is online via Aruba Solution Exchange, which creates an XML that can be imported from CSV or TSV.

hi Airheads,

customer has Fortinac and can exports Host endpoints into CSV file.

anyone know if we can import a CSV file into Clearpass policy manager endpoint datatbase ?

cheers

Pete

hi Airheads,

customer has Fortinac and can exports Host endpoints into CSV file.

anyone know if we can import a CSV file into Clearpass policy manager endpoint datatbase ?

cheers

Pete