Agent Tables

Started by richard21, December 09, 2022, 05:07:16 PM

Previous topic - Next topic

richard21

I have a Script that is populating an External table with the status of Veeam Backup Jobs.
this is working and I can see the table in the client however I cant create an instance for each row bassed on the index to allow me to create thresholds for each backup.

if i create a table DCI and use tablename(1) then I just get in supported 

Filipp Sudanov

Can you show your external table configuration in agent configuration file?

richard21

Hi Filipp,

sorry for the late reply I only just saw your reply this is the external table config in the agent config

[ExternalTable/VeeamJobs]
Command = powershell C:\tools\Get-VeeamJobs.ps1
Separator = |
InstanceColumns=Name
Description=Veeam Backup Jobs
PollingInterval = 60
ColumnType = Index:int32
ColumnType = Name:string
ColumnType = Status:string
ColumnType = Result:string
ColumnType = StartTime:string
ColumnType = EndTime:string
ColumnType = Duration:float
ColumnType = HrsSinceLastRun:float

Filipp Sudanov

And what is in Columns in table properties?

richard21

This is the table properties within NETXMS

Victor Kirhenshtein

I probably do not completely understand what the issue is. Configuration looks correct, you set "Name" column as instance column, not an "Index". But it should work both ways.