Forum Discussion

rickwestmacott's avatar
rickwestmacott
Level 2
3 years ago

Help with Opcenter Report Query for to match clients in policies

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

 

 

 

  • Dollypee's avatar
    Dollypee
    Moderator
    3 years ago

    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.