About mrmadej

mrmadej · 04-15-2016

Hi, I have a problem with SQL query. I am not very familiar with SQL and this is probably the reason. The SQL looks: select (a.Id) as "Image", UTCBigIntToNomTime(a.writeEndTime) as "WriteEndTime", (select UTCBigIntToNomTime(c.copyDate) ...

mrmadej · 03-02-2016

Hi, I have recently upgraded my OPSC from 7.6.0.3 to 7.7.1. I've tried to connect to database via 'dbisqlc' and recieved popup with "Database server not found" message. I think that I gave proper user/pass and database name: user: DBA pass: SQL ...

mrmadej · 03-01-2016

Hi, I am looking for solution how to prepare the report for backups of Oracle databases. I need the report which will have the columns: PolicyName | AvgWrittenSize | ClientName | MediaServerName | AvgTimeDuration I can get AvgTimeD...

mrmadej · 11-27-2015

Hi, I upgraded the NBU to 7.6.1.1 from 7.5.0.4. All is fine but very important option for administrators disapeared from context menu in Activity Monitor. Not exactly disapeared but is grayed out: It is strange and very inconvenient for admins. ...

mrmadej · 10-29-2015

Hi All, I am looking for the possible solution for problem on customer's environment. I have read a lot of articles and posts. And did not found any solution. None of solutions (i.e. keepalive timeout, etc.) doesn't work for us. We have a lot of ...

mrmadej · 04-18-2016

Thanks for answer. It is much better from performance perspective. But I need something else. I omitted in my first post that I have to have that if the second copy does not exist then the "CopyDate" should be NULL. Something like this: Image ...

mrmadej · 04-15-2016

I changed query with according to my colleague recommendation, but it still takes too long. He said that query looks properly. select DISTINCT (a.Id) as "Image", UTCBigIntToNomTime(a.writeEndTime) as "WriteEndTime", (select UTCBigIntToNomTim...

mrmadej · 03-07-2016

I spend few days on analyzing the data from OPSC database and I can't find the possibility to prepare report like this. There is no way to aggregate rows which belong to the same parent job. If someone know how to achive this goal it would be great...

mrmadej · 03-04-2016

:-)))) You're wright. I feel so stupid. But I am pretty sure I have tested this way. Thanks and sorry for wasted time. Regards Madej

mrmadej · 03-04-2016

c:\Program Files\Symantec\OpsCenter\server\db\WIN64>hostname opscenter Port 13786 is opened, I can telnet on it. Before upgrade I could connect without problems in the same way. Maybe the problem is that I have tested the backup/restore of dat...

VOX

User Statistics

User Activity

SQL query - takes long time - help with optimization

OPSCenter 7.7.1 - dbisqlc - "Database server not found"

OPSCenter - custom report for Oracle backups

"Change job priority" in NBU 7.6.1.1

Inactive TCP session - error 636 (firewall)

Thanks for answer. It is much

Re: SQL query - takes long time - help with optimization

Re: OPSCenter - custom report for Oracle backups

Re: OPSCenter 7.7.1 - dbisqlc - "Database server not found"

Re: OPSCenter 7.7.1 - dbisqlc - "Database server not found"