RE: TEMS Custom SQL Query?
John Alvord <jalvord-r/[email protected]> Fri, 18 Oct 2013 08:18:46 -0700
| Newsgroups | gmane.comp.sysutils.tivoli.general |
|---|---|
| Message-ID | <OF224748DF.D1D9DA69-ON88257C08.0053F5DB-88257C08.00541C0F__30435.5856300846$1382109548$gmane$org@us.ibm.com> |
This is a multipart message in MIME format. --===============1134653002== Content-Type: multipart/alternative; boundary="=_alternative 00541C0D88257C08_=" This is a multipart message in MIME format. --=_alternative 00541C0D88257C08_= Content-Type: text/plain; charset="US-ASCII" You can certainly add a COUNT(column_name) to an SQL. Here is a technote that shows an example Counting Number of ITM Agents and other TEMS Objects http://www.ibm.com/support/docview.wss?uid=swg21444623 The problem case is when you do a join between two or more tables. Regards, ______________________________________________ John Alvord Advisory Engineer and ITM Historian IBM Tivoli Monitoring 6 Platform Customer Support Office: 1-720-396-2788 Mobile: none jalvord-r/[email protected] Cloud & Smarter Infrastructure IBM Support Portal Open a New Service Request Update your PMR via Email Escalate your PMR My Blog: Wonderful World of Situations Secure upload to ECUREP From: "Mike Elleby 3.0" <[email protected]> To: "'Discussion list for Tivoli product and Tivoli Ready products.'" <[email protected]>, Date: 10/18/2013 07:57 AM Subject: RE: [TME10] TEMS Custom SQL Query? Sent by: [email protected] LOL.. Hey John Alvord, I was going to ask a question on doing just that.. I've got a query that supports a workspace that gives me a list of servers in a table view, but I need to get a total count. I was thinking about creating another table view that took that query and added a 'count' to it to give me the total number of servers. Now, I know I can add a count function to the sql, but could I do this in this particular context? Mike E- From: [email protected] [ mailto:[email protected]] On Behalf Of John Alvord Sent: Friday, October 18, 2013 10:46 AM To: Discussion list for Tivoli product and Tivoli Ready products. Subject: Re: [TME10] TEMS Custom SQL Query? Don't even try. The TEMS SQL is non-standard [actually SQL '89 with major extensions] and the join is very very memory expensive... can easily lead to a TEMS crash. I remember one case where a SOAP in a join was crashing the hub TEMS 10 minutes after startup. There was an office-wide hunt for the problem workstation... took two days. In the end it was hiding behind a desk - belonged to an employee who left a year before. That machine was unplugged and then the hub TEMS stopped crashing. So Do - Not - Even -Try - !! Regards, ______________________________________________ John Alvord Advisory Engineer and ITM Historian IBM Tivoli Monitoring 6 Platform Customer Support Office: 1-720-396-2788 Mobile: none jalvord-r/[email protected] Cloud & Smarter Infrastructure IBM Support Portal Open a New Service Request Update your PMR via Email Escalate your PMR My Blog: Wonderful World of Situations Secure upload to ECUREP From: <[email protected]> To: <[email protected]>, Date: 10/18/2013 12:16 AM Subject: [TME10] TEMS Custom SQL Query? Sent by: [email protected] Hi folks. I need some help in writing a custom query to get information on all 32bit Windows OS agents installed on 64 bit hardware. I can get Host Info from one workspace and a lot of 32/64 bit agent installation info in the Agent Management log. But I need to combine them in one query. /Gus _______________________________________________ TME10 mailing list [email protected] Unsubscribe:[email protected] _______________________________________________ TME10 mailing list [email protected] Unsubscribe:[email protected] --=_alternative 00541C0D88257C08_= Content-Type: text/html; charset="US-ASCII" <font size=2 face="sans-serif">You can certainly add a </font> <br> <br><font size=2 face="sans-serif">COUNT(column_name)</font> <br> <br><font size=2 face="sans-serif">to an SQL.</font> <br> <br><font size=2 face="sans-serif">Here is a technote that shows an example</font> <br> <br><font size=2 face="sans-serif">Counting Number of ITM Agents and other TEMS Objects</font> <br><a href="http://www.ibm.com/support/docview.wss?uid=swg21444623"><font size=2 face="sans-serif">http://www.ibm.com/support/docview.wss?uid=swg21444623</font></a><font size=2 face="sans-serif"> </font> <br> <br><font size=2 face="sans-serif">The problem case is when you do a join between two or more tables.<br> </font><font size=3><br> Regards, <br> ______________________________________________</font> <table width=433 style="border-collapse:collapse;"> <tr height=8> <td width=433 style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size=1><br> </font> <table width=433 style="border-collapse:collapse;"> <tr height=8> <td width=221 style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size=1 face="Arial"><b>John Alvord</b><br> Advisory Engineer and ITM Historian<br> IBM Tivoli Monitoring 6 Platform<b><br> Customer Support </b><br> Office: 1-720-396-2788 <br> Mobile: none </font><font size=1 color=blue face="Arial"><u><br> </u></font><a href=mailto:jalvord-r/[email protected]><font size=1 color=blue face="Arial"><u>jalvord-r/[email protected]</u></font></a><font size=3><br> </font><font size=1 color=blue face="Arial"><b><u><br> </u></b></font><a href=http://www.ibm.com/software/tivoli/><font size=1 color=blue face="Arial"><b><u>Cloud & Smarter Infrastructure</u></b></font></a> <td width=212 style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><a href=https://www.ibm.com/support/><font size=1 color=blue face="Arial"><u>IBM Support Portal</u></font></a><font size=1 color=blue face="Arial"><u><br> </u></font><a href=http://www.ibm.com/support/entry/portal/Open_service_request/><font size=1 color=blue face="Arial"><u>Open a New Service Request</u></font></a><font size=1 color=blue face="Arial"><u><br> </u></font><a href="https://www-304.ibm.com/jct05001c/de/support/ecurep/send_email.html#naming"><font size=1 color=blue face="Arial"><u>Update your PMR via Email</u></font></a><font size=1 color=blue face="Arial"><u><br> </u></font><a href="http://www-304.ibm.com/support/customercare/sas/f/handbook/getsupport.html#9"><font size=1 color=blue face="Arial"><u>Escalate your PMR</u></font></a><font size=1 color=blue face="Arial"><u><br> </u></font><a href=https://www.ibm.com/developerworks/mydeveloperworks/blogs/jalvord><font size=1 color=blue face="Arial"><u>My Blog: Wonderful World of Situations</u></font></a><font size=1 color=blue face="Arial"><u><br> </u></font><a href=https://www.ecurep.ibm.com/app/upload><font size=1 color=blue face="Arial"><u>Secure upload to ECUREP</u></font></a> <p><a href=https://www.facebook.com/IBMTivolisupport></a><a href=https://twitter.com/TivoliSupport></a><a href=https://www.ibm.com/developerworks/servicemanagement/index.html></a></table> <br> <tr height=8> <td width=433 style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><a href=http://www.ibm.com/software/tivoli// target=_new></a></table> <br> <br> <br> <br> <br><font size=1 color=#5f5f5f face="sans-serif">From: </font><font size=1 face="sans-serif">"Mike Elleby 3.0" <[email protected]></font> <br><font size=1 color=#5f5f5f face="sans-serif">To: </font><font size=1 face="sans-serif">"'Discussion list for Tivoli product and Tivoli Ready products.'" <[email protected]>, </font> <br><font size=1 color=#5f5f5f face="sans-serif">Date: </font><font size=1 face="sans-serif">10/18/2013 07:57 AM</font> <br><font size=1 color=#5f5f5f face="sans-serif">Subject: </font><font size=1 face="sans-serif">RE: [TME10] TEMS Custom SQL Query?</font> <br><font size=1 color=#5f5f5f face="sans-serif">Sent by: </font><font size=1 face="sans-serif">[email protected]</font> <br> <hr noshade> <br> <br> <br><font size=2 color=#004080 face="Calibri">LOL.. Hey John Alvord, I was going to ask a question on doing just that.. I've got a query that supports a workspace that gives me a list of servers in a table view, but I need to get a total count. I was thinking about creating another table view that took that query and added a 'count' to it to give me the total number of servers. Now, I know I can add a count function to the sql, but could I do this in this particular context?</font> <br><font size=2 color=#004080 face="Calibri"> </font> <br><font size=2 color=#004080 face="Calibri">Mike E-</font> <br><font size=2 color=#004080 face="Calibri"> </font> <br><font size=2 face="Tahoma"><b>From:</b> [email protected] [</font><a href="mailto:[email protected]"><font size=2 face="Tahoma">mailto:[email protected]</font></a><font size=2 face="Tahoma">] <b>On Behalf Of </b>John Alvord<b><br> Sent:</b> Friday, October 18, 2013 10:46 AM<b><br> To:</b> Discussion list for Tivoli product and Tivoli Ready products.<b><br> Subject:</b> Re: [TME10] TEMS Custom SQL Query?</font> <br><font size=3 face="Times New Roman"> </font> <br><font size=2 face="Arial">Don't even try. The TEMS SQL is non-standard [actually SQL '89 with major extensions] and the join is very very memory expensive... can easily lead to a TEMS crash.</font><font size=3 face="Times New Roman"> <br> </font><font size=2 face="Arial"><br> I remember one case where a SOAP in a join was crashing the hub TEMS 10 minutes after startup. There was an office-wide hunt for the problem workstation... took two days. In the end it was hiding behind a desk - belonged to an employee who left a year before. That machine was unplugged and then the hub TEMS stopped crashing.</font><font size=3 face="Times New Roman"> <br> </font><font size=2 face="Arial"><br> So Do - Not - Even -Try - !!</font><font size=3 face="Times New Roman"><br> <br> Regards, <br> ______________________________________________ </font> <p> <table width=434 style="border-collapse:collapse;"> <tr height=8> <td width=432 style="border-style:solid;border-color:#000000;border-width:1px 1px 3px 1px;padding:0px 0px;"><font size=3 face="Times New Roman"> </font> <p> <br> <table width=434 style="border-collapse:collapse;"> <tr height=8> <td width=220 style="border-style:solid;border-color:#000000;border-width:1px 3px 1px 1px;padding:0px 0px;"><font size=1 face="Arial"><b>John Alvord</b><br> Advisory Engineer and ITM Historian<br> IBM Tivoli Monitoring 6 Platform<b><br> Customer Support </b><br> Office: 1-720-396-2788 <br> Mobile: none </font><font size=3 color=blue face="Times New Roman"><u><br> </u></font><a href=mailto:jalvord-r/[email protected]><font size=1 color=blue face="Arial"><u>jalvord-r/[email protected]</u></font></a><font size=1 color=blue face="Arial"><b><u><br> </u></b></font><font size=3 color=blue face="Times New Roman"><u><br> </u></font><a href=http://www.ibm.com/software/tivoli/><font size=1 color=blue face="Arial"><b><u>Cloud & Smarter Infrastructure</u></b></font></a><font size=3 face="Times New Roman"> </font> <td width=209 style="border-style:solid;border-color:#000000;border-width:1px 1px 1px 3px;padding:0px 0px;"><a href=https://www.ibm.com/support/><font size=1 color=blue face="Arial"><u>IBM Support Portal</u></font></a><font size=3 color=blue face="Times New Roman"><u><br> </u></font><a href=http://www.ibm.com/support/entry/portal/Open_service_request/><font size=1 color=blue face="Arial"><u>Open a New Service Request</u></font></a><font size=3 color=blue face="Times New Roman"><u><br> </u></font><a href="https://www-304.ibm.com/jct05001c/de/support/ecurep/send_email.html#naming"><font size=1 color=blue face="Arial"><u>Update your PMR via Email</u></font></a><font size=3 color=blue face="Times New Roman"><u><br> </u></font><a href="http://www-304.ibm.com/support/customercare/sas/f/handbook/getsupport.html#9"><font size=1 color=blue face="Arial"><u>Escalate your PMR</u></font></a><font size=3 color=blue face="Times New Roman"><u><br> </u></font><a href=https://www.ibm.com/developerworks/mydeveloperworks/blogs/jalvord><font size=1 color=blue face="Arial"><u>My Blog: Wonderful World of Situations</u></font></a><font size=3 color=blue face="Times New Roman"><u><br> </u></font><a href=https://www.ecurep.ibm.com/app/upload><font size=1 color=blue face="Arial"><u>Secure upload to ECUREP</u></font></a><font size=3 face="Times New Roman"> </font></table> <br> <tr height=8> <td width=432 style="border-style:solid;border-color:#000000;border-width:3px 1px 1px 1px;padding:0px 0px;"></table> <br><font size=3 face="Times New Roman"><br> <br> <br> <br> </font><font size=1 color=#5f5f5f face="Arial"><br> From: </font><font size=1 face="Arial"><</font><a href=mailto:[email protected]><font size=1 color=blue face="Arial"><u>[email protected]</u></font></a><font size=1 face="Arial">></font><font size=3 face="Times New Roman"> </font><font size=1 color=#5f5f5f face="Arial"><br> To: </font><font size=1 face="Arial"><</font><a href=mailto:[email protected]><font size=1 color=blue face="Arial"><u>[email protected]</u></font></a><font size=1 face="Arial">>, </font><font size=1 color=#5f5f5f face="Arial"><br> Date: </font><font size=1 face="Arial">10/18/2013 12:16 AM</font><font size=3 face="Times New Roman"> </font><font size=1 color=#5f5f5f face="Arial"><br> Subject: </font><font size=1 face="Arial">[TME10] TEMS Custom SQL Query?</font><font size=3 face="Times New Roman"> </font><font size=1 color=#5f5f5f face="Arial"><br> Sent by: </font><a href="mailto:[email protected]"><font size=1 color=blue face="Arial"><u>[email protected]</u></font></a><font size=3 face="Times New Roman"> </font> <div align=center> <hr noshade></div> <br><font size=3 face="Times New Roman"><br> <br> </font><font size=2 color=#004080 face="Calibri"><br> Hi folks.</font><font size=3 face="Times New Roman"> </font><font size=2 color=#004080 face="Calibri"><br> </font><font size=3 face="Times New Roman"> </font><font size=2 color=#004080 face="Calibri"><br> I need some help in writing a custom query to get information on all 32bit Windows OS agents installed on 64 bit hardware.</font><font size=3 face="Times New Roman"> </font><font size=2 color=#004080 face="Calibri"><br> I can get Host Info from one workspace and a lot of 32/64 bit agent installation info in the Agent Management log. But I need to combine them in one query.</font><font size=3 face="Times New Roman"> </font><font size=2 color=#004080 face="Calibri"><br> </font><font size=3 face="Times New Roman"> </font><font size=2 color=#004080 face="Calibri"><br> /Gus</font><font size=3 face="Times New Roman"> </font><font size=2 color=#004080 face="Calibri"><br> </font><font size=3 face="Times New Roman"> </font><font size=3 color=#004080 face="Times New Roman"><br> </font><font size=2 face="Courier New">_______________________________________________<br> TME10 mailing list</font><font size=2 color=blue face="Courier New"><u><br> </u></font><a href=mailto:[email protected]><font size=2 color=blue face="Courier New"><u>[email protected]</u></font></a><font size=2 face="Courier New"><br> Unsubscribe:[email protected]</font><tt><font size=2>_______________________________________________<br> TME10 mailing list<br> [email protected]<br> Unsubscribe:[email protected]<br> </font></tt> <br> --=_alternative 00541C0D88257C08_=-- --===============1134653002== Content-Type: text/plain; charset="iso-8859-1" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline _______________________________________________ TME10 mailing list [email protected] Unsubscribe:[email protected] --===============1134653002==--