Why don't you simply query the Citrix database to find the Citrix users? Typos courtesy of Apple. Sent from my iOS device.
On Aug 19, 2015, at 4:39 PM, George Salmaniw <[email protected]<mailto:[email protected]>> wrote: I am attempting to create a USER collection identifying our CITRIX users. This collection would then be used to manage what application packages are displayed within the Application Catalog. The catch is that we don't know the complete list of CITRIX users. To this end the thinking is, as we know the PCs that are at sites deemed to be CITRIX, we could use USER DEVICE AFFINITY to identify users of these PCs and build a USER collection from the results. SQL seems to provide exactly what we are looking for. SELECT COLL.ResourceID, COLL.Name, VIP.IP_Addresses0,VSYS.User_name0, VSYS.AD_Site_Name0, VSYS.Distinguished_Name0, VSYS.Last_Logon_Timestamp0 FROM [CM_C01].[dbo].[v_CM_RES_COLL_C0100340] AS COLL INNER JOIN [CM_C01].[dbo].[v_R_System] AS VSYS ON VSYS.ResourceID = COLL.ResourceID INNER JOIN [CM_C01].[dbo].[v_RA_System_IPAddresses] AS VIP ON VIP.ResourceID = COLL.ResourceID WHERE VSYS.User_Name0 IS NOT NULL AND VIP.IP_Addresses0 NOT LIKE 'f[d-e]%' ORDER BY Name, User_Name0 I am able to get very similar results in WQL as follows with a limiting DEVICE collection select UMR.ResourceId, UMR.UniqueUserName from SMS_R_System AS SR inner join SMS_UserMachineRelationship AS UMR on UMR.ResourceID = SR.ResourceId where UMR.Types = 1 AND SR.LastLogonUserName IS NOT NULL. select SR.ResourceId, SR.Name, SR.LastLogonUserName, SR.IPAddresses, SR.Client from SMS_R_System AS SR inner join SMS_UserMachineRelationship AS UMR on UMR.ResourceID = SR.ResourceId where UMR.Types = 1 AND SR.LastLogonUserName IS NOT NULL. How can I take this WQL and create a USER COLLECTION based on the LastLogonUserName field? George ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
