11-26-2014 05:06 AM
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.
11-26-2014 05:25 AM
add a date range to not look at anything before say yesterday.
11-26-2014 06:36 AM
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?
11-28-2014 03:45 AM
Hi M_henriksen,
in our environment (7.6.0.4) is there only one entry per restore job.
02-24-2015 04:41 AM
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