Good Morning
I am getting a JSON validation error in the following result:
{
"data":[
{ "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "BI01" },
{ "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "CIGAM01" },
{ "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "META01" },
{ "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL03", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL03", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL04", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL04", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "CIGAM05" },
{ "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "CIGAMTESTE05" },
{ "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "magicxpi_1" },
{ "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "MGXPI4_1" },
{ "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "CIGAM06" },
{ "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "CIGAMBI06" },
{ "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "CIGAMHOMOLOGACAO06" },
{ "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "CIGAM07" },
{ "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "CIGAMHOMOLOGACAO07" },
{ "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "CIGAMTESTE07" },
{ "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "CIGAM08" },
{ "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "CIGAMHOMOLOGACAO08" },
{ "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "CIGAMTESTE08" },
{ "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL09", "{#DATABASE}" : "CIGAM09" },
{ "{#INSTANCE}" : "FWCCIGSQL09", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL09", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL10", "{#DATABASE}" : "CIGAM10" },
{ "{#INSTANCE}" : "FWCCIGSQL10", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL10", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL11", "{#DATABASE}" : "CIGAM11" },
{ "{#INSTANCE}" : "FWCCIGSQL11", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL11", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL12", "{#DATABASE}" : "CIGAM12" },
{ "{#INSTANCE}" : "FWCCIGSQL12", "{#DATABASE}" : "CIGAMHOMOLOGACAO12" },
{ "{#INSTANCE}" : "FWCCIGSQL12", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL12", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL13", "{#DATABASE}" : "CIGAM13" },
{ "{#INSTANCE}" : "FWCCIGSQL13", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL13", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "CIGAM02" },
{ "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "CIGAMHOMOLOGACAO02" },
{ "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "CIGAMTESTE02" },
{ "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL14", "{#DATABASE}" : "CIGAM14" },
{ "{#INSTANCE}" : "FWCCIGSQL14", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL14", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL15", "{#DATABASE}" : "CIGAM15" },
{ "{#INSTANCE}" : "FWCCIGSQL15", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL15", "{#DATABASE}" : "msdb" }
]}
I have this same discovery rule on other servers and all are working, the only difference I noticed in this case was the underline in the name of some bases. Is that the problem? If it is, how to solve? I can not change the base name ...
My Zabbix is in version: 3.4
thanks a lot for any help.
I am getting a JSON validation error in the following result:
{
"data":[
{ "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "BI01" },
{ "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "CIGAM01" },
{ "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "META01" },
{ "{#INSTANCE}" : "FWCCIGSQL01", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL03", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL03", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL04", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL04", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "CIGAM05" },
{ "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "CIGAMTESTE05" },
{ "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "magicxpi_1" },
{ "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "MGXPI4_1" },
{ "{#INSTANCE}" : "FWCCIGSQL05", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "CIGAM06" },
{ "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "CIGAMBI06" },
{ "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "CIGAMHOMOLOGACAO06" },
{ "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL06", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "CIGAM07" },
{ "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "CIGAMHOMOLOGACAO07" },
{ "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "CIGAMTESTE07" },
{ "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL07", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "CIGAM08" },
{ "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "CIGAMHOMOLOGACAO08" },
{ "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "CIGAMTESTE08" },
{ "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL08", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL09", "{#DATABASE}" : "CIGAM09" },
{ "{#INSTANCE}" : "FWCCIGSQL09", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL09", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL10", "{#DATABASE}" : "CIGAM10" },
{ "{#INSTANCE}" : "FWCCIGSQL10", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL10", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL11", "{#DATABASE}" : "CIGAM11" },
{ "{#INSTANCE}" : "FWCCIGSQL11", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL11", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL12", "{#DATABASE}" : "CIGAM12" },
{ "{#INSTANCE}" : "FWCCIGSQL12", "{#DATABASE}" : "CIGAMHOMOLOGACAO12" },
{ "{#INSTANCE}" : "FWCCIGSQL12", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL12", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL13", "{#DATABASE}" : "CIGAM13" },
{ "{#INSTANCE}" : "FWCCIGSQL13", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL13", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "CIGAM02" },
{ "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "CIGAMHOMOLOGACAO02" },
{ "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "CIGAMTESTE02" },
{ "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL02", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL14", "{#DATABASE}" : "CIGAM14" },
{ "{#INSTANCE}" : "FWCCIGSQL14", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL14", "{#DATABASE}" : "msdb" },
{ "{#INSTANCE}" : "FWCCIGSQL15", "{#DATABASE}" : "CIGAM15" },
{ "{#INSTANCE}" : "FWCCIGSQL15", "{#DATABASE}" : "master" },
{ "{#INSTANCE}" : "FWCCIGSQL15", "{#DATABASE}" : "msdb" }
]}
I have this same discovery rule on other servers and all are working, the only difference I noticed in this case was the underline in the name of some bases. Is that the problem? If it is, how to solve? I can not change the base name ...
My Zabbix is in version: 3.4
thanks a lot for any help.