cancel
Showing results for 
Search instead for 
Did you mean: 

Help with Opcenter Report Query for to match clients in policies

rickwestmacott
Level 2

Hi All,

I have a simple report query below. What is happening is that it is reporting on clients that don't exist in those policies any longer. I'm sure this is historical but how would you tweak the query to only pull clients that are currently in a policy, I don't see any timestamp data on this particular table.

There may be a canned report that will provide this info, but the idea is delve into the schema objects directly for a better understanding and how to generate weird reports.

SELECT DISTINCT
clientName,
policyName
FROM domain_policyclient
WHERE upper(policyName) not in ...

thanks in advance

 

 

 

1 REPLY 1

Dollypee
Moderator
Moderator
   VIP    Certified

Hi @rickwestmacott ,

Are you trying to get report for just active clients? Above query will list both active and non active clients in the database. Can you provide me opscenter db schema. Let me try to put something together for you.