Video Screencast Help

How to open URLs from report column in a new window

Created: 27 Feb 2014 | 1 comment

Hello,

Could someone help me to create drill down on report to be able to open URLs which are result of following SQL code:

DECLARE @v1_Package_ID uniqueidentifier
   SET @v1_Package_ID = '%Package_ID%'
SELECT       

p1.URL,
s2.Name
FROM SWDPackageCodebase p1     
left join SWDPackage s2 on p1.PackageId = s2.PackageId     
 WHERE
   (
      (
         (s2.[PackageId] = @v1_Package_ID)
      )
   )
GROUP BY p1.URL, s2.Name

  ]]>

I would like to be able to open each URL using reight-click or double click (is it possible)

and report results are like below:

URL    Name   
file://servername/PkgSvrHostD$/{0C6C4E06-940A-47B9-8187-C9E4A4C05E21}/cache  
file://servername/PkgSvrHostD$/{0C6C4E06-940A-47B9-8187-C9E4A4C05E21}/cache  
file://servername/PkgSvrHostD$/{0C6C4E06-940A-47B9-8187-C9E4A4C05E21}/cache  
file://servername/PkgSvrHostD$/{0C6C4E06-940A-47B9-8187-C9E4A4C05E21}/cache  
file://servername/PkgSvrHostD$/{0C6C4E06-940A-47B9-8187-C9E4A4C05E21}/cache  
file://servername/PkgSvrHostD$/{0C6C4E06-940A-47B9-8187-C9E4A4C05E21}/cache
Operating Systems:
Discussion Filed Under:

Comments 1 CommentJump to latest comment

Brɨan's picture

What Symantec product is this for? I can move it to the correct forum for better visibility.

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.