External Content Connector - SharePoint - Where are index documents stored?

[benm3]

Hello,

I am setting up the SharePoint External Content Connector. I have ran a full document crawl and a user mapping crawl. Both have completed and have found various documents. 151 of those documents have been indexed. 

My problem is creating the index and search source as I have no idea what table these 151 documents are stored on, or if they are even stored on a table?

I have looked through sys_db_object to try and find relevant tables but cannot find any. I did find the user mapping table which does contain data. 

If anyone can help, it would be really appreciated. 

See image below. 

[kaustubhdub]

hi @benm3 ,
Did you find solution to your problem? as i am stuck at the same problem.

regards

Kaustubh Dubey

[benm3 · Accepted solution]

Hi, 

Yea if you go to the ais_datasource table you should see a Index called "SharePoint Online". You can't see any of the records since they aren't stored within SN but you can use the index source and link it to a search profile.

You should be able to ask Now Assist sharepoint related queries and get answers. 

[benm3]

Also for web crawler sources, there is a index called webcrawler.

[kaustubhdub]

Hi,

I did the steps but somehow even after linking the source to the profile,  i am not able to view the results. Actually, i wanted to use it in my AI agent for a use case.