IT Service Management
Showing results for 
Search instead for 
Do you mean 

HP Service Manager (SM) 9.32: How to improve query or table join performance

Yvonne_Bentley ‎09-25-2013 12:55 PM - edited ‎10-04-2015 09:21 PM

Our exploration of HP Service Manager 9.32 continues today with a spotlight on cross-table  query. HP Service Manager 9.32 boasts several enhancements to the cross-table query feature that were designed to significantly improve system performance when handling certain ad-hoc SQL queries. 


Prior to HP Service Manager 9.32, a query running across two tables pulled the data from the database and then performed the join operation locally in memory. That operation on large volumes of data was inherently resource-intensive and seriously impacted performance. Now, with HP Service Manager 9.32, Service Manager attempts to parse and convert the query to pure SQL, which is then passed to the Relational Database Management System (RDBMS).  The RDBMS then executes the initial join operation, thereby minimizing in-memory processing, and returns the results of the query to HP Service Manager.


What the enhanced cross-table query feature means for you:


  • Improved Performance

Previously, ad-hoc SQL queries could run very slowly. This was especially true when searching a large volume of data, when searching two or more tables or if the query required grouping or sorting. The ability to run cross table queries more efficiently in HP Service Manager 9.32 makes loading data in various screens recognizably faster because so many screens rely on ad-hoc queries. In fact, due to the use of the cross table query feature, performance when loading the Inbox in HP Service Manager has improved by as much as 100 times!


  • Greater Productivity

The addition of the cross table join feature also helps to eliminate the need for any difficult JavaScript code optimizations when tailoring HP Service Manager 9.32. This allows administrators to focus on business logic, instead of spending valuable time optimizing code. This feature can also simplify the process of defining views, without having to perform JavaScript code optimizations, users no longer need to consider the potential performance impact of a written query. 


  • Reduced Maintenance Effort

With the new cross-table query mechanism, the duplication of data is also unnecessary. This effectively reduces the maintenance effort by making data modifications (for example, in master data) simpler and faster to perform.


Check out this video to see the new and improved cross-table query in action. We’ve demonstrated two use cases in which the power of the cross-table query feature is realized. The first scenario involves an IT Manager who wants to see
all incidents closed by people within his department in the last 30 days. The second use case describes an Incident Analyst, who wants to see interactions that have an attached incident whose status is “work in progress.” 



I also encourage you to learn more about the enhancements made to HP Service Manager 9.32 highlighted in these blog posts:

Let me know what you think in the comments below. As always, please visit for all things HP Service Manager and ITSM. And be sure to follow us on Twitter at @HPITSM 


Special thanks to Christopher Patti for his contributions to this article!


What have been your most challenging experiences reporting across tables in Service Manager?   We’d like to hear from you. 

About the Author


A 25+ year veteran of HP, Yvonne is currently a Senior Product Manager of HP ITSM software including HP Service Anywhere and HP Service Manager. Over the years, Yvonne has had factory and field roles in several different HP businesses, including HP Software, HP Enterprise Services, HP Support, and HP Imaging and Printing Group. Yvonne has been masters certified in ITIL for over 10 years and was co-author of the original HP IT Service Management (ITSM) Reference Model and Primers.

on ‎11-27-2014 12:31 PM

 I did not know this yet. I guess it was also much needed.  Good video.  Thank you.

Nov 29 - Dec 1
Discover 2016 London
Learn how to thrive in a world of digital transformation at our biggest event of the year, Discover 2016 London, November 29 - December 1.
Read more
Each Month in 2016
Software Expert Days - 2016
Join us online to talk directly with our Software experts during online Expert Days. Find information here about past, current, and upcoming Expert Da...
Read more
View all