Skip to content

Instantly share code, notes, and snippets.

@akanieski

akanieski/FindCustomFields.sql

Created February 5, 2022 04:09
Show Gist options
  • Save akanieski/49c3b9372773e30bb87df8dee5338424 to your computer and use it in GitHub Desktop.
Save akanieski/49c3b9372773e30bb87df8dee5338424 to your computer and use it in GitHub Desktop.
Download ZIP
Query to locate custom fields
Raw
FindCustomFields.sql
select prj.ProjectName, WorkItemType, f.ReferenceName, f.FieldId from dbo.tbl_FieldUsage u
left join tbl_field f on f.fieldid = u.fieldid
left join [AnalyticsModel].tbl_WorkItemTypeField witf on witf.FieldReferenceName = f.ReportingReferenceName
left join [AnalyticsModel].tbl_Project prj on prj.ProjectSK = witf.ProjectSK
where u.IsCore = 0 and u.ObjectId = -100 and ChangerId > 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment