RG016 PowerTrace Skeletons in the closet?

You may find yourself in the sticky situation that you need to remove certain records from PowerTrace. Suppose you have WebTrace enabled and your best colleague (ofcourse inadvertendly and completely accidentally) clicks on a link which takes him to nakedsmurfs.com or something even more embarassing :)

Now this information is logged in PowerTrace and all we want is get rid of those particular records. This is currently not doable from within the PowerFuse console, so here is a solution to this.

Warning: This excersize involves messing around with the PowerFuse tables. If you are not sure what you’re doing, better leave it alone as you can risk blowing up your database or worse. Always make a backup of your DB before attempting to doctor it. And yeah, it’s not supported and so on.

Anyway to deal with this problem , you need to run some SQL update queries up against your DBMS. The SQL you need looks like this:

DELETE FROM TBLapp
WHERE     (strtitle LIKE '%somesite.com%')

DELETE FROM TBLuser
WHERE     (strtitle LIKE '%somesite.com%')

DELETE FROM TBLserver
WHERE     (strtitle LIKE '%somesite.com%')

DELETE FROM TBLserver
WHERE     (strtitle LIKE '%somesite.com%')

If you prefer to do such things through RES Wisdom, here’s a buildngblock for module you can import and use instead. You schedule it to run on the SQL server which has your PowerFuse database on it.  The module will automagically prompt you first-time for the connection details and the search string of those records you wish to delete.

Rightclick and save target on the brick to download: 

1 Comment

• 

  By John Doe, 2009/03/28 @ 09:55

  It’s also possible to limit the result to only http/https – by defining another where clause – lngAppID=-1000

Other Links to this Post

RSS feed for comments on this post. TrackBack URI

Leave a comment