[Check_mk (english)] Error with: check_mk_active-sql: query is 'select count(No_) from [Prodata Systems nv_sa$Unit]'

Eric Lecocq Eric.Lecocq at prodata-systems.be
Thu Jul 7 16:32:51 CEST 2016


Hello,

As you can see, I tried to escape the $ sign with ‘\’, but without success. Any idea ?

check_mk_active-sql! --hostname '$HOSTADDRESS$' --dbms 'mssql' --name '<DBName>' --user '<User>' --password '<Psw>' 'select count(No_) from [Prodata Systems nv_sa\\$Unit]'


Best regards,

Eric

From: Marcel Schulte [mailto:schulte.marcel at gmail.com]
Sent: mardi 5 juillet 2016 19:33
To: Eric Lecocq <Eric.Lecocq at prodata-systems.be>; checkmk-en at lists.mathias-kettner.de
Subject: Re: [Check_mk (english)] Error with: check_mk_active-sql: query is 'select count(No_) from [Prodata Systems nv_sa$Unit]'


Hi Eric,

Did you try masking the character (like "\$" or similar)?

BTW: that's just a thought, I do not use that check ;)

Regards,
Marcel

Eric Lecocq <Eric.Lecocq at prodata-systems.be<mailto:Eric.Lecocq at prodata-systems.be>> schrieb am Di., 5. Juli 2016 17:32:
Hello,

Maybe a silly question but i’m checking a mssql DB with the following query : 'select count(No_) from [Prodata Systems nv_sa$Unit]’
Check_mk says that there is an error near ‘$’… But in sql management studio this is not a problem. Do you have any idea about this ?

Thank you in advance,

Eric.


_______________________________________________
checkmk-en mailing list
checkmk-en at lists.mathias-kettner.de<mailto:checkmk-en at lists.mathias-kettner.de>
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mathias-kettner.de/pipermail/checkmk-en/attachments/20160707/78d565bc/attachment-0001.html>


More information about the checkmk-en mailing list