DarkAllien/AppInfo.sql

Created October 23, 2018 10:16

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/DarkAllien/60e8ac4e179ce32a7f9514b027092a60.js"></script>
Save DarkAllien/60e8ac4e179ce32a7f9514b027092a60 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

AppInfo.sql

	SELECT DISTINCT
	[aa].[ApplicationName]
	FROM [v_ApplicationAssignment] [aa]
	ORDER BY 1;

ErshovIS commented Jul 22, 2020

You could also use RBAC function to get user-specific Applications

select distinct ApplicationName
from [dbo].[fn_rbac_ApplicationAssignment](@UserSIDs)
ORDER BY 1;

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