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
-
To get the zenadmin password type:
zman dgc -
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 );" -
chmod 755 scriptname
-
Run the script with parameter of content guid. Example:
./dbquery.sh e4db7d363ff62f61eaf2edcac0cbe194