Intro to CMDB Query Builder with Reporting - Performance Analytics Academy - Aug 12, 2020

What is the CMDB Query Builder? Can I leverage it in Reporting & Performance Analytics? In this Office Hours, we discussed how and why you should use the CMDB Query Builder as another tool when building out Reporting & Performance Analytics in ServiceNow.

There are many cases when accessing data in the CMDB may be difficult through traditional reporting. With the CMDB Query Builder, we can have that data at our fingertips and build the Reporting that we need for many Use Cases.

Chapters
0:00 Introduction
02:17 Main Presentation
06:47 Demo
26:33 Q&A

#CSDM #CMDB #DataFoundations

[shembop]

Something we had to add is a business rule to make it so that people could not update, or delete reports that they didn't create. I also would love to see ways to organize or filter. Right now (Paris), it is one big pallet of all the queries that were created, so I have to hunt for my things.

[jenniferschoenhoeft]

I have created and saved my report query but it is duplicating the data in my report. Also the create report button is not displaying on the query builder form after I save it. So to work around this, I create a new report from the run, clicking context menu in the header and select bar chart from one of my columns. I update the report the way I want it and save. As soon as the job runs, it has duplicate CIs in it. Then triple when it runs again. I thought to go back and rebuild the query and not schedule it but then after 1 day, the query is gone. OOTB does it delete unscheduled query's?

[RobertCampbellIT]

When viewing a report that was created from query builder, users get "Number of rows removed from this list by Security contraints: 20" and are unable to view any of the data but they are able to go to the query and run it but that will generate a new query result.

[UncleF]

how to query ip address with corresponding computer/server name? from gui i can see ip addr is added under CI IPs tab, but not a parent/child relationship. so in query builder i cannot link the 2 together. pls advice.