10-21-2013 01:32 AM - last edited on 12-24-2013 07:59 PM by maikoro
I'm trying to get a trial install of HP SHR 9.30 going in order to see whether the reporting capability will meet a customer's requirements for BSM OMi events.
The install itself went fine, but going through the configuration wizard and getting to step 3, it always fails when trying to create the DB.
I've tried following some of the troubleshooting steps, but just thought I'd ask here as well in case anyone came across this before.
Thanks in advance.
P.S. This thread has been moved from Application Perf Mgmt (BAC / BSM) Support and News Forum to Systems Management (OpenView-OP Mgmt) Support and News Forum. - Hp Forum Moderator
Solved! Go to Solution.
10-21-2013 04:48 AM - edited 10-21-2013 04:48 AM
Maybe just to ask a different question, one of my customers needs to be able to pull monthly reports on all OMi events. As far as I know, there's no way to do this in BSM, unless the report is pulled by manually exporting closed events to a CSV file (and will not be feasible).
Is installing SHR the absolute only way of being able to pull any meaningful reports on OMi events, or is there a less cumbersome solution to this?
10-21-2013 06:58 AM
The error may occur due to lack of permissions. Please check if you have full permissions on folder
Also, edit the pmdbconfig.cfg file and verify if the <databaseserver> instance was created correctly.
If needed, correct it here.
Hope this helps,
10-21-2013 07:08 AM
I thought you can do this via Custom Query Builder, sample type Event, but after further looking at it, it seems this is about SiteScope events only, not BSM/OMi events.
Another option would be to query the OPR database directly (I guess that's what SHR would do as well).
We cannot tell you anything about the table layout, but the names should be self-explaining.
SELECT top 10 *FROMALL_EVENTS where state='CLOSED'order by time_created desc
would return the last / newest 10 events which have been closed.
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
10-22-2013 12:20 AM
I know OMi is understandably limited, but I can't grasp the reporting capability on it being as limited as it is.
Really hoping that the reporting around OMi is vastly improved in a future release of BSM.
Back to the issue though, I'll look into both SHR and direct DB querying further, will provide feedback as soon as we've made some progress.
Thanks again for the help so far, appreciate it.