cancel
Showing results for 
Search instead for 
Did you mean: 

Missing soem clients in opscenter reports

I have created one report in opscenter and total servers are 8 and after creating the report i can see only 2 clients in the report list, but those missing servers are in our backup support i can see in activity window. I am not sure why its not reflecting in opscenter backup report. can any one please help on this.

My Opscenter version is 7.7, Windows server.



Thanks
Naveen Sunkari
9962235978
1 Solution

Accepted Solutions
Accepted Solution!

To create a report using SQL

To create a report using SQL query
1 In the OpsCenter console, click Reports.
2 On the Report Templates tab, click Create New Report.
3 On the Report Wizard, select the Create a report using SQL Query option
and click Next.
4 On the SQL Query page, enter an SQL query to view the required data.

View solution in original post

12 Replies

Please share the details of

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

Hi Thanks for reply please

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.

 

SACNT1160
SACNT1161
SACNT1162
SACNT1163
SACNT1164
SACNT1165
SACNTE230
SACNTE231


Thanks
Naveen Sunkari
9962235978

Which variables have you

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

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



Thanks
Naveen Sunkari
9962235978
Accepted Solution!

To create a report using SQL

To create a report using SQL query
1 In the OpsCenter console, click Reports.
2 On the Report Templates tab, click Create New Report.
3 On the Report Wizard, select the Create a report using SQL Query option
and click Next.
4 On the SQL Query page, enter an SQL query to view the required data.

View solution in original post

I ran the query by replacing

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."



Thanks
Naveen Sunkari
9962235978

OK, and if you use the names

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

 

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



Thanks
Naveen Sunkari
9962235978

Hi, Did you try with lower

Hi,

 

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

Hi Riaan, Could you please

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.



Thanks
Naveen Sunkari
9962235978

Not sure. I don't use the

Not sure. I don't use the reports, I just write my own using queries.

Can any one help on this.?

Can any one help on this.? any suggestions.?



Thanks
Naveen Sunkari
9962235978