For whatever reason I'm getting a 404 when I go to download the 8.x XML provided on the TECH240810 page. Can download 7.x but we're on 8.0. Anyone know if it is OK to import 7.x XML provided there into an 8.x platform?
Regarding compliance reports, we ended up building a custom SQL report for it. Here it is in case anyone is interesteJust remove comments "/* and */" from the update you want compliance for
SELECT
Inv_AeX_AC_Identification.Name,
Inv_AeX_AC_Identification.[OS Name],
Inv_AeX_AC_Identification.[System Type],
Inv_AeX_AC_Identification.[Client Date] 'Last Client Communication',
Inv_Software_Update.[FileName]
from Inv_Applicable_Windows_Software_Update
left join Inv_AeX_AC_Identification on Inv_AeX_AC_Identification.[_ResourceGuid] = Inv_Applicable_Windows_Software_Update.[_ResourceGuid]
left join Inv_Software_Update on Inv_Software_Update.[_ResourceGuid] = Inv_Applicable_Windows_Software_Update.[SoftwareUpdateGuid]
where
/* Inv_Software_Update.[FileName] LIKE '%4012598%' Windows XP */
/* Inv_Software_Update.[FileName] LIKE '%4012212%' Windows 7 March 2017 Security Only Rollup*/
/* Inv_Software_Update.[FileName] LIKE '%4012215%' Windows 7 March 2017 Monthly Rollup*/
/* Inv_Software_Update.[FileName] LIKE '%4012213%' Windows 8.1 March 2017 Security Only Rollup*/
/* or Inv_Software_Update.[FileName] LIKE '%4012216%' Windows 8.1 March 2017 Monthly Rollup*/
/* Inv_Software_Update.[FileName] LIKE '%4012606%' Windows 10 (1507) March 2017*/
/* Inv_Software_Update.[FileName] LIKE '%4013198%' Windows 10 (1511) March 2017*/
/* Inv_Software_Update.[FileName] LIKE '%4013429%' Windows 10 (1607) March 2017*/
/* Inv_Software_Update.[FileName] LIKE '%4012598%' Windows Vista*/
EXCEPT
SELECT
Inv_AeX_AC_Identification.Name,
Inv_AeX_AC_Identification.[OS Name],
Inv_AeX_AC_Identification.[System Type],
Inv_AeX_AC_Identification.[Client Date] 'Last Client Communication',
Inv_Software_Update.[FileName]
from Inv_Installed_Windows_Software_Update
left join Inv_AeX_AC_Identification on Inv_AeX_AC_Identification._ResourceGuid = Inv_Installed_Windows_Software_Update.[_ResourceGuid]
left join Inv_Software_Update on Inv_Software_Update.[_ResourceGuid] = Inv_Installed_Windows_Software_Update.[SoftwareUpdateGuid]
order by Inv_AeX_AC_Identification.[Client Date] ASC