I understand that my storage device support SMI-S standard. However, I don't see such profile support in profile manager. How can I discover it?

SMI-S profile is storage management initiative specification which is designed in accordance with WBEM standard. To discover devices such as storage arrays and tape libraries, you can configure credential profile using WBEM protocol which in turn use SMI-S specification CIM classes for data collection.

Refer following link for WBEM profile configuration by selecting vendor and model of interest -
http://www.sapphireims.com/help/Profile_Manager_Asset.htm

Refer following link to configure discovery rule by specifying discovery type with IP details and choosing WBEM credential –
http://www.sapphireims.com/help/Discovering_your_Network.htm