10-05-2015 02:02 AM
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.
Solved! Go to Solution.
10-05-2015 05:57 AM
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.
10-05-2015 04:58 AM
Please share the details of what you're trying to report or on. Or post the query.
10-05-2015 05:04 AM
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 |
10-05-2015 05:35 AM
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
10-05-2015 05:47 AM
Could you please let me know where to run this query.
10-05-2015 05:57 AM
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.
10-05-2015 06:14 AM
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."
10-05-2015 10:10 AM
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)
10-05-2015 09:39 PM
Thanks for your help but we have daily successful backups for these servers please find the below screen shot from NBU activity monitor.
10-05-2015 10:00 PM
Hi,
Did you try with lower case server names? Could be that. Also try with full FQDN.
10-05-2015 11:36 PM
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.
10-05-2015 11:52 PM
Not sure. I don't use the reports, I just write my own using queries.
10-06-2015 03:06 AM
Can any one help on this.? any suggestions.?