I learn, I pass it on. Please comment and ask questions!
Friday, February 25
A reader of this blog asked me this morning: "If you wanted to design a query to make a report for management that would show which AD Groups or users have access to which reports, how would you go about it."
This is what I quickly whipped up:
SELECT Catalog.Name ReportName ,Users.UserName ,Roles.RoleName FROM [dbo].[Catalog] JOIN dbo.PolicyUserRole ON [Catalog].PolicyID = PolicyUserRole.PolicyID JOIN dbo.Users ON PolicyUserRole.UserID = Users.UserID JOIN dbo.Roles ON PolicyUserRole.RoleID = Roles.RoleID