Hi Dojo
A Lifecycle Service Orchestration (LSO) script needs to set alarm templates on certain elements when they are getting booked. These elements are child Dynamic Virtual Elements (DVE). To set the alarm templates, I would need to know the ID's of these child DVE's.
For now, my approach is to cast the Skyline.DataMiner.Net.Messages.Resource object to a Skyline.DataMiner.Net.ResourceManager.Objects.FunctionResource object as this makes the ID of the parent DVE available. But I seem to be stuck here.
SrmResourceConfiguration[] resources = srmBookingConfiguration.GetResources().ToArray();
foreach (var resource in resources)
{
FunctionResource functionResource = resource.Resource as FunctionResource;
Element element = engine.FindElement(functionResource.MainDVEDmaID, functionResource.MainDVEElementID);element.SetAlarmTemplate(alarmTemplateName);
}
What is the best approach to be able to retrieve the element ID's of these child elements?
Thank you in advance!
Kind regards
Hi Michiel,
A better way to do it, is by using the LinkerTableEntries property present in your FunctionResource object.
This tuple contains the [Generic DVE Linker Table] mapping (see table below) between the primary key ([Linker Index]) of your functionResource and the DVE PK ([FK Data]).
You can see this table by open your main element and then clicking on GENERAL PARAMETERS => Configure...
After getting your DVE PK, you can search in your exportTable (in this example is 3000) for the elementId/dmaId.
Below is an example of code that you can use:
public class ExtCard
{
private const int ExportedTableId = 3000;public static string GetDveDmaIdElementId(ScriptInfo script, FunctionResource resource)
{
try
{
var dveGenericLinkerTable = resource.LinkerTableEntries.FirstOrDefault();
if (dveGenericLinkerTable != null)
{
return GetDveExportedTableElement(script, resource, dveGenericLinkerTable.Item2);
}
}
catch (Exception)
{
// ignore
}return string.Empty;
}private static string GetDveExportedTableElement(ScriptInfo script, FunctionResource resource, string dvePk)
{
try
{
var columns = script.Engine.GetColumns(
resource.MainDVEDmaID,
resource.MainDVEElementID,
ExportedTableId,
new uint[] { 0 /*Pk*/, 2 /*ElementInfo*/ },
(string dveIdx, string dveElementInfo) => new { DveIdx = dveIdx, DveElementInfo = dveElementInfo });foreach (var row in columns)
{
if (row.DveIdx == dvePk)
{
return row.DveElementInfo;
}
}
}
catch (Exception)
{
// ignore
}return string.Empty;
}
}
Please, let me know if you have any questions.
Hi Michiel,
I assume your FunctionResources are generated from a table (entrypoint)? Your FunctionResource object will have a reference to the row it's generated from in the LinkerTableEntries property.
Depending on the structure of the parent connector, it should be possible then to map this entry to the entry in the table where the DVE is generated from? That row should contain a column with the element id of that DVE.
Please let me know in case this explanation is not clear, because it's not that straight forward to explain.
Hi Michiel,
A possible solution is to add the element info of your DVE as property on the resource.
Hi Jens, thank you for your answer! To be honest I was hoping that the ID’s would be available in one of the resource-related objects without defining extra properties but okay, we can consider your suggestion. Much appreciated!
Thanks to Joey's tip I was able to create the following snippet which will set the alarm template of the selected child DVE:
ExportTable extExportTable = new ExportTable
{
Id = 3000,
NameColumnIdx = 1,
ElementColumnIdx = 2
};Element parentDve = engine.FindElement(functionResource.MainDVEDmaID, functionResource.MainDVEElementID);
object[] dveTable = parentDve.GetColumns(exportTable.Id, new[] { exportTable.NameColumnIdx, exportTable.ElementColumnIdx });Element functionDve = engine.FindElement(functionResource.DmaID, functionResource.ElementID);
//functionDve.ElementName: iControl.EXT.40
string shortName = functionDve.ElementName.Remove(0, functionDve.ElementName.IndexOf('.') + 1).Replace(".", "-");
//shortName: EXT-40
if (dveTable.Any())
{
object[] dveNames = (object[])dveTable[0];
object[] dveIds = (object[])dveTable[1];//dveNames[0]: EXT-40 dveIds[0]: 123/456
Dictionary<string, string> dveIdsByName = new Dictionary<string, string>();
for (int i = 0; i < dveNames.Length; i++)
{
dveIdsByName[Convert.ToString(dveNames[i])] = Convert.ToString(dveIds[i]);
}if (dveIdsByName.TryGetValue(shortName, out string id))
{
string[] childDveId = id.Split('/');
Element childDve = engine.FindElement(Convert.ToInt32(childDveId[0]), Convert.ToInt32(childDveId[1]));
childDve.SetAlarmTemplate(alarmTemplateName);
}
}public class ExportTable
{
public int Id { get; set; }/// <summary>
/// Gets or sets the index of the column which holds the DVE names.
/// </summary>
public int NameColumnIdx { get; set; }/// <summary>
/// Gets or sets the index of the column which holds the DVE ID's.
/// </summary>
public int ElementColumnIdx { get; set; }
}
Hi Joey, thanks a lot for your answer! Indeed, I should retrieve the table that generates the DVE’s. In the meantime I foud a way to do it.