query fun

Need to see which custom client settings are deployed to which collections? and the same for antimalware policies?  Also if the policy is not deployed to a collection it will show NULL for the collection name.  enjoy.

client settings:

SELECT vSMS_ClientSettingsAssignments.Name AS CollectionName, vSMS_AntimalwareSettings.Name AS EndPointPolicyName
FROM vSMS_ClientSettingsAssignments right JOIN
vSMS_AntimalwareSettings ON vSMS_ClientSettingsAssignments.ClientSettingsID = vSMS_AntimalwareSettings.ID

antimalware policy:

SELECT vSMS_ClientSettingsAssignments.Name AS CollectionName, vSMS_ClientSettings.Name AS ClientPolicyName
FROM vSMS_ClientSettingsAssignments right JOIN
vSMS_ClientSettings ON vSMS_ClientSettingsAssignments.ClientSettingsID = vSMS_ClientSettings.ID