how to get message details from database in OMW

[Banu_Prakash]

Im planning to integrate OMW with third party tools, is there any command or database query  or WMI q uerywhere i can get the following message details of an alert. ( i dont want to use ovowmsgutil to download messages to csv files)

Im using OMW 9.10

Need following items from message details:

1) Node Name

2) Alert created Time

3) object,

4) application

5) severity

6) message text

[Gio-Jitsu]

I've used a vbs script based on an example for email notifications that use WMI to get the event details.

The script gets activated by a WMI policy that is triggered by each new instance of event.

I don't have the script at hand but if you check the example templates for email notifications you get 80% of the way there.

I hope this can get you on track.

Gio.

[Ram_21 · Accepted solution]

Hello

You can use WMI to get all this information. The instance of OV_Message class in the name space "root\hewlettpackard\openview\data" will give you the list of messages. You can build standard WMI scripts to do this.

Hope this helps.
Regards

Ram

[Banu_Prakash]

Thanks Ram, i will try this and will let you know how it goes.

[Banu_Prakash]

Thanks again. I got the solution by querying wmi and have used wmi template to capture msg id's of new incoming messages.

Set colItems = objWMIService.ExecQuery("Select * from OV_Message where  Id = """ & val1 & """")