Skip to content

Instantly share code, notes, and snippets.

@Ioan-Popovici

Ioan-Popovici/SU.States.Update_Groups_per_Collection.Naming_Filter.sql

Last active March 21, 2016 17:26
Show Gist options
  • Save Ioan-Popovici/8dc4fa00a199ea714a3e to your computer and use it in GitHub Desktop.
Save Ioan-Popovici/8dc4fa00a199ea714a3e to your computer and use it in GitHub Desktop.
Download ZIP
Machine Software Update Compliance for Multiple SUG's per Collection - Naming Filter Query
Raw
SU.States.Update_Groups_per_Collection.Naming_Filter.sql
SELECT CI_ID,
title
FROM v_AuthListInfo
-- Naming Filtering if you want it
WHERE title LIKE '%required%'
AND title NOT LIKE '%office%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment