Support Centre

Find articles, help and advice.

Welcome, Guest Login

Support Center

BES - Rex script to query database produce a CSV file

Last Updated: Jul 30, 2015 03:47PM UTC
Attached to this knowledge base article is a rex script. When run it queries the BES Database for all yesterdays alerts, which have an IncidentID. Customers have used this to produce a CSV output with all the Alerts which have raised Incident tickets, in there corresponding Incident Management System. E.g. (Remedy, Service-Now ect.) 

I have also attached some example SQL which does the following, this may help if you want to query other data:
  • Example SQL to give yesterdays BES / Remedy Alerts
  • Example SQL to give todays BES / Remedy Alerts
  • Example SQL to give current live BES / Remedy Alerts

Contact Us
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found