When using the Group field in views within the ITA Console, the only available values listed for this field are 'None'.
The underlying database view vIT_Analytics_SEP_GroupDim selects records from the IDENTITY_MAP table in the SEPM database with a 'DELETED' value of NULL. Records with a 'DELETED' value of 0 are not selected.
Release : 2.9.0
This issue is resolved in IT Analytics version 2.9.1. Upgrading is the recommended solution.
Alternatively, this issue can be resolved by altering the openquery statement in the view vITAnalytics_SEP_GroupDim to select records that have a 'DELETED' value of either NULL or 0.
To make this change, follow this procedure:
AND DELETED IS NULL')
AND (DELETED IS NULL OR DELETED = 0)')