I pulled together this SQL to put my vms in 4 groups to try to split up the inventory load. Here is my example. You just have to change the ntile value to the number of groups you want and then change the Groups filter. In this example it shows all VMs in group 1.
WITH VMSplits AS
(
SELECT
cmp.Guid
,cmp.Domain
,cmp.Name
,HW.Manufacturer AS [System Manufacturer]
,ROW_NUMBER() OVER (ORDER BY Guid) as 'RowNumber'
,ntile(4) OVER (ORDER BY Guid) as [Groups]
FROM vComputer as CMP
LEFT OUTER JOIN dbo.vHWComputerSystem AS HW ON cmp.Guid = HW._ResourceGuid
Where hw.Manufacturer like 'VMWare%'
)
Select
*
From VMSplits
Where Groups = 1