Joanne Klein asked on Twitter if at that spot is a way to larn all places where a specific term develop is used inwards SharePoint.
One way would locomote to iterate all site collections as well as cheque if the term develop was acquaint inwards the Hidden Taxonomy List, which stores all used price on a site collection (and if yous get got no thought what that is, that’s ok every bit well).
Hidden Taxonomy List at /Lists/TaxonomyHiddenList/AllItems.aspx
Another selection which is the solution I proposed, is to purpose search. Of course of study yous demand to get got read access to the items where the term develop is used for it to locomote 100% accurate every bit good items using price from a term develop has to locomote acquaint inwards the search index.
Note: If yous programmatically purpose app-tokens, yous tin sack get got god-search trend – which is real scary as well as unsafe indeed.
The thought is to at to the lowest degree uncovering all site collections for starters where a term develop is beingness used. One lilliputian known fact is that when yous add together a metadata column to a listing or library, inwards improver to the label of the term, both the term id as well as the term develop id is also made searchable. This agency that if yous free-text search for the id of the term set, as well as uncovering all unique site URL’s, you’re proficient to go.
I commencement locate the id of the term develop inwards inquiry from the term shop management page:
This term is thence used every bit your search query. You tin sack search whatever way yous like, but I’ll purpose PnP PowerShell. And to larn unique Site URL’s I’m using a collapse specfication of SPSiteURL:1. This agency provide 1 especial exclusively per unique value inwards the managed holding SPSiteURL. You tin sack also add together a refiner for SPSiteURL, but if yous get got tons of site collections, yous could lead a opportunity non getting all values.
The next PnP PowerShell ascendancy volition listing all site url’s where the term is used (collapse spec is available inwards the dev branch or volition locomote available inwards the June publish of PnP PowerShell).
Submit-PnPSearchQuery -Query "1e4ec7de-f5ad-49f7-a268-45e8d6b3fa64" ` -CollapseSpecification "SPSiteUrl:1" -RelevantResults ` -SelectProperties "SPSiteUrl" | pick out SPSiteUrl
So inwards total, xi site collections are using the Company term set, including the content type hub.
Summary
Sometimes yous demand to larn an overview of where a term or term develop inwards SharePoint is beingness used, as well as every bit for many other things SharePoint, search is a ubiquitous tool which oftentimes solves the chore at hand. This fourth dimension the crux is to utilize the lilliputian known characteristic of collapse specifications, inwards guild to uncovering each site collection where a term develop has been used.
You could get got this a pace farther as well as set the results into a Power BI report, every bit it’s possible to produce REST search queries against SharePoint from Power BI. It’s non super simple, but doable, as well as mayhap I’ll write nearly that inwards a afterward post.
Thanks for reading : Locating Where A Term Develop Is Used Inward Sharepoint Using Search