02-27-2014 04:44 AM
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 |
05-12-2014 10:00 AM
What Symantec product is this for? I can move it to the correct forum for better visibility.