|
Got it in a Report - but need it as a collection
well here is what I came up with as a report:
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] >= 'rl' AND [vResourceEx].[Name] <= 'Z') AND [Inv_AeX_AC_Identification].[OS Version] = '5.1' ORDER BY [vResourceEx].[Name] ASC
I will now focus on turning this into a collection query - but it's a start.
titan90
|
