Hello again,
I need information, is there any way in the code below to include views instead of using the following lines?
AND A.policyName LIKE 'XXX%'
OR A.policyName LIKE 'YYY%'
Thanks a lot.
Regards
-----------------------...
Hello,
I am using this code:
-----------------------------------------------------------------------------
SELECT DISTINCT A.clientName as 'Client Name', A.policyName as 'Policy Name',
LIST( DISTINCT A.statuscode) as 'Status Code',
( selec...
Hi,
I need help to solve this issue.
Using the following code I get an error (always the same number : 16953 ) in value returns in column " Days since last successful backup" .
Could anybody help me?
Thanks.
Regards.
SELECT DISTINCT
A.cli...
Hello,
I,m trying to use this query :
SELECT DISTINCT
A.clientName as 'Client Name',
A.policyName as 'Policy Name',
A.scheduleName as 'Schedule name',
LIST( DISTINCT A.statuscode) as 'Status Code',
( select DATEDIFF(DAY,UtcB...
Hi again,
I'm working with the version of OpsCenter Version 7.6.0.4.
Now I am trying to create a report including , Policy name, cliente name ,Jobstate,status attemps,start and end time; I am working with this code:
SELECT
domain_Job.Policyname...