NetXMS Support Forum

English Support => General Support => Topic started by: richard21 on December 09, 2022, 05:07:16 PM

Title: Agent Tables
Post by: richard21 on December 09, 2022, 05:07:16 PM
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 
Title: Re: Agent Tables
Post by: Filipp Sudanov on December 14, 2022, 06:47:33 PM
Can you show your external table configuration in agent configuration file?
Title: Re: Agent Tables
Post by: richard21 on March 23, 2023, 09:49:53 AM
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
Title: Re: Agent Tables
Post by: Filipp Sudanov on April 11, 2023, 01:41:50 PM
And what is in Columns in table properties?
Title: Re: Agent Tables
Post by: richard21 on April 17, 2023, 10:00:34 AM
This is the table properties within NETXMS
Title: Re: Agent Tables
Post by: Victor Kirhenshtein on April 26, 2023, 03:50:40 PM
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.