06-13-2022 09:25 AM
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
06-23-2022 06:43 AM
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.