I'm trying to create report that I can run that will show a count of OS by specified collection. Then, similar to the built in Count OS version report, I want to be able to click on the OS version in the initial report and find the clients that meet that criteria. Essentially, I just want to prompt for a collection with the built in report rather than it just running. Here is the query I was attempting to use:
SELECT OPSYS.Caption0 as 'OS', COUNT(*) AS 'Count' FROM fn_rbac_GS_OPERATING_SYSTEM(@UserSIDs) OPSYS inner join fn_rbac_R_System(@UserSIDs) sys on OPSYS.ResourceID=sys.ResourceID inner join v_FullCollectionMembership As FCM On SYS.ResourceID=FCM.ResourceID where FCM.CollectionID = @COLLID GROUP BY OPSYS.Caption0 ORDER BY OPSYS.Caption0 It now prompts for the collection, but I cannot expand the OS version categories to view the clients that meet the criteria. Has anyone accomplished this, or can see what I am doing wrong? Thanks, Garrett Chandler Desktop Support Specialist Denton ISD Technology 940-369-0120 [email protected]<mailto:[email protected]>
