280. Mobility - Touch Apps - Database Service

Connection to Touch Apps Database is required for the Touch Apps Server to function. This check will alert if the Touch Apps Server cannot connect to the to the Touch Apps Database with the corresponding System ID.

Multiple Instances: Yes (per Touch Apps server)

Interval: Every 5 minutes (288 times per day)

Status

Expression

Critical

If (SQL Server System Certificate response != HTTP 200)

Description	The SystemID related to the TouchApps installation need to be used when querying by command line.
Impact	All mobile access to Touch Apps is affected. No user can access the Touch Apps from their mobile clients. The MS SQL database for Touch Apps is not available.
Suggestion	Verify that the Touch Apps MS SQL database is running.

If not status Critical.

Metric & Service	Command line example
SQL Server System Certificate	java -jar application-monitoring-metrics-cli.jar http -url https://<fqdn>:<port>/Downlink.svc/resource/Ifs.Cloud.BaseResources.SystemCertificate" -post {\"SystemID\":\"myssystemid.ifsworld.com\"}" -match=response -oeq=200 -dc