topic Re: OnCommand UCM (DFM) Views using Database Access, Value Description in Active IQ Unified Manager Discussions

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

rtoubali — Thu, 05 Jun 2025 06:04:28 GMT

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 — Thu, 25 Apr 2013 10:02:05 GMT

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 — Tue, 30 Apr 2013 13:18:10 GMT

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 — Fri, 24 May 2013 12:33:11 GMT

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