Notices


 
 
LinkBack Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 20-Jul-2009, 02:35 PM
Junior Member
 
Join Date: Jul 2009
Posts: 9
stephenrjaeger 0 reputation points
Default Reporting and queries

Is there a way in ZEN to develop SQL queries? I have been doing this in Tivoli and would like to find a way in ZEN. For instance I would like to be able to set up something like this:
(PACKAGE_NAME like 'Mozilla Thunderbird %')

AND
"TME_OBJECT_LABEL" NOT IN
(select "TME_OBJECT_LABEL"
from "NATIV_SWARE_VIEW"
where "PACKAGE_NAME" = 'Mozilla Thunderbird (2.0.0.22)')

order by TME_OBJECT_LABEL
Of course the tables and the column names would be different.
I just do not see how to apply the operators that are available in ZEN to accomplish this.
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -6. The time now is 01:56 PM.


© 2007 Novell, Inc. All Rights Reserved.

Search Engine Friendly URLs by vBSEO 3.3.0 RC2