Frequent Contributor I

Clearpass SQL API

I want to use Guestaccount information from SQL API because the reports from Insight are only send by email as pdf.

We want to do the billing automatically for our guestaccounts. We want to creat a process which directly connects to the sql api.

I got access to the sql api via pgAdmin. But I don't find the table which contains the data i need.

Where do i find the guest account data like

username, sponsorname start date and expiry date?


Is there any documentation about the sql api?


Thanks a lot.

Re: Clearpass SQL API
Thank You,

--Give Kudos: found something helpful, important, or cool? Click Kudos Star in a post.

--Problem Solved? Click "Accepted Solution" in a post.
Occasional Contributor II

Re: Clearpass SQL API

how did you connect to the SQL service with pgAdmin?

Guru Elite

Re: Clearpass SQL API

Set the appexternal password under cluster settings and use those credentials to connect.



Tim Cappalli | Aruba Security
@timcappalli | | ACMX #367 / ACCX #480
Search Airheads
Showing results for 
Search instead for 
Did you mean: