Avatar of sg05121983
sg05121983
 asked on

Need help on sql query-sharepoint content db

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
Microsoft SQL ServerMicrosoft SharePoint

Avatar of undefined
Last Comment
sg05121983

8/22/2022 - Mon
QPR

If you only want the top level sites for a site collection then you need to specify
WHERE webs.ParentWebId is null
sg05121983

ASKER
I have tried with your option, still the output is shwoing subsites.

any other suggestions?
ASKER CERTIFIED SOLUTION
QPR

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
sg05121983

ASKER
--
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck