How to create a report based on a GlideList field of a change table?

chilakalasa
Tera Contributor

2 hours ago

I'm working on a requirement to show reports on a dashboard for change requests. I'm able to create simple single score cards and bar graphs through standard reporting.

 

However, there's a report requirement where I need to create a report based on GlideList. Each change can have field that is of GlideList type. I've to create a bar graph to represent list of changes per element (cmdb_ci_site) in the dashboard.

ChangeSites (GlideList)
CHG001SITE-A, SITE-C
CHG002SITE-A, SITE-B, SITE-C
CHG003SITE-B, SITE-D
CHG004SITE-A, SITE-C, SITE-D

 

SiteChanges
SITE-A3 (CHG001, CHG002, CHG004)
SITE-B2 (CHG002, CHG003)
SITE-C3 (CHG001, CHG002, CHG004)
SITE-D2 (CHG003, CHG004)

 

I've looked at using scripted indicator sources (Needs PA license) or DB view based reporting. Is there a simpler approach to implement this?

 

Thanks in Advance!

Teja 

0 Helpfuls
  • 83 Views
1 REPLY 1

Mark Manders
Giga Patron

an hour ago

Yes, approach it from the 'site' table. With a bit of luck you already have a 'related list' that shows you the changes. You can use related list conditions to get the changes per site that way. 

If it's really about the numbers, a data base view will be needed.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
0 Helpfuls