cancel
Showing results for 
Search instead for 
Did you mean: 

Tables where Alert information is stored in solman

former_member204080
Active Contributor
0 Kudos

Hi All,

I need the table name/infocube name where Alert information which is collected from managed system gets stored in solution manager.

I am looking for table which contains below details

System ID:

Alert name:

Minimum Threshold:

Maximum Threshold:

Current Value of Alert:


Could you please suggest on this

Regards,

Murali

Accepted Solutions (0)

Answers (2)

Answers (2)

nicolasberthier
Explorer
0 Kudos

Hi Murali,

why do you need a direct access to the tables? I believe that in Solman this configuration is stored under the ACTEMPLATE* tables, but it will be quite difficult to extract intelligible information out of them

If you need to report on the configuration, I would suggest to navigate to SOLMAN_SETUP, Technical Monitoring, Step 4 Template Configuration, select your template, and should find around here an Export to HTML of Export to Excel option

Hope that helps,

Nicolas

former_member204080
Active Contributor
0 Kudos

Hi Nicolas,

Thanks for your reply .I have the template related information

I wanted tables where current threshold values of managed systems are stored

Regards,

Murali

former_member204080
Active Contributor
0 Kudos

Hi All,

Could you please help with above Query

Is there any option through which we can collect the current threshold of each managed system and send it to Third party application

nicolasberthier
Explorer
0 Kudos

Hi Murali,

unfortunately I think there is no option to directly export the threshold information as a such

Nicolas

MichaelFoley
Advisor
Advisor
0 Kudos

Hi Murali,

You can use mai_tools to check for metric details, threshold information etc.

Here you can use the Managed Object ID & Metric ID to get more information.

If they are pull RFC metrics, then this can be checked easily also.

As regards tables, there are many of these which contain information relating to MEA information.

What are the tables needed for?

Regards

Michael

former_member204080
Active Contributor
0 Kudos

Hi Michael,

Thanks for your reply

Reason why i wanted the tables information is i want to extract that data and provide it to other application

Is there any option how i can extract these values with meaningful description to the fields

Regards,

Murali