Hi again gang… I just needed to whip together a quick-n-dirty cheatsheet for connecting to the internal Sybase database on a Zenworks 10 Configuration Management server. I work on many different servers (customers and whatnot) and this is one of those things I need to have in a handy place for reference. I hope it helps you, too!<\/p>\n
(**NOTE: All the examples in this post are based on a Windows server, so I’ll add the WindowsGeneral tag… but those Linux-user readers out there will be able to figure out how to do the same thing on their systems… \ud83d\ude09 )<\/p>\n
Enter the following at a command prompt on the server: …this will give you the userrname and password for the local db user. The password will be a long crazy string, and that is the actual password, not encrypted. Copy it to Notepad or just the clipboard for now.<\/p>\n Launch the Interactive SQL tool: Supply the user ID and password from the earlier command. A cool command you might want to enter is (this is all one command, but you can enter this on multiple lines in the dbisql tool): (**NOTE: This SQL command is similar to the one on Novell TID 7001146, but their TID has a typo and won’t work.)<\/p>\n …And click the play\/run button. Or if you’re really brave, or have a small db, …and so on. From the db commands you can get a feel for what the database looks like, and I suppose the table are documented somewhere…<\/p>\n So I hope this gets you started…. Have fun! Hi again gang… I just needed to whip together a quick-n-dirty cheatsheet for connecting to the internal Sybase database on a Zenworks 10 Configuration Management server. I work on many different servers (customers and whatnot) and this is one of…
\nzman dgc<\/code><\/p>\n
\n[zen dir]\\share\\ASA\\win32\\dbisql.exe<\/code><\/p>\n
\nOn the Database tab, click Find and select the zone server that should be found automatically.
\nBrowse to the db file that should be at [zen dir]\\database\\<\/code>
\nUncheck the “Start database…” and “Stop database…” options, and click OK.
\nYou should now be connected.<\/p>\n
\nselect d.DNS, d.Site, i.UpdateStatus
\nfrom zDevice d join zSystemUpdateDeviceInfo i
\non d.ZUID = i.DeviceUID
\nwhere i.UpdateStatus != 'FINISHED';<\/code><\/p>\n
\nselect * from zDevice;<\/code>
\n…or…
\nselect * from zSystemUpdateDeviceInfo;<\/code><\/p>\n
\n\ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"
Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11,20,53],"tags":[],"class_list":["post-131","post","type-post","status-publish","format-standard","hentry","category-intermediate","category-windowsgeneral","category-zcm10"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pnjn1-27","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=\/wp\/v2\/posts\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=131"}],"version-history":[{"count":3,"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=\/wp\/v2\/posts\/131\/revisions"}],"predecessor-version":[{"id":133,"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=\/wp\/v2\/posts\/131\/revisions\/133"}],"wp:attachment":[{"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yourLinuxGuy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}