troubleshooting Question

Need help on sql query-sharepoint content db

Avatar of sg05121983
sg05121983 asked on
Microsoft SQL ServerMicrosoft SharePoint
4 Comments1 Solution578 ViewsLast Modified:
Hi All,

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.

Ex:
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.
Site-collection-script.txt
ASKER CERTIFIED SOLUTION
QPR

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros