Skip to content

Instantly share code, notes, and snippets.

@DarkAllien

DarkAllien/CollectionInfo.sql

Created October 23, 2018 10:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save DarkAllien/9cd771f1d367d6b64dcfd1718590a191 to your computer and use it in GitHub Desktop.
Save DarkAllien/9cd771f1d367d6b64dcfd1718590a191 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
CollectionInfo.sql
SELECT DISTINCT
[aa].[CollectionID],
[aa].[CollectionName]
FROM [v_ApplicationAssignment] [aa]
WHERE [aa].[ApplicationName] = @AppInfo
ORDER BY 2;
@ErshovIS
Copy link

To get deal with localized application names I used the following query
WHERE [aa].[ApplicationName] like N'%'+@AppInfo+N'%'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment