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

  • 7011774
  • 11-Feb-2013
  • 11-Feb-2013


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


How to run dbisql when only putty is available


  1. To get the zenadmin password type:
    zman dgc
  2. Create a script like below, substitute the zenadmin password for "pwd" below:
    /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:
    ./ e4db7d363ff62f61eaf2edcac0cbe194