Script to run dbisql from command line Example: to get content for bundle

  • Document ID:7011774
  • Creation Date:11-Feb-2013
  • Modified Date:11-Feb-2013
    • Micro Focus Products:
      ZENworks Configuration Management

Environment

Novell ZENworks Configuration Management 11.2
 
Example to get bundle name per content.

Situation

How to run dbisql when only putty is available

Resolution

  1. To get the zenadmin password type:
    zman dgc
  2. Create a script like below, substitute the zenadmin password for "pwd" below:
    #!     /bin/bash
    /opt/novell/zenworks/share/sybase/bin32s/dbisql -c "uid=zenadmin;pwd=Zw0#e629ce423a2891e30d6d1fe9b" -nogui -d1 -onerror exit "select DisplayName from zBundle where zBundle.ZUID in (select ContainingObjectUID from zLinkedObject where ContentUID = 0x$1 );"
  3. chmod 755 scriptname
  4. Run the script with parameter of content guid.  Example:
    ./dbquery.sh e4db7d363ff62f61eaf2edcac0cbe194