Export System Monitoring App Performance Dashboard data in CSV

[Former Member]

Hello,

I would like to know if it was possible to extract the data of Solution Manager Dashboard (System Monitoring App Performance) inside a flat file ?

I found some information on this page :<a data-mce-href="http://help.sap.de/saphelp_sm71_sp08/helpdata/en/66/2076c2a5964bf1a8ef6c79626aea2e/content.htm?frameset=/en/2c/0803ca76f949778c2578a9e814cbe5/frameset.htm&amp;current_toc=/en/81/6f8fe54f854ef2bd412c8660f5ed6e/plain.htm&amp;node_id=715&amp;fullscreen=true" href="http://help.sap.de/saphelp_sm71_sp08/helpdata/en/66/2076c2a5964bf1a8ef6c79626aea2e/content.htm?frameset=/en/2c/0803ca76f949778c2578a9e814cbe5/frameset.htm&amp;current_toc=/en/81/6f8fe54f854ef2bd412c8660f5ed6e/plain.htm&amp;node_id=715&amp;fullscreen=true" title="http://help.sap.de/saphelp_sm71_sp08/helpdata/en/66/2076c2a5964bf1a8ef6c79626aea2e/content.htm?frameset=/en/2c/0803ca76f949778c2578a9e814cbe5/frameset.htm&amp;current_toc=/en/81/6f8fe54f854ef2bd412c8660f5ed6e/plain.htm&amp;node_id=715&amp;fullscreen=true">System Monitoring App: Performance - System Reporting in SAP Solution Manager - SAP Library</a>

The query name is

0SMD_DASH_SYSMON_PERFORMANCE and I would like to use RSANWB on the cube

0CCMPDATA to create a flat file but maybe they are a easier solution ?

Thank you

[Former Member]

I have tried to find the information in a another way :

TEMPLATE_ID=0E2EREP_ALLSYS_SYSTEMPING

VAR_NAME_1=0SMDVTST

VAR_VALUE_LOW_EXT_1=201408010000  (begin date of the day)

VAR_VALUE_HIGH_EXT_1=201408132359 (end date of the day)

FILTER_IOBJNM_2=0SMD_TIHM

FILTER_VALUE_2=0SMDVTIHMCM

FILTER_VALUE_TYPE_2=VARIABLE_EXIT

FILTER_IOBJNM_3=0CALDAY

FILTER_VALUE_3=0VDAYCM

FILTER_VALUE_TYPE_3=VARIABLE_EXIT

FILTER_IOBJNM_4=0SMD_GRTI

FILTER_VALUE_4=DAY

FILTER_IOBJNM_5=0SMD_GRDA

FILTER_VALUE_5=DAY

USE_PAGE_WRAPPER=PING

VAR_NAME_7=0SMD_V_SID_M

VAR_VALUE_EXT_7= <SID> (SID of the system)

VAR_NAME_8=0SMD_V_SID_INT

VAR_VALUE_LOW_EXT_8=%23VAR_VALUE_HIGH_EXT_8=#

VAR_NAME_99=0SMD_V_INFOPR

VAR_VALUE_EXT_99=0SMD_PE2H

VAR_NAME_98=0SMD_V_INFOPR

VAR_VALUE_EXT_98=0SMD_PEH1

VAR_NAME_97=0SMD_V_INFOPR

VAR_VALUE_EXT_97=0SMD_PEH2

Do you think how can i export that information in a CSV ?

[gsbasra99]

Hello Marc, I am replying you on this post very late but you can  activate the same from below method...Hope it will work for you also.. Start transaction code RSA1 (BW Setup) Click on "BI content" Click on "Object Types" Navigate to "Query Elements" - "Query" - "Select Objects" Double Click Navigate to "SAP Solution Manager - Custom Code Lifecycle Management" you can put yours query name in find search then by clicking on "Transfer" Flag on the right side all entries and click on "Install" with sub selection "Install".. Regards, Gagandeep