We have recently upgraded to ir12 but we now have the following issue when
browsing through the web console under 'Reports/Inventory Usage' this
error returns only when browsing by "inventory Type", "Platform", "Virtual
Machine Type" in system group.

The data you requested is not available.

Details: [Microsoft][ODBC SQL Server Driver][SQL Server]Column
'nc_workstation.InventoryType' is invalid in the select list because it is
not contained in either an aggregate function or the GROUP BY clause.

or

The data you requested is not available.

Details: [Microsoft][ODBC SQL Server Driver][SQL Server]Column
'nc_workstation.AssetType' is invalid in the select list because it is not
contained in either an aggregate function or the GROUP BY clause

or

The data you requested is not available.

Details: [Microsoft][ODBC SQL Server Driver][SQL Server]Column
'nc_workstation.VirtualMachineType' is invalid in the select list because
it is not contained in either an aggregate function or the GROUP BY clause