IoanPopovici
3/21/2016 - 4:22 PM

Machine Software Update Compliance for Multiple SUG's per Collection - Naming Filter Query

Machine Software Update Compliance for Multiple SUG's per Collection - Naming Filter Query

SU.States.Update_Groups_per_Collection.Naming_Filter.sql
content_copyfile_download
SELECT CI_ID,
       title
FROM v_AuthListInfo

-- Naming Filtering if you want it
WHERE title LIKE '%required%'
    AND title NOT LIKE '%office%'