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

[rtoubali]

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é

[adaikkap]

Hi Rabe,

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

Regards

adai

[rtoubali]

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é

[adaikkap]

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