<div>
What are the parameters &quot;8000 5000&quot;? &nbsp;The failed one uses that and the working one uses &quot;6000 9000&quot;? 
 
Is it possible the nagios execution is running a different script from a different folder? 
 
Can you post the script?
</div>

<div>
Without seeing your script, nothing we can say.
</div>

<div>
I already tried changing the values. 
 
/usr/local/nagios/etc/objects/windowsservers# /usr/lib/nagios/plugins/check_nrpe -t 50 -H 'SERV014-N1' -c &nbsp;check_sqldbsize -a &quot;SERV014-N1-SQLC\ORF 6000 9000&quot; 
C:\Program Files\NSClient++\scripts\check_sqldbsize.vbs(25, 15) Microsoft VBScript runtime error: Type mismatch: 'cint' 
 
Here is the script. 
 

<pre><code class="code-10 nolinks" id="code-20-42730289-1">'
' Check_SQLDBSize.vbs v1.1
'
' Nagios Plugin for checking SQL DB Size
' Tested with NSClient++ v0.4.1.105, Nagios Core 4.0.8 and SQL Server 2008 Express
'
' Author: Gregor Blaj
' Email: gregor[at]nzsystems[dot]com
' Created on: 29/04/2015
'
' Credit to
' https://gallery.technet.microsoft.com/scriptcenter/a6a9d2a4-705f-4e37-86db-33caca7473cb
' http://www.codeproject.com/Tips/469070/SQL-Server-Get-All-Databases-Size
'
' Change Log
' 1.1: Exclude Log from DB size
'

Const adOpenStatic = 3
Const adLockOptimistic = 3
 
Dim dbserver : dbserver = WScript.Arguments.Item(0)
Dim dbname : dbname = WScript.Arguments.Item(1)
Dim dbwarn : dbwarn = cint(WScript.Arguments.Item(2))
Dim dbcrit : dbcrit = cint(WScript.Arguments.Item(3))
'Dim dbuser : dbuser = WScript.Arguments.Item(4)
'Dim dbpwd : dbpwd = WScript.Arguments.Item(5)
Dim dbsize

Set objConnection = CreateObject(&quot;ADODB.Connection&quot;)
Set objRecordSet = CreateObject(&quot;ADODB.Recordset&quot;)

objConnection.Open _
 &quot;Provider=SQLOLEDB;Data Source=&quot; &amp; dbserver &amp; &quot;;&quot; &amp; _
 &quot;Trusted_Connection=Yes;Initial Catalog=&quot; &amp; dbname &amp; &quot;;&quot; ' &amp; _
 ' &quot;User ID=sa;Password=password;&quot;
 
objRecordSet.Open &quot;SELECT d.name, ROUND(SUM(mf.size) * 8 / 1024, 0) Size_MBs FROM sys.master_files mf INNER JOIN sys.databases d ON d.database_id = mf.database_id WHERE d.database_id &gt; 4 AND d.name='&quot; &amp; dbname &amp; &quot;' AND type_desc &lt;&gt; 'Log' GROUP BY d.name&quot;, _
 objConnection, adOpenStatic, adLockOptimistic
 
While NOT objRecordSet.EOF
 For Each field In objRecordSet.Fields
 dbsize = field.Value
 next
 objRecordSet.MoveNext
Wend

if dbsize &gt; dbcrit then
 wscript.echo &quot;CRITICAL: &quot; &amp; ucase(dbname) &amp; &quot; database size is &quot; &amp; dbsize &amp; &quot; MB.&quot;
 exitcode = 2
elseif dbsize &gt; dbwarn then
 wscript.echo &quot;WARNING: &quot; &amp; ucase(dbname) &amp; &quot; database size is &quot; &amp; dbsize &amp; &quot; MB.&quot;
 exitcode = 1
else
 wscript.echo &quot;OK: &quot; &amp; ucase(dbname) &amp; &quot; database size is &quot; &amp; dbsize &amp; &quot; MB.&quot;
 exitcode = 0
end if

wscript.quit exitcode
</code></pre>
 
 
The SA account and password are the same for each instance. 
 
Same vbs script is called for each of the checks.
</div>

Member_2_6492660_1

<div>
Yes that fixed it 
I was using the same syntax that I see when connect to my sql server manage console. 
 
Thank you for all the help
</div>

