MsDynamics.vbs - Microsoft Dynamics AX, NAV, CRM, GP, SL monitoring using ActiveXperts Network Monitor
ActiveXperts Network Monitor ships with a powerful set of pre-defined checks. Each individual check has a static number of configuration items. To monitor other items, or to combine monitoring items, you can make use of custom VBScript checks.
Most of the built-in checks have a VBScript equivalent, implemented as a Function in a VBScript (.vbs) file. Out-of-the-box, each VBScript function monitors the same items as the built-in check. Feel free to modify a function. The VBScript check can be customized by editing the VBScript function.
To add a new VBScript-based Microsoft Dynamics Server monitoring check, do the following:
- On the 'Monitor menu', click 'New Monitoring Check (VBScript)'. The 'VBScript Check' dialog box appears;
- In the 'File selection box', select 'MsDynamics.vbs';
- In the 'Function selection box', select 'CheckDynamics';
- In the 'Function parameters group box' enter the required parameters. You can also load a working sample first by clicking on the 'Load a sample, click here' link.
To customize the above monitoring check, click on the 'Edit button' next to the 'File selection box'. Notepad will be launched. You can now make changes to the VBScript function(s).
MsDynamics.vbs script source code
' ///////////////////////////////////////////////////////////////////////////////
' // ActiveXperts Network Monitor - VBScript based checks
' // For more information about ActiveXperts Network Monitor and VBScript, visit
' // https://www.activexperts.com/support/network-monitor/online/vbscript/
' ///////////////////////////////////////////////////////////////////////////////
Option Explicit
' Declaration of global variables
Dim SYSDATA, SYSEXPLANATION ' SYSDATA is displayed in the 'Data' column in the Manager; SYSEXPLANATION in the 'LastResponse' column
' Constants - return values
Const retvalUnknown = 1 ' ActiveXperts Network Monitor functions should always return True (-1, Success), False (0, Error) or retvalUnknown (1, Uncertain)
' Constants - indexes used in arrays
Const idxServiceShortname = 0 '
Const idxServiceLongname = 1
Const idxPerfObject = 0
Const idxPerfContext = 1
Const idxPerfItem = 2
Const idxPerfCondition = 3
' // To test a function outside Network Monitor (e.g. using CSCRIPT from the
' // command line), remove the comment character (') in the following lines:
' Dim bResult
'bResult = CheckDynamics( "localhost", "", "AX2012R2A" )
'WScript.Echo "Return value: [" & bResult & "]"
'WScript.Echo "SYSDATA: [" & SYSDATA & "]"
'WScript.Echo "SYSEXPLANATION: [" & SYSEXPLANATION & "]"'
Function CheckDynamics( strHost, strAltCredentials, strVersion )
' Description:
' Checks if MS Dynamics is running; it checks the MS Dynamics services, MS Dynamics processes and MS Dynamics performance counters
' Parameters:
' 1) strHost As String - Hostname or IP address of the server you want to check
' 2) strAltCredentials As String - Specify an empty string to use Network Monitor service credentials.
' To use alternate credentials, enter a server that is defined in Server Credentials table.
' (To define Server Credentials, choose Tools->Options->Server Credentials)
' 3) strVersion As String - MS Dynamics Server version (either AX2012R2A, NAV2015, NAV2013, NAV2009,
' CRM2015, CRM2013, CRM2011, CRM4, GP2013 or SL2011)
' Usage:
' CheckDynamics( "<Hostname | IP>", "<Empty String | Server>", "<Dynamics-version>" )
' Sample:
' CheckDynamics( "localhost", "", "CRM2013" )
Dim strAltLogin, strAltPassword, objWMIService, numResult
Dim lstServices, lstProcesses, lstPerfCounters
CheckDynamics = retvalUnknown ' Default return value, and will be shown as a yellow (uncertain) icon in the Manager
SYSDATA = "" ' SYSDATA displayed in the 'Data' column in the Manager
SYSEXPLANATION = "" ' SYSEXPLANATION displayed in the 'LastResponse' column in the Manager
strAltLogin = ""
strAltPassword = ""
' Retrieve product processes/services/performance-counters list
If( Not getSoftwareInfo( strVersion, lstServices, lstProcesses, lstPerfCounters, SYSEXPLANATION ) ) Then
Exit Function
End If
' If alternate credentials are specified, retrieve the alternate login and password from the ActiveXperts global settings
If( strAltCredentials <> "" ) Then
If( Not getCredentials( strHost, strAltCredentials, strAltLogin, strAltPassword, SYSEXPLANATION )) Then
Exit Function
End If
End If
' WMI Connect
If( Not wmiConnect( strHost, strAltLogin, strAltPassword, objWMIService, SYSEXPLANATION ) ) Then
Exit Function
End If
' Check services
numResult = checkServices( objWMIService, strHost, lstServices, SYSEXPLANATION )
If( numResult <> True ) Then
CheckDynamics = numResult
Exit Function
End If
' Check processes
numResult = checkProcesses( objWMIService, strHost, lstProcesses, SYSEXPLANATION )
If( numResult <> True ) Then
CheckDynamics = numResult
Exit Function
End If
' Check performance counters
numResult = checkPerfCounters( strHost, strAltLogin, strAltPassword, lstPerfCounters, SYSEXPLANATION )
If( numResult <> True ) Then
CheckDynamics = numResult
Exit Function
End If
CheckDynamics = True
SYSEXPLANATION = "All services, processes and counters successfully checked"
End Function
' //////////////////////////////////////////////////////////////////////////////
' // --- Private Functions section ---
' // Private functions names should start with a lower case character, so they
' // will not be listed in the Network Monitor's function browser.
' //////////////////////////////////////////////////////////////////////////////
Function getSoftwareInfo( strVersion, BYREF lstServices, BYREF lstProcesses, BYREF lstPerfCounters, BYREF strSysExplanation )
' // Retrieve services, processes and counters associated to the specific version of the software. Entries that start
' // with '!' are optional services/processes/counters and are not checked by deault. Remove '!' mark to enable monitoring those items.
getSoftwareInfo = True
Select Case strVersion
Case "AX2012R2A"
lstServices = array( _
array( "AOS60$01", "Microsoft Dynamics AX Object Server 6.2$01-MicrosoftDynamicsAX" ), _
array( "AX2012R2A" , "Microsoft Dynamics AX for Commerce Data Exchange Synch Service" ), _
array( "DynAxSyncServer60", "Microsoft Dynamics AX 2012 Synchronization Service" ), _
array( "!Microsoft Dynamics AX Commerce Data Exchange: Real-time Service 5.1", "Microsoft Dynamics AXCommerce Data Exchange: Real-time Service 5.1" ), _
array( "!Microsoft Dynamics AX Commerce Data Exchange: Real-time Service 6.1", "Microsoft Dynamics AXCommerce Data Exchange: Real-time Service 6.1" ), _
array( "MSSQLSERVER", "SQL Server (MSSQLSERVER)" ), _
array( "W3SVC", "World Wide Web Publishing Service" ) )
lstProcesses = array( "Ax32Serv.exe", "AxSynchronizationService.exe", "DBServer.exe", "sqlservr.exe" )
lstPerfCounters = array( _
array( "Memory", "", "Available Bytes", ">104857600" ), _
array( "Processor", "_TOTAL", "% Processor Time", "<90" ) )
Case "NAV2015"
lstServices = array( _
array( "MicrosoftDynamicsNavServer$DynamicsNAV80", "Microsoft Dynamics NAV Server [DynamicsNAV80]" ), _
array( "!MicrosoftDynamicsNavVSS", "Microsoft Dynamics NAV Server VSS Writer" ), _
array( "!MSSQLSERVER", "SQL Server (MSSQLSERVER)" ), _
array( "!W3SVC", "World Wide Web Publishing Service" ) )
lstProcesses = array( "Microsoft.Dynamics.Nav.Server.exe", "sqlservr.exe" )
lstPerfCounters = array( _
array( "Memory", "", "Available Bytes", ">104857600" ), _
array( "Processor", "_TOTAL", "% Processor Time", "<90" ) )
Case "NAV2013"
lstServices = array( _
array( "MicrosoftDynamicsNavServer$DynamicsNAV70", "Microsoft Dynamics NAV Server [DynamicsNAV70]" ), _
array( "MSSQLSERVER", "SQL Server (MSSQLSERVER)" ), _
array( "W3SVC", "World Wide Web Publishing Service" ) )
lstProcesses = array( "Microsoft.Dynamics.Nav.Server.exe", "sqlservr.exe" )
lstPerfCounters = array( _
array( "Memory", "", "Available Bytes", ">104857600" ), _
array( "Processor", "_TOTAL", "% Processor Time", "<90" ) )
Case "NAV2009"
lstServices = array( _
array( "MicrosoftDynamicsNavServer$DynamicsNAV70", "Microsoft Dynamics NAV Server [DynamicsNAV70]" ), _
array( "MSSQLSERVER", "SQL Server (MSSQLSERVER)" ), _
array( "W3SVC", "World Wide Web Publishing Service" ) )
lstProcesses = array( "Microsoft.Dynamics.Nav.Server.exe", "sqlservr.exe" )
lstPerfCounters = array( _
array( "Memory", "", "Available Bytes", ">104857600" ), _
array( "Processor", "_TOTAL", "% Processor Time", "<90" ) )
Case "CRM2015"
lstServices = array( _
array( "MSCRMAsyncService", "Microsoft Dynamics CRM Asynchronous Processing Service" ), _
array( "!MSCRMAsyncService$maintenance", "Microsoft Dynamics CRM Asynchronous Processing Service (maintenance)" ), _
array( "MSCRMSandboxService", "Microsoft Dynamics CRM Sandbox Processing Service" ), _
array( "MSCRMUnzipService", "Microsoft Dynamics CRM Unzip Service" ) )
lstProcesses = array( "CrmAsyncService.exe", "CrmUnzipService.exe", "Microsoft.Crm.Sandbox.HostService.exe", "!Microsoft.Crm.Sandbox.WorkerProcess.exe", "sqlservr.exe" )
lstPerfCounters = array( _
array( "CRM Server", "", "Failed Organization Service Requests", "<50" ), _
array( "CRM Async Service", "", "Total Operations Outstanding", "<5" ), _
array( "CRM Authentication", "", "WindowsAuthenticationFailuresInTheLastMinute", "<5" ), _
array( "CRM Authentication", "", "PassportAuthenticationFailuresInTheLastMinute", "<5" ), _
array( "CRM Async Service", "", "Total Operations Failed", "<50" ), _
array( "Memory", "", "Available Bytes", ">104857600" ), _
array( "Processor", "_TOTAL", "% Processor Time", "<90" ) )
Case "CRM2013"
lstServices = array( _
array( "MSCRMAsyncService", "Microsoft Dynamics CRM Asynchronous Processing Service" ), _
array( "!MSCRMAsyncService$maintenance", "Microsoft Dynamics CRM Asynchronous Processing Service (maintenance)" ), _
array( "MSCRMSandboxService", "Microsoft Dynamics CRM Sandbox Processing Service" ), _
array( "MSCRMUnzipService", "Microsoft Dynamics CRM Unzip Service" ) )
lstProcesses = array( "CrmAsyncService.exe", "CrmUnzipService.exe", "Microsoft.Crm.Sandbox.HostService.exe", "!Microsoft.Crm.Sandbox.WorkerProcess.exe", "sqlservr.exe" )
lstPerfCounters = array( _
array( "CRM Server", "", "Failed Organization Service Requests", "<50" ), _
array( "CRM Async Service", "", "Total Operations Outstanding", "<5" ), _
array( "CRM Authentication", "", "WindowsAuthenticationFailuresInTheLastMinute", "<5" ), _
array( "CRM Authentication", "", "PassportAuthenticationFailuresInTheLastMinute", "<5" ), _
array( "CRM Async Service", "", "Total Operations Failed", "<50" ), _
array( "Memory", "", "Available Bytes", ">104857600" ), _
array( "Processor", "_TOTAL", "% Processor Time", "<90" ) )
Case "CRM2011"
lstServices = array( _
array( "MSCRMAsyncService", "Microsoft Dynamics CRM Asynchronous Processing Service" ), _
array( "!MSCRMAsyncService$maintenance", "Microsoft Dynamics CRM Asynchronous Processing Service (maintenance)" ), _
array( "MSCRMSandboxService", "Microsoft Dynamics CRM Sandbox Processing Service" ), _
array( "MSCRMUnzipService", "Microsoft Dynamics CRM Unzip Service" ) )
lstProcesses = array( "CrmAsyncService.exe", "CrmUnzipService.exe", "Microsoft.Crm.Sandbox.HostService.exe", "!Microsoft.Crm.Sandbox.WorkerProcess.exe", "sqlservr.exe" )
lstPerfCounters = array( _
array( "CRM Server", "", "Failed Organization Service Requests", "<50" ), _
array( "CRM Async Service", "", "Total Operations Outstanding", "<5" ), _
array( "CRM Authentication", "", "WindowsAuthenticationFailuresInTheLastMinute", "<5" ), _
array( "CRM Authentication", "", "PassportAuthenticationFailuresInTheLastMinute", "<5" ), _
array( "CRM Async Service", "", "Total Operations Failed", "<50" ), _
array( "Memory", "", "Available Bytes", ">104857600" ), _
array( "Processor", "_TOTAL", "% Processor Time", "<90" ) )
Case "CRM4"
lstServices = array( _
array( "MSCRMAsyncService", "Microsoft Dynamics CRM Asynchronous Processing Service" ), _
array( "MSSQLSERVER", "SQL Server (MSSQLSERVER)" ), _
array( "W3SVC", "World Wide Web Publishing Service" ) )
lstProcesses = array( "CrmAsyncService.exe", "sqlservr.exe" )
lstPerfCounters = array( _
array( "CRM Server", "", "Failed CrmService Requests", "<50" ), _
array( "CRM Async Service", "mscrmasyncservice", "Total Operations Outstanding", "<5" ), _
array( "Memory", "", "Available Bytes", ">104857600" ), _
array( "Processor", "_TOTAL", "% Processor Time", "<90" ) )
Case "GP2013"
lstServices = array( array( "MSSQLSERVER", "SQL Server (MSSQLSERVER)" ) )
lstProcesses = array( "Dpm.exe", "Dynamics.exe", "sqlservr.exe" )
lstPerfCounters = array( _
array( "Memory", "", "Available Bytes", ">104857600" ), _
array( "Processor", "_TOTAL", "% Processor Time", "<90" ) )
Case "SL2011"
lstServices = array( _
array( "MSSQLSERVER", "SQL Server (MSSQLSERVER)" ), _
array( "W3SVC", "World Wide Web Publishing Service" ) )
lstProcesses = array( "sqlservr.exe" )
lstPerfCounters = array( _
array( "Memory", "", "Available Bytes", ">104857600" ), _
array( "Processor", "_TOTAL", "% Processor Time", "<90" ) )
Case Else
SYSEXPLANATION = "Version [" + strVersion + "] is not supported."
lstServices = array( array( "", "" ) )
lstProcesses = array( "" )
lstPerfCounters = array( array( "", "", "", "" ) )
getSoftwareInfo = False
End Select
End Function
' //////////////////////////////////////////////////////////////////////////////
Function checkServices( objWMIService, strHost, lstCheckServices, BYREF strExplanation )
Dim lstAllServices, arrCheckService
checkServices = retvalUnknown ' Default return value
strExplanation = "Unable to check for services on this machine"
' Get the services list
If( Not retrieveServicesList( objWMIService, strHost, lstAllServices, strExplanation ) ) Then
Exit Function
End If
' Check services - only those that are not disabled by a leading '!'
For Each arrCheckService in lstCheckServices
If( arrCheckService( idxServiceShortname) <> "" And Left( arrCheckService( idxServiceShortname ), 1 ) <> "!" ) Then
If( Not isServiceRunning( lstAllServices, arrCheckService(idxServiceShortname), arrCheckService(idxServiceLongname), strExplanation ) ) Then
checkServices = False
Exit Function
End If
End If
Next
checkServices = True
strExplanation = "Services are running"
End Function
' //////////////////////////////////////////////////////////////////////////////
Function checkProcesses( objWMIService, strHost, lstCheckProcesses, BYREF strExplanation )
Dim lstAllProcesses, strCheckProcess
checkProcesses = retvalUnknown ' Default return value
strExplanation = "Unable to check for processes on this machine"
' Get the processes list
If( Not retrieveProcessesList( objWMIService, strHost, lstAllProcesses, strExplanation ) ) Then
Exit Function
End If
' Check processes - only those that are not disabled by a leading '!'
For Each strCheckProcess in lstCheckProcesses
If( strCheckProcess <> "" And Left( strCheckProcess, 1 ) <> "!" ) Then
If( Not isProcessRunning( lstAllProcesses, strCheckProcess, strExplanation ) ) Then
checkProcesses = False
Exit Function
End If
End If
Next
checkProcesses = True
strExplanation = "Processes are running"
End Function
' //////////////////////////////////////////////////////////////////////////////
Function checkPerfCounters( strHost, strAltUserName, strAltPassword, lstCheckPerfCounters, BYREF strExplanation )
Dim objPerf, strPerfPath, numPerfValue
Dim lstAllServices, arrCheckPerfCounter
Dim strEval, bCompareResult
checkPerfCounters = retvalUnknown ' Default return value
strExplanation = "Unable to check for performance counters on this machine"
' Load the ActiveXperts Network Monitor Perfomance object
Set objPerf = CreateObject( "ActiveXperts.NMPerf" )
' Initialze Performance object. Optional parameter: a log file, for debugging purposes
objPerf.Initialize( "" )
If( objPerf.LastError <> 0 ) Then
checkPerfCounters = retvalUnknown
SYSDATA = ""
SYSEXPLANATION = "Failed to initialize performance object."
Exit Function
End If
' Connect. If strAltUserName is empty, the service credentials will be used
objPerf.Connect strHost, strAltUserName, strAltPassword
If( objPerf.LastError <> 0 ) Then
checkPerfCounters = retvalUnknown
SYSDATA = ""
SYSEXPLANATION = "Failed to check performance counters (connect failed)."
objPerf.Shutdown()
Exit Function
End If
' Check performance counters - only those that are not disabled by a leading '!'
For Each arrCheckPerfCounter in lstCheckPerfCounters
If( arrCheckPerfCounter( idxPerfObject ) <> "" And Left( arrCheckPerfCounter( idxPerfObject ), 1 ) <> "!" ) Then
' Build the Peformance path
strPerfPath = objPerf.BuildPath( strHost, arrCheckPerfCounter(idxPerfObject), arrCheckPerfCounter(idxPerfContext), arrCheckPerfCounter(idxPerfItem) )
' Get integer value. If floating point is expected, use GetDoubleValue instead
numPerfValue = objPerf.GetIntegerValue( strPerfPath )
If( objPerf.LastError <> 0 ) Then
checkPerfCounters = False
SYSDATA = ""
SYSEXPLANATION = "Performance Counter [" & strPerfPath & "] is not installed"
Exit Function
End If
strEval = numPerfValue & " " & arrCheckPerfCounter(idxPerfCondition)
bCompareResult = Eval( strEval )
If( Not bCompareResult ) Then
checkPerfCounters = False
SYSDATA = numPerfValue
SYSEXPLANATION = "Performance Counter [" & strPerfPath & "], Condition[" & arrCheckPerfCounter(idxPerfItem) & arrCheckPerfCounter(idxPerfCondition) & "] failed, Current Value=[" & numPerfValue & "]"
Exit Function
End If
End If
Next
objPerf.Shutdown()
checkPerfCounters = True
strExplanation = "Performance counters checked"
End Function
' //////////////////////////////////////////////////////////////////////////////
Function retrieveServicesList( objWMIService, strHost, BYREF lstServices, BYREF strSysExplanation )
' Retrieve the list of running services
retrieveServicesList = False
Set lstServices = Nothing
On Error Resume Next
Set lstServices = objWMIService.ExecQuery( "Select * from Win32_Service" )
If( Err.Number <> 0 ) Then
strSysExplanation = "Unable to query WMI class on computer [" & strHost & "]"
Exit Function
End If
On Error Goto 0
If( lstServices.Count <= 0 ) Then
strSysExplanation = "Win32_Service class does not exist on computer [" & strHost & "]"
Exit Function
End If
retrieveServicesList = True
End Function
' //////////////////////////////////////////////////////////////////////////////
Function retrieveProcessesList( objWMIService, strHost, BYREF lstProcesses, BYREF strSysExplanation )
' Retrieve the list of running services
retrieveProcessesList = False
Set lstProcesses = Nothing
On Error Resume Next
Set lstProcesses = objWMIService.ExecQuery( "Select * from Win32_Process" )
If( Err.Number <> 0 ) Then
strSysExplanation = "Unable to query WMI class on computer [" & strHost & "]"
Exit Function
End If
On Error Goto 0
If( lstProcesses.Count <= 0 ) Then
strSysExplanation = "Win32_Process class does not exist on computer [" & strHost & "]"
Exit Function
End If
retrieveProcessesList = True
End Function
' //////////////////////////////////////////////////////////////////////////////
Function isServiceRunning( BYREF lstServices, strServiceName, strServiceDescription, BYREF strExplanation )
' Check if a given service exists as running service in the services list
Dim objService
For Each objService in lstServices
' Check If this is the service we are looking for
If( LCase( objService.Name ) = LCase( strServiceName ) ) Then
If( objService.State = "Running" ) Then
isServiceRunning = True
Else
strExplanation = "Service [" & strServiceDescription & "] service is not running"
isServiceRunning = False
End If
Exit Function
End If
Next
' The service was not found, show an error message
strExplanation = "Service [" & strServiceDescription & "] is not installed"
isServiceRunning = False
End Function
' //////////////////////////////////////////////////////////////////////////////
Function isProcessRunning( BYREF lstProcesses, strProcess, BYREF strExplanation )
' Check if a given process exists as running process in the processes list
Dim objProcess
For Each objProcess in lstProcesses
If( Err.Number <> 0 ) Then
isProcessRunning = retvalUnknown
strExplanation = "Unable to list processes"
Exit Function
End If
' Check If this is the service we are looking for
If( LCase( objProcess.Name ) = LCase( strProcess ) ) Then
isProcessRunning = True
Exit Function
End If
Next
' The process was not found, show an error message
strExplanation = "Process [" & strProcess & "] is not running"
isProcessRunning = False
End Function
' //////////////////////////////////////////////////////////////////////////////
Function getCredentials( strHost, strAltCredentials, BYREF strAltLogin, BYREF strAltPassword, BYREF strSysExplanation )
Dim objNMServerCredentials
strAltLogin = ""
strAltPassword = ""
strSysExplanation = ""
getCredentials = False
If( strAltCredentials = "" ) Then
' No alternate credentials specified, so login and password are empty and service credentials will be used
getCredentials = True
Exit Function
End If
Set objNMServerCredentials = CreateObject( "ActiveXperts.NMServerCredentials" )
strAltLogin = objNMServerCredentials.GetLogin( strAltCredentials )
strAltPassword = objNMServerCredentials.GetPassword( strAltCredentials )
If( strAltLogin = "" ) Then
getCredentials = False
strSysExplanation = "No alternate credentials defined for [" & strAltCredentials & "]. In the Manager application, select 'Options' from the 'Tools' menu and select the 'Server Credentials' tab to enter alternate credentials"
Exit Function
End If
getCredentials = True
End Function
' //////////////////////////////////////////////////////////////////////////////
Function wmiConnect( strHost, strAltLogin, strAltPassword, BYREF objWMIService, BYREF strSysExplanation )
Dim objSWbemLocator, colItems
Dim bConnectResult
wmiConnect = False
Set objWMIService = Nothing
If( strAltLogin = "" ) Then
' Connect to remote host on same domain using same security context
On Error Resume Next
Set objWMIService = GetObject( "winmgmts:{impersonationLevel=Impersonate}!\\" & strHost &"\root\cimv2" )
If( Err.Number <> 0 ) Then
bConnectResult = False
Else
bConnectResult = True
End If
On Error Goto 0
Else
' Connect to remote host using different security context and/or different domain
On Error Resume Next
Set objSWbemLocator = CreateObject( "WbemScripting.SWbemLocator" )
Set objWMIService = objSWbemLocator.ConnectServer( strHost, "root\cimv2", strAltLogin, strAltPassword )
If( Err.Number <> 0 ) Then
bConnectResult = False
Else
bConnectResult = True
End If
objWMIService.Security_.ImpersonationLevel = 3
On Error Goto 0
End If
If( Not bConnectResult ) Then
Set objWMIService = Nothing
wmiConnect = False
strSysExplanation = "Unable to connect to [" & strHost & "]. Possible reasons: no WMI installed on the remote server, firewall blocking WMI calls, login failure, or remote server down"
Exit Function
End If
wmiConnect = True
End Function