Book Image

ServiceNow: Building Powerful Workflows

By : Tim Woodruff, Martin Wood, Ashish Rudra Srivastava
Book Image

ServiceNow: Building Powerful Workflows

By: Tim Woodruff, Martin Wood, Ashish Rudra Srivastava

Overview of this book

ServiceNow is a SaaS application that provides workflow form-based applications. It is an ideal platform for creating enterprise-level applications, giving requesters and fulfillers improved visibility and access to a process. ServiceNow-based applications often replace email by providing a better way to get work done. This course will show you how to put important ServiceNow features to work in the real world. We will introduce key concepts and examples on managing and automating IT services, and help you build a solid foundation towards this new approach. You will then learn more about the power of tasks, events, and notifications. We’ll then focus on using web services and other mechanisms to integrate ServiceNow with other systems. Further on, you’ll learn how to secure applications and data, and understand how ServiceNow performs logging and error reporting. At the end of this course, you will acquire immediately applicable skills to rectify everyday problems encountered on the ServiceNow platform. The course provides you with highly practical content explaining ServiceNow from the following Packt books: 1. Learning ServiceNow 2. ServiceNow Cookbook 3. Mastering ServiceNow, Second Edition
Table of Contents (39 chapters)
Title Page
Credits
Preface
Free Chapter
1
Module 1
36
Bibliography

Creating a database view


Service-now provides system tables in which the data is stored and the product also provides a facility to create a custom table for a custom application, but it is worth to note that most of tables refer to each and other. On many occasions, clients ask for reports which are hard to get from a single table or a reporting module. In such a case, you can use the database view to connect more than one table to get the desired report. In this recipe, you will learn to create a database view.

Getting ready

For this recipe, you need an active service-now instance, valid credentials, and an admin role.

How to do it...

  1. Open a web browser (Google Chrome, Firefox, Safari, or Internet Explorer).
  2. Type the instance web address in the address bar.
  3. Log in to the Service-Now instance using the credentials.
  4. In the left-hand search box, type database view but Database Viewsmodule is not available under the reporting module and only available for admins. Click on Database views module under...