Analytics and reporting ServiceNow – Case Study

About the client

An American Fast-food company having 37,855 restaurants located globally.

Requirements

To identify and manage the risks in the infrastructure of all locations (Several departments of the Security, in-charge of the handling of different sections of the infrastructure such as AD/LDAP, DNS, SMART, VDS, AS, SSL, PKI, Threats, Vulnerability and more). Need to communicate with all departments of all locations collect data and generate customized analytical reports. Automate the manual collection of data and generate manual reports.

Challenges

Communicate with all the departments and access the statistical data stored at different locations. Data stored in different format as XLS, CSV, XML, etc.

Solution Provided

Collected data using various data sources as JDBC, XML, HTML, CSV, Excel, email attachments, etc. Processed the data and stored in custom tables. Create user interactive charts, reports and role-based dashboards using Performance Analytics module.

Benefits

Provide the right data to the right people to make better decisions. Creates on-demand reports in real time. Permit viewing of 100+ custom reports. Drastic reduction in time by generating automated reports than generating manual reports.