Security

Reply
Occasional Contributor I
Posts: 5
Registered: ‎04-17-2014

CPPM Join Insightdb and tipsLogDB database in a SQL query

Hi

 

I've been creating and running quite a few SQL scripts against the databases on our CPPM appliances. Does anyone know if I can create a join in the SQL between two of the databases?

 

Chris

 

Moderator
Posts: 455
Registered: ‎11-09-2012

Re: CPPM Join Insightdb and tipsLogDB database in a SQL query

It should be possible, as both DB's are on the same node.... no need for a server link, which we don't open up or you but you'll have to use dblink.....

 

NOW:  I want to warn you of the potential issues around this type of Table join's especially outer joins, then can be VERY, make that VERY VERY CPI/IO intensive. Pretty much all the data is the same across these two DB's.

 

My question to you is what are you trying to acheive as we can guide you through this in a better way?


Best Regards
-d

Snr Tech Marketing Engineer - ClearPass

-- Found something helpful, important, or cool? Click the Kudos Star in a post.
-- Problem Solved? Click "Accept as Solution" in a post.
Occasional Contributor I
Posts: 5
Registered: ‎04-17-2014

Re: CPPM Join Insightdb and tipsLogDB database in a SQL query

Most of my examples relate to endpoints (in insight) and authentications (in tipsLogDB).

 

For example, get me a list of devices seen on ports which have had IP conference phones plugged into them.

 

I want maximum info on the endpoints, along with timeline for when the devices were seen.

 

Appreciate comments on utilisation. I expect these to be scheduled reports running overnight and emailing, not adhoc.

Occasional Contributor II
Posts: 26
Registered: ‎06-29-2012

Re: CPPM Join Insightdb and tipsLogDB database in a SQL query

Hi there,

 

could you share your sql queries?

 

I am trying to get an Endpoint report joined with Posture status.

 

thanks

Ken

Search Airheads
Showing results for 
Search instead for 
Did you mean: