Frequent Contributor I
Posts: 90
Registered: ‎08-12-2011

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.

Posts: 1,548
Registered: ‎06-12-2012

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
Posts: 37
Registered: ‎03-15-2011

Re: Clearpass SQL API

how did you connect to the SQL service with pgAdmin?

Guru Elite
Posts: 8,759
Registered: ‎09-08-2010

Re: Clearpass SQL API

[ Edited ]

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



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