UCMDB custom reporting
I'm exploring the possibility of using a custom report to extract information from UCMDB butI am unsure of which table to query for the relationship. I'm trying to create a host resources report, which would include the host, CPU, memory and filesystem.
I assumed this would be based on the CMDB_ID column in each table, but I haven't been able to locate anything that links the IDs together. Any ideas?
The uCMDB database is a bit hard to data mine.
The uCMDB GUI offers extensive reporting features.
Wouldn't it make sense to make use of those?
Further, there's a custom reporting Jython package which you can use.
Check out the Live Net for that.
Thanks for replying so quickly 🙂
I'm stuck with uCMDB 8 with CP8 at the moment, so I'm not sure if the package is a viable option.
Well the reason I'm looking into this is because the report layout doesn't suit my use. I'd like to have all that information in a single row for each host, but if I were to build a host resource TQL, it generates a report with multiple rows, which looks really messy especially when you have multiple CPUs and filesystems. Unless I'm doing it the wrong way, in which case feel free to correct me.
Any suggestions would be most welcome
Any luck with getting this report generated from the DB directly? I have a similar requirement, would appreciate your help here.
Did you generate this report from the GUI instead? Which report did you use?
It's certainly not easy! I managed to get Host, CPU, Memory and IP to display, but joining all of them together isn't going so well. Still trying to figure out the Applications, zero progress on that.
Maybe someone can expand further on this. Unless I'm going about this the wrong way...
Select * from CDM_HOST_1, CDM_LINK_1, CDM_CPU_1
Where CDM_HOST_1.CMDB_ID = CDM_LINK_1.END1_ID And CDM_CPU_1.CMDB_ID = CDM_LINK_1.END2_ID
I'm using Crystal Report at the moment because the report from UCMDB GUI looks good in the browser, but exporting to Excel is pretty messy for me.
Thanks for such a quick reply.
Another question related to the report from GUI:
From the GUI when you export a report from the browser to an excel sheet, it only exports the current visible page of the report to the sheet? That's what happens when I try to export that report.
Is there a way I can export that entire report (about 10000 results but only 1 is shown on a single page) to a single excel sheet with a single export click?
Can't help you on that, sorry. I had no issues exporting to Excel, but I get the same thing as you when exporting to PDF. Then again, I was exporting host resources report, and I have only about 100+ servers. I did run into a problem exporting software report though, 60k+ records, and I couldn't export it at all.
BTW, does anyone know where the software installed date is? Can't find it in the software table 😞
Well, if the Jython reporting package won't work (I feel your pain on version 8.x....), you could use the Java API and write the code yourself. The developers reference isn't too bad for a place to start, and there should be methods to pull whatever attribute you want by CI type.
Plus, if you write the code, you have complete control over the output format, which is nice (I remember how painful it was trying to export to Excel in version 8...)