Security

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

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?

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.

Hi there,

could you share your sql queries?

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

thanks

Ken