I have been trying to create a nested subgroup expression. All but one part is working.
First is sort by Company Name (Working) - CustomProperty1
Next is sort by system type (Working) - IIF (GuestOperatingSystemName LIKE '*Server*', 'Servers', IIF (GuestOperatingSystemName LIKE '*Mac*', 'Macs', IIF (GuestOperatingSystemName LIKE '*Windows*', 'Workstations', 'Other')))
Last is sort by OS version (Issue with Mac) IIF (GuestOperatingSystemName LIKE '*Windows XP*', 'Windows XP', IIF (GuestOperatingSystemName LIKE '*Windows Vista*', 'Windows Vista', IIF (GuestOperatingSystemName LIKE '*Windows 7*', 'Windows 7', IIF (GuestOperatingSystemName LIKE '*Windows 8*', 'Windows 8', IIF (GuestOperatingSystemName LIKE '*Windows 10*', 'Windows 10', IIF (GuestOperatingSystemName LIKE '*Server 2003*', 'Server 2003', IIF (GuestOperatingSystemName LIKE '*Small Business Server 2008*', 'Small Business Server 2008', IIF (GuestOperatingSystemName LIKE '*Small Business Server 2011*', 'Small Business Server 2011', IIF (GuestOperatingSystemName LIKE '*Server 2008 R2*', 'Server 2008 R2', IIF (GuestOperatingSystemName LIKE '*Server (R) 2008*', 'Server 2008', IIF (GuestOperatingSystemName LIKE '*Server 2012 R2*', 'Server 2012 R2', IIF (GuestOperatingSystemName LIKE '*Server 2012*', 'Server 2012', IIF (GuestOperatingSystemName LIKE '*Server 2016*', 'Server 2016', IIF (GuestOperatingSystemName LIKE '*10.6*', 'Snow Leopard', IIF (GuestOperatingSystemName LIKE '*10.7*', 'Lion', IIF (GuestOperatingSystemName LIKE '*10.8*', 'Mountain Lion', IIF (GuestOperatingSystemName LIKE '*10.9*', 'Mavericks', IIF (GuestOperatingSystemName LIKE '*10.10*', 'Yosemite', IIF (GuestOperatingSystemName LIKE '*10.11*', 'El Capitan', 'Other')))))))))))))))))))
All of the Windows systems are sorting correctly, but none of the Mac's are. The subgroup under Macs only shows "Other" and puts all systems in that. My guess is that the . (10.8) is the issue but I only have a basic understanding of the expressions and have not been able to resolve this. Any help and explanations to improve my knowledge would be greatly appreciated.
Below is the full expression that is in the All Machines Subgrouping.
CustomProperty1, IIF (GuestOperatingSystemName LIKE '*Server*', 'Servers', IIF (GuestOperatingSystemName LIKE '*Mac*', 'Macs', IIF (GuestOperatingSystemName LIKE '*Windows*', 'Workstations', 'Other'))), IIF (GuestOperatingSystemName LIKE '*Windows XP*', 'Windows XP', IIF (GuestOperatingSystemName LIKE '*Windows Vista*', 'Windows Vista', IIF (GuestOperatingSystemName LIKE '*Windows 7*', 'Windows 7', IIF (GuestOperatingSystemName LIKE '*Windows 8*', 'Windows 8', IIF (GuestOperatingSystemName LIKE '*Windows 10*', 'Windows 10', IIF (GuestOperatingSystemName LIKE '*Server 2003*', 'Server 2003', IIF (GuestOperatingSystemName LIKE '*Small Business Server 2008*', 'Small Business Server 2008', IIF (GuestOperatingSystemName LIKE '*Small Business Server 2011*', 'Small Business Server 2011', IIF (GuestOperatingSystemName LIKE '*Server 2008 R2*', 'Server 2008 R2', IIF (GuestOperatingSystemName LIKE '*Server (R) 2008*', 'Server 2008', IIF (GuestOperatingSystemName LIKE '*Server 2012 R2*', 'Server 2012 R2', IIF (GuestOperatingSystemName LIKE '*Server 2012*', 'Server 2012', IIF (GuestOperatingSystemName LIKE '*Server 2016*', 'Server 2016', IIF (GuestOperatingSystemName LIKE '*10.6*', 'Snow Leopard', IIF (GuestOperatingSystemName LIKE '*10.7*', 'Lion', IIF (GuestOperatingSystemName LIKE '*10.8*', 'Mountain Lion', IIF (GuestOperatingSystemName LIKE '*10.9*', 'Mavericks', IIF (GuestOperatingSystemName LIKE '*10.10*', 'Yosemite', IIF (GuestOperatingSystemName LIKE '*10.11*', 'El Capitan', 'Other')))))))))))))))))))