Work modes information - solution manager 7.2

[SAPSupport]

Hi Support,

We are currently publishing the availability information in power BI dashboard using BW info provider in sap solution manager 7.2 (S1P).

We are using the BW info provider 0CCMPDATA//STDF/QD_AVAILABILITY_M to fetch the availability information for managed systems.

Similarly, we are looking for such info provider name, where we can fetch the work modes (planned downtime) information for managed systems.

Can you please help with the info provider that contains the work modes information in sap solution manager 7.2 for managed systems?

Thanks,

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear Customer

We can suggest the query “0SMD_WMM_AVAIL_HOUR” (Availability in hours) to get downtime information.

The input parameter list looks like below, where you can filter the output based on a timeframe. 0SMD_V_TIHM is one of the input parameters. If you want to filter based on any other parameters such as System ID, then you mention it as a filter value.

The output of the query should contains 3 fields:

Unplanned Downtime

Non-Availability Due to Downtime: The time when the system was actually brought down

Total Downtime: Total scheduled downtime of a system

Please refer to the method “cl_aiccmsbi_wmm_reporting_as->get_bw_downtime” where you can go through the use of the query “0SMD_WMM_AVAIL_HOUR” for reference.

Regards