Packt+ | Advance your knowledge in tech

You're reading from ServiceNow: Building Powerful Workflows Automating IT Service Management

Product type Course

Published in Aug 2017

Publisher Packt

ISBN-13 9781788628730

Length 1330 pages

Edition 1st Edition

Languages

JavaScript

Tools

ServiceNow

Concepts

IT Service Management

Authors (3):

Tim Woodruff

Martin Wood

Ashish Rudra Srivastava

View More author details

Table of Contents (39) Chapters

Title Page

Credits

Preface

1. Module 1 FREE CHAPTER

Learning ServiceNow

2. The Interface

3. Lists and Forms

4. UI Customization

5. Understanding Data and Relationships

6. Tasks and Workflows

7. UI and Data Policies

8. User Administration and Security

9. Introduction to Scripting

10. The Server-side Glide API

11. The Client-side Glide API

12. Server-side Scripting

13. Client-side Scripting

14. Debugging

15. Pro Tips

16. Module 2

ServiceNow Cookbook

17. Getting Started with Service-Now

18. Performing Core Configuration and Management Tasks

19. Building Data-Driven Application

20. Configuring Alerts and Notifications

21. Building and Configuring Reports

22. Creating and Configuring Workflow Activities

23. Auditing and Diagnosing Service-Now

24. Module 3

Mastering ServiceNow

25. ServiceNow Foundations

26. Developing Custom Applications

27. Server-Side Control

28. Client-Side Interaction

29. Getting Things Done with Tasks

30. Events, Notifications, and Reporting

31. Exchanging Data – Import Sets, Web Services, and other Integrations

32. Securing Applications and Data

33. Diagnosing ServiceNow – Knowing What Is Going On

34. Packaging with Applications, Update Sets, and Upgrades

35. Making ServiceNow Beautiful with Service Portal and Custom Interfaces

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...

Open a web browser (Google Chrome, Firefox, Safari, or Internet Explorer).
Type the instance web address in the address bar.
Log in to the Service-Now instance using the credentials.
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...