SITESCOPE PATTERN MATCH (198 Views)
Reply
Frequent Advisor
Utkarshpatel
Posts: 60
Registered: ‎02-15-2012
Message 1 of 2 (198 Views)

SITESCOPE PATTERN MATCH

Hello Experts,

I have a DB query whose output is the symchronization status between 2 db's.
The output is as below.

Status Summary: matched: XYZ, 1, 2014-03-26 12:30:01.0, 34550, 0.093 sec,
3 rows,

XYZ, 1, 2014-03-26 12:30:01.0, 34550
null, 2, 2014-03-14 10:58:06.0, 34205
PQR, 3, 2014-03-26 12:30:01.0, 34550

Now i want to fetch the time taken by db to do the replication..so from
the above output, db XYZ does sync in 34550 and db PQR does it in 34550.
So in one paratemet, XYZ i want to fetch the time taken by that db to sync
(in this case 34550)
and in other paramente, PQR i wanr to fetch the time taken by that db to
sync (in this case 34550, which might vary)

Need help with the content match..

Thanks
Utkarsh
HP Expert
jmmirchev
Posts: 454
Registered: ‎09-14-2012
Message 2 of 2 (167 Views)

Re: SITESCOPE PATTERN MATCH

Hi Utkarsh ,

 

 This seems like a case to use a custom monitor , with its script you could process the results and obtain requirered data .

Here are some posts, that might be helpful for you :

 

http://h30499.www3.hp.com/t5/SiteScope-Support-Customer-Forum/SiteScope-custom-monitors/m-p/6114219#...

http://h30499.www3.hp.com/t5/SiteScope-Support-Customer-Forum/Custom-Database-Monitor/m-p/6269593#M2...

 

 

Hope this helps !

 Yordan


Yordan Mirchev
HP Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.

If you haven’t tried it yet, come and join us in our entitled forums at Support Customer Forums
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.