05-19-2014 04:32 AM
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?
05-19-2014 10:48 AM
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?
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.
05-22-2014 10:12 AM
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.