You will need to change the path in the where clause to the path appropriate to your environment.

WITH
root_path AS (SELECT sd.fullpath_hash,
sd.path_type,
sd.ns_left,
sd.ns_right,
sd.scan_id
FROM srs.scan_data AS sd
INNER JOIN srs.scans AS s ON s.id = sd.scan_id
WHERE (sd.fullpath_hash IN (srs.path_hash('\\sp.cctec.org\dfs\home'))) AND
(sd.path_type = 2) AND
(s.progress_status = 4))
SELECT
sd.fullpath,
sd.size,
srs.byte_string(cast(sd.size as bigint)) as size_string,
srs.ad_account_name(ad.domain,ad.name,sd.owner_id) as owner
FROM
srs.scan_data AS sd
INNER JOIN root_path AS rp
ON (rp.scan_id = sd.scan_id) AND
(rp.ns_left <= sd.ns_left) AND
(rp.ns_right >= sd.ns_right)
join srs.ad_objects as ad on ad.sid = sd.owner_id
WHERE
sd.size > 1024 * 1024 * 1024
and sd.path_type = 1