Hi, I have a protocol that uses the "GetDynamicTableIndices" request to retrieve indices of a table in another element. This works fine on Cassandra and legacy MySQL data storage, but when using this call on a STaaS system, I get this error:
"Getting distinct keys is not supported for CloudStorage"
Is there any alternative to get the keys on a DaaS or STaaS system?
my example code:
public static List<string> getTableIndices(int dmaid, int eid, int pid, SLProtocol protocol, bool trendOnly = false)
{
List<string> result = new List<string>();
GetDynamicTableIndices gdti = new GetDynamicTableIndices(dmaid, eid, pid);
if (trendOnly)
{
gdti.Filter = GetDynamicTableIndicesType.AvgTrendedFromDB;
}DynamicTableIndicesResponse dtir = protocol.SLNet.SendSingleResponseMessage(gdti) as DynamicTableIndicesResponse;
foreach (DynamicTableIndex dti in dtir.Indices)
{
result.Add(dti.DisplayValue);
}
return result;
}
Hi Michiel,
Unfortunately, I don't think we have a workaround for this particular call. Is there a reason why you are interested in the table indices that have trend data in the database?
Kind regards,
Louis


Using 'AvgTrendedOnly' instead of 'AvgTrendedFromDB' will provide some indices, but will exclude those that were previously trended and are now excluded. It won't be possible to get the indices that have been trended in the past. However, if interested I can check whether this can be supported in the future.

Hi Louis, 'AvgTrendedOnly' is a workaround that will probably work for most cases. However, there are a few cases I think will no longer be covered, mainly processes that have some starts and stops. This could be services that have stopped unexpectedly and are no longer running at the time the analysis runs, or applications that can be started and stopped by the user. So if the 'AvgTrendedFromDB' could work, that would be nice.
Hi Louis, this is used in a protocol that does further automatic analysis on the trend history of the Task Manager table in Microsoft Platform elements. In typical setups, trending will only be enabled for a subset of processes that are of interest.