Questions tagged [kql-query]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
17 views

How to search fraud score for multiple IP's

I am trying to find fraud scores for multiple IP's to show in a table let HttpURL = externaldata (host:string,fraud_score:string, ISP:string,proxy:string,vpn:string,bot_status:string,city:string, ...
user avatar
0 votes
0 answers
61 views

KQL for Managed Metadata in SharePoint Online

I've been researching for a couple of hours now, but can't seem to find a straight answer. In SharePoint on premise, you can perform KQL searches with the following commands to search for documents ...
user avatar
1 vote
3 answers
154 views

KQL Search Query SharePoint Online

I would like to add filter based on Usage Location for AU or NZ. However the following result only return the record where UsageLocation is NZ {searchboxquery} contentclass=spspeople -UsageLocation -...
user avatar
  • 1,787
0 votes
0 answers
94 views

KQL query for SharePoint Online list to return just column value

I have a workspace list that contains records for all the workspaces(SharePoint sites) that were ordered. This list has one column called "WorkspaceUrl". So here I am looking for a KQL query ...
user avatar
0 votes
1 answer
528 views

KQL Query for SharePoint Online List (Column) Search

I am trying to search for two title fields in a SharePoint list using KQL and can't seem to get this to work. I can get it to work for a single Column, but I can't get it to search for a second ...
user avatar
0 votes
1 answer
98 views

SharePoint Search - Result Source to retrieve only 5 People along with rest of the results

Can you please help me in formulating a KQL or FQL query? Is it possible to retrieve only 5 people results from the below query. Rest 15 can be anything from the index of the SharePoint Search Service....
user avatar
  • 1
0 votes
1 answer
172 views

How to write ANDNOT in KQL query?

I need to achieve a query where RefinableDate00 must be earlier than today RefinableDate00:1900-01-01..{Today} but also should not be null since if it is null, the result I want does not appear in the ...
user avatar
1 vote
1 answer
197 views

SharePoint Search - KQL query (results limitation)

I have a issue with limiting search results using PnP Modern Search. In addition to pulling all *.docx documents from the document library, I would like to skip those that have the name "...
user avatar
0 votes
1 answer
2k views

How to write a query in KQL for Internal and External ip addresses [closed]

How do you write a query in KQL looking for external ip addresses and internal ip addresses
user avatar
1 vote
2 answers
3k views

How to search only some specific sites using result source - SharePoint Online

I have couple of sites and subsites and would like to create a result source just for these sites. Then my intention is to add a new search webpart or use the existing one but change it to use my new ...
user avatar
  • 4,112
1 vote
0 answers
102 views

Search result source exclude read only sites

I am looking for a way to set up two search result sources, one that should exclude all content from any site collection that have been set as Read only and another that should only show content from ...
user avatar
1 vote
2 answers
647 views

How to set search scope to specific site or subsite using KQL powershell csom

I want to search for content in a specific subsite in sharepoint online. How can I set scope of search to subsite in KQL using powershell csom? I tried the following query: $queryText="createdby:$...
user avatar