SELECT '* ' + os + CHAR(10)
FROM [release] AS r
INNER JOIN [product] AS p ON r.product_id = p.product_id
INNER JOIN [version] AS v on r.version_id = v.version_id
INNER JOIN [status] AS s on r.status_id = s.status_id
INNER JOIN [releaseOs] AS ros on r.release_id = ros.release_id
INNER JOIN [os] AS os on os.os_id = ros.os_id
WHERE product = 'Shopping'
AND version = '6.0'
AND os_type = 'Server'
AND os_vendor_supported = 'Y'
ORDER BY os.release_date DESC

The list in the Product column is automatically updated to show only those OS versions in mainstream support by Microsoft, and therefore supported by 1E, and by

• Windows Server 2012 R2

Shopping's Intune integration feature is not supported on legacy OS. 

Please refer to Constraints of Legacy OS regarding end of mainstream support.

For Microsoft product lifecycle details, please refer to https://support.microsoft.com/en-us/lifecycle/search.

Please refer to https://1eportal.force.com/s/support-for-msft-rapid-release-cycle for details of which Current Branch versions are supported by 1E products, and known issues regarding specific versions.

SELECT '* ' + os + CHAR(10)
FROM [release] AS r
INNER JOIN [product] AS p ON r.product_id = p.product_id
INNER JOIN [version] AS v on r.version_id = v.version_id
INNER JOIN [status] AS s on r.status_id = s.status_id
INNER JOIN [releaseOs] AS ros on r.release_id = ros.release_id
INNER JOIN [os] AS os on os.os_id = ros.os_id
WHERE product = 'Shopping'
AND version = '6.0'
AND os_type = 'Client'
AND os_vendor_supported = 'Y'
ORDER BY os.release_date DESC

The list in the Product column is automatically updated to show only those OS versions in mainstream support by Microsoft, and therefore supported by 1E, and by

• Windows 7 SP1

Shopping's Intune integration feature is not supported on any legacy OS. Please be aware that Microsoft Intune has very limited support for application deployment on Windows 8.1, especially for enterprise application types.

Please refer to Constraints of Legacy OS regarding end of mainstream support.

For Microsoft product lifecycle details, please refer to https://support.microsoft.com/en-us/lifecycle/search.

Please refer to https://1eportal.force.com/s/support-for-msft-rapid-release-cycle for details of which Current Branch versions are supported by 1E products, and known issues regarding specific versions.

SELECT '* ' + rdbms + CHAR(10)
FROM [release] AS r
INNER JOIN [product] AS p ON r.product_id = p.product_id
INNER JOIN [version] AS v on r.version_id = v.version_id
INNER JOIN [status] AS s on r.status_id = s.status_id
INNER JOIN [releaseRdbms] AS rdb on r.release_id = rdb.release_id
INNER JOIN [rdbms] AS db on db.rdbms_id = rdb.rdbms_id
WHERE product = 'Shopping'
AND version = '6.0'
AND db.vendor_supported = 'Y'
ORDER BY db.rdbms DESC

SELECT '* ' + sccm + CHAR(10)
FROM [release] AS r
INNER JOIN [product] AS p ON r.product_id = p.product_id
INNER JOIN [version] AS v on r.version_id = v.version_id
INNER JOIN [status] AS s on r.status_id = s.status_id
INNER JOIN [releaseSccm] AS rsccm on r.release_id = rsccm.release_id
INNER JOIN [sccm] AS sccm on sccm.sccm_id = rsccm.sccm_id
WHERE product = 'Shopping'
AND version = '6.0'
AND sccm.vendor_supported = 'Y'
ORDER BY sccm.release_date DESC

SELECT '* ' + iis + CHAR(10)
FROM [release] AS r
INNER JOIN [product] AS p ON r.product_id = p.product_id
INNER JOIN [version] AS v on r.version_id = v.version_id
INNER JOIN [status] AS s on r.status_id = s.status_id
INNER JOIN [releaseIis] AS ri on r.release_id = ri.release_id
INNER JOIN [iis] AS i on i.iis_id = ri.iis_id
WHERE product = 'Shopping'
AND version = '6.0'
AND i.vendor_supported = 'Y'
ORDER BY i.release_date DESC

SELECT '* ' + framework + CHAR(10)
FROM [release] AS r
INNER JOIN [product] AS p ON r.product_id = p.product_id
INNER JOIN [version] AS v on r.version_id = v.version_id
INNER JOIN [status] AS s on r.status_id = s.status_id
INNER JOIN [releaseFramework] AS rf on r.release_id = rf.release_id
INNER JOIN [framework] AS f on f.framework_id = rf.framework_id
WHERE product = 'Shopping'
AND version = '6.0'
AND f.vendor_supported = 'Y'
ORDER BY framework DESC

SELECT '* ' + browser + CHAR(10)
FROM [release] AS r
INNER JOIN [product] AS p ON r.product_id = p.product_id
INNER JOIN [version] AS v on r.version_id = v.version_id
INNER JOIN [status] AS s on r.status_id = s.status_id
INNER JOIN [releaseBrowser] AS rb on r.release_id = rb.release_id
INNER JOIN [browser] AS b on b.browser_id = rb.browser_id
WHERE product = 'Shopping'
AND version = '6.0'
AND b.vendor_supported = 'Y'
ORDER BY browser ASC

If you are implementing self-service OS deployment through Shopping using either the Windows Servicing Assistant or the OS Deployment Wizard, you will need to install Tachyon and Application Migration to support migration of applications during the OS deployment.

Application Migration supersedes the App Mapping feature in earlier versions of Shopping that required AppClarity 5.2 to provide application usage information to Shopping. Shopping integration with AppClarity 5.2 is no longer available and supported so you will need to move to using Application Migration.