Missing soem clients in opscenter reports

Please share the details of what you're trying to report or on. Or post the query.

Hi

Thanks for reply please find the attached screen shot, i have added total 8 servers into my report but once i run the report i can able to see the status report only for 2 servers.

Below are the servers added into my report.

Which variables have you specified for this report? Do you get any results if you increase the time frame?

Can you post the results of the query below. It will show if there are actually jobs for this client. You can replace the client name in bold with the clients you're missing.

select

domain_jobarchive.id as "Job ID",

domain_jobarchive.policyname as "Policy",

domain_jobarchive.statusCode as "Status"

from domain_jobarchive

where

domain_jobarchive.clientname like '%SACNT1162%'

and

DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 7

Could you please let me know where to run this query.

I ran the query by replacing the missing server names noting i can see as result, getting mesg as below

"The report did not return any data."

OK, and if you use the names that did report data (in your report)? If that shows a result then it just shows that there were no backups for those clients during those times (or I wrote the query wrong)

Thanks for your help but we have daily successful backups for these servers please find the below screen shot from NBU activity monitor.

Hi,

Did you try with lower case server names? Could be that. Also try with full FQDN.

Hi Riaan,

Could you please tell me how to add the servers with fully qualified domain name into opscenter servers list.

I can see the server names without FQDN in the opscenter servers list.