ucsql

'ucsql' is a new scripting/automation tool that accesses the UCS Data Management Engine (DME) using SQL, translated over the XML/API.

Currently ‘ucsql’ is targeted for customers of UCS Central, who wish to have scripted/automated access for reporting purposes.

Among the features and benefits of ‘ucsql’:

- ‘ucsql’ exploits the common API between UCS Manager and UCS Central: the same version of ‘ucsql’ can be used for either/both UCS Manager and UCS Central.
- ‘ucsql’ has the ability to show/describe the UCS managed object schema, including a list of all available classes, as well as the attributes for a given class, as in “show table”.
- ‘ucsql’ provides “sessions”, similar to ‘goUCS’, so that customers can run secure scripted commands, without interactive credential prompting