<div>
<div class="content wysiwyg-content">
Nagios Core 4.3.4 &nbsp; running on Ubuntu 17.4 
Nsclient 4.3 
Windows 2012 R2 
SQL 2012 and 2014 
 
I have a Nagios plugin check_sqldbsize.vbs that checks the size of my sql databases. 
 
On my SQL 2012 server I have one instance and the check works fine from the server and from Nagios. 
 
On my SQL 2014 server I have three (3) instances I have 1 of the three working the other two give me this error CINT 
 
 
 
/usr/local/nagios/etc/objects/windowsservers# /usr/lib/nagios/plugins/check_nrpe -t 50 -H 'SERV014-N1' -c check_sqldbsize -a 'SERV014-N1-SQLC\ORF 8000 5000' 
C:\Program Files\NSClient++\scripts\check_sqldbsize.vbs(25, 15) 
 
 
/usr/local/nagios/etc/objects/windowsservers# /usr/lib/nagios/plugins/check_nrpe -t 50 -H 'SERV014-N1' -c check_sqldbsize -a 'SERV014-N1-SQLS\WSS_Content 8000 5000' 
 
C:\Program Files\NSClient++\scripts\check_sqldbsize.vbs(25, 15) Microsoft VBScript runtime error: Type mismatch: 'cint' 
 
 
from the server I ran the command against both instances and it works fine. 
 
C:\Program Files\NSClient++\scripts&gt;cscript check_sqldbsize.vbs SERV014-N1-SQLC ORF 6000 9000 
Microsoft (R) Windows Script Host Version 5.8 
Copyright (C) Microsoft Corporation. All rights reserved. 
 
OK: ORF database size is 3 MB. 
 
C:\Program Files\NSClient++\scripts&gt;cscript check_sqldbsize.vbs SERV014-N1-SQLS WSS_Content 6000 9000 
Microsoft (R) Windows Script Host Version 5.8 
Copyright (C) Microsoft Corporation. All rights reserved. 
 
OK: WSS_CONTENT database size is 45 MB. 
 
 
The error only happens when I run this o my Nagios server 
Microsoft VBScript runtime error: Type mismatch: 'cint' 
 
Any ideas on the CINT error?
</div>
</div>

Nagios Core 4.3.4   running on Ubuntu 17.4
Nsclient 4.3
Windows 2012 R2
SQL 2012 and 2014

I have a Nagios plugin check_sqldbsize.vbs that checks the size of my sql databases.

On my SQL 2012 server I have one instance and the check works fine from the server and from Nagios.

On my SQL 2014 server I have three (3) instances I have 1 of the three working the other two give me this error CINT



/usr/local/nagios/etc/objects/windowsservers# /usr/lib/nagios/plugins/check_nrpe -t 50 -H 'SERV014-N1' -c check_sqldbsize -a 'SERV014-N1-SQLC\ORF 8000 5000' 
C:\Program Files\NSClient++\scripts\check_sqldbsize.vbs(25, 15) 


/usr/local/nagios/etc/objects/windowsservers# /usr/lib/nagios/plugins/check_nrpe -t 50 -H 'SERV014-N1' -c check_sqldbsize -a 'SERV014-N1-SQLS\WSS_Content 8000 5000'

C:\Program Files\NSClient++\scripts\check_sqldbsize.vbs(25, 15) Microsoft VBScript runtime error: Type mismatch: 'cint'


from the server I ran the command against both instances and it works fine. 

C:\Program Files\NSClient++\scripts>cscript check_sqldbsize.vbs SERV014-N1-SQLC ORF 6000 9000
Microsoft (R) Windows Script Host Version 5.8
Copyright (C) Microsoft Corporation. All rights reserved.

OK: ORF database size is 3 MB.

C:\Program Files\NSClient++\scripts>cscript check_sqldbsize.vbs SERV014-N1-SQLS WSS_Content 6000 9000
Microsoft (R) Windows Script Host Version 5.8
Copyright (C) Microsoft Corporation. All rights reserved.

OK: WSS_CONTENT database size is 45 MB.


The error only happens when I run this o my Nagios server
Microsoft VBScript runtime error: Type mismatch: 'cint'

Any ideas on the CINT error?

VBScript runtime error: Type mismatch: 'cint'

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.

Windows Server 2012

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.