We need to fetch site collections from sharepoint content DB. We have prepared query to fetch the data as per our requirement (Please find the attached script).
But the query is returining sub site too, we don't want sub site in the output report.
sites/SS-test - > is enough
sites/SS-test /Subsite 1 - is not required
sites/SS-test / Subsite 1/Subsite 11 - is not required
sites/SS-test /Sub site 2 - is not required
Please advise\modify the attached script as per above requirement.
Thanks in advance.