After Upgrade to 7.6.0.4 column deleted from domain_Client deleted

[nschrenk]

We have updated the OpsCenter to 7.6.0.4 and we use sql queries to find out which client has a special name pattern.

Before upgrade the following querie worked fine:

SELECT name as "Name" FROM domain_Client
WHERE name  LIKE '%oracle-onl%' AND deleted = 0;

While upgrade the db changed all attributes in the column delete to 0. So the report shows all clients which has this namepattern in the past.

Anyone with the same problem? Or has anyone a solution to find out which client has this special pattern and is in the active nbu configuration (not deleted or renamed)

what would help too: List all clients of a policy in a active nbu configuration. No clients which was in the past in that policy.

[RiaanBadenhorst]

add a date range to not look at anything before say yesterday.

[nschrenk]

I have tried:

select * from domain_Client
WHERE name LIKE '%oracle-onl%' and DATEDIFF(DD, adjust_timestamp(lastUpdatedTime, 3600000), today()) < 1

But there is no timestamp after the upgrade :(

Looks like lastUpdatedTime is not up to date?

[nschrenk]

Hi M_henriksen,

in our environment (7.6.0.4) is there only one entry per restore job.

[M_henriksen]

Hi Nschrenk.

I have try to run the query in our environment and I see the same issue here.. We are running 7.6.0.3.

Also we see some errors in domain_job where duplicate and restore jobs are in the table twice, this happend after we upgraded from 7.6.0.2 to 7.6.0.3

Query

SELECT
A.id as 'Job ID',
A.clientName as 'Client',
A.policyName as 'Policy',
UTCBigIntToNomTime(A.startTime) as 'Start Time',
UTCBigIntToNomTime(A.endtime) as 'End Time'
FROM  "domain_Job" A , "domain_masterserver" B

WHERE
B.id = A.masterServerId and a.id = '862965'

Output see attach file