3 Replies Latest reply: May 24, 2013 5:33 AM by adaikkap RSS

OnCommand UCM (DFM) Views using Database Access, Value Description

rtoubali
Currently Being Moderated

Hello,

a customer of mine wants to use DFM database views for SLA reporting. They are using Crystal Reports to acccess and query the DFM Database Views (cf. Technical Report 3690, p. 21, figure 18).

Do we have  any description/explaination for the values such as "volStatusCode (here '16')" and "HostStatus " or better that following row of column-value can have.

 

hostName hostStatus hostPinghostPingTimestamp hostDownTimestamp hostSta volFullName volState volStatus volStatusCode HostStatus&Ping

hostname Normal Up 06.03.2013 08:45:28 21.07.2012 21:58:13 3 hostname:/volumeName offline Normal 16 Wahr

Thank you,

Rabé

  • Re: OnCommand UCM (DFM) Views using Database Access, Value Description
    adaikkap
    Currently Being Moderated

    Hi Rabe,

         Can you give me the query that you are trying ? Then let me take a look and figure out.

     

    Regards

    adai

    • Re: OnCommand UCM (DFM) Views using Database Access, Value Description
      rtoubali
      Currently Being Moderated

      Hi Adai,

       

      of course - here is the SQL query.

       

      SELECT

      volumeView.volFullName,

      hostView.hostName,

      hostView.hostStatus,

      hostView.hostPingStatus,

      hostView.hostPingTimestamp,

      hostView.hostDownTimestamp,

      hostView.hostStatusCode,

      hostView.hostType,

      volumeView.volState,

      volumeView.volStatusCode,

      volumeView.volStatus,

      hostView.hostId,

      hostView.hostPrimaryAddress

      FROM DFMGROUP.volumeView volumeView INNER JOIN DFMGROUP.hostView hostView ON volumeView.volHostId=hostView.hostId

       

      The requirement is to verify the availability of vFiler resources.

       

      Thank you,

      Rabé

      • Re: OnCommand UCM (DFM) Views using Database Access, Value Description
        adaikkap
        Currently Being Moderated

        Hi Rabe,

        The statusMap table has a mapping of the object status (event, controller, volume, … ) against a numerical constants.

        The monitor sets the objStatus for each of the object to values for ‘statusName’. The source uses the statusIndex rather than the text field.

        All the numerical values are powers of 2

         

        The possible values for this field are as follows:

         

        "statusName","statusIndex"

        "Normal","16"

        "Warning","48"

        "Unknown","32"

        "Error","64"

        "Critical","80"

        "Emergency","96"

        "N/A","24"

        "Information","28"

         

        Status Name signifies the status of the object as determined by the dfmmonitor.

         

        Regards

        adai

More Like This

  • Retrieving data ...