|
I did not change anything in your collection except for the section highlighted below. For each collection, change the range '[a-h]%' to the range you need.
SELECT [vResourceEx].[Name] AS 'Name',
[Inv_AeX_AC_Identification].[OS Name] AS 'OS Name',
[Inv_AeX_AC_Identification].[OS Type] AS 'OS Type',
[Inv_AeX_AC_Identification].[System Type] AS 'System Type'
FROM [vResourceEx] INNER JOIN [Inv_AeX_AC_Identification]
ON [vResourceEx].[Guid] = [Inv_AeX_AC_Identification].[_ResourceGuid]
WHERE [vResourceEx].[IsManaged] = 1
AND [vResourceEx].[Name] like '[a-h]%'
AND [Inv_AeX_AC_Identification].[OS Version] = '5.1'
ORDER BY [vResourceEx].[Name] ASC
__________________
|
