Active IQ Unified Manager Discussions
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
Can you give me the query that you are trying ? Then let me take a look and figure out.
of course - here is the SQL query.
FROM DFMGROUP.volumeView volumeView INNER JOIN DFMGROUP.hostView hostView ON volumeView.volHostId=hostView.hostId
The requirement is to verify the availability of vFiler resources.
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:
Status Name signifies the status of the object as determined by the dfmmonitor.
NetApp Wins One Silver and One Bronze Stevie® Award in 2022 Stevie Awards for Sales and Customer Service
Live Chat, Watch Parties, and More!
Engage digitally throughout the sales process, from product discovery to conﬁguration, and handle all your post-purchase needs.