Database Reference
In-Depth Information
Changing the datasets to role-based
Perform the following steps:
1. Under
Report Data
, right-click on the dataset called
CollsForComputers
. Select
Data Properties
.
2. Change the query to the following:
SELECT fnRS.Name0 As [Computer Name],
fnC.Name As [Collection Name]
FROM fn_rbac_FullCollectionMembership (@UserSIDs)
fnFCM
JOIN fn_rbac_R_System (@UserSIDs) fnRS ON
fnFCM.ResourceID = fnRS.ResourceID
JOIN fn_rbac_Collection(@UserSIDs) fnC ON
fnFCM.CollectionID = fnC.CollectionID
3. Click on
OK
.
4. Under
Report Data
, right-click on the dataset called
List_Collections
. Select
Data Properties
.
5. Change the query to the following:
SELECT SiteID AS CollectionID,
CollectionName, CollectionComment AS
Description
FROM fn_rbac_Collections(@UserSIDs)
Where IsBuiltIn=0
6. Click on
OK
.
7. Save the report.
8. Test the report with the
Full Administrator
role user account. The result should
list all the collections and computers.
9. Now, test the report with a user account with limited collections. In our example,
the user only has access to two collections, and the result is illustrated in the fol-
lowing screenshot: