cancel
Showing results for 
Search instead for 
Did you mean: 

Missing soem clients in opscenter reports

Naveen_Sunkari
Level 4

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 ACCEPTED SOLUTION

Accepted Solutions

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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 12

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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

Naveen_Sunkari
Level 4

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

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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

Naveen_Sunkari
Level 4

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



Thanks
Naveen Sunkari
9962235978

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

Naveen_Sunkari
Level 4

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

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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)

Naveen_Sunkari
Level 4

 

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

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Hi,

 

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

Naveen_Sunkari
Level 4

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

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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

Naveen_Sunkari
Level 4

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



Thanks
Naveen Sunkari
9962235978