RE: TEMS Custom SQL Query?
"Mike Elleby 3.0" <[email protected]> Fri, 18 Oct 2013 10:56:34 -0400
| Newsgroups | gmane.comp.sysutils.tivoli.general,gmane.comp.sysutils.tivoli.tme10 |
|---|---|
| Message-ID | <[email protected]> |
--===============1818083222== Content-Type: multipart/alternative; boundary="----=_NextPart_000_0202_01CECBF0.B5E18B50" Content-Language: en-us ------=_NextPart_000_0202_01CECBF0.B5E18B50 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 <mailto:jalvord-r/[email protected]> jalvord-r/[email protected] <http://www.ibm.com/software/tivoli/> Cloud & Smarter Infrastructure <https://www.ibm.com/support/> IBM Support Portal <http://www.ibm.com/support/entry/portal/Open_service_request/> Open a New Service Request <https://www-304.ibm.com/jct05001c/de/support/ecurep/send_email.html#naming> Update your PMR via Email <http://www-304.ibm.com/support/customercare/sas/f/handbook/getsupport.html# 9> Escalate your PMR <https://www.ibm.com/developerworks/mydeveloperworks/blogs/jalvord> My Blog: Wonderful World of Situations <https://www.ecurep.ibm.com/app/upload> 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] ------=_NextPart_000_0202_01CECBF0.B5E18B50 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" = xmlns=3D"http://www.w3.org/TR/REC-html40"><head><META = HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"><meta name=3DGenerator content=3D"Microsoft Word 14 = (filtered medium)"><!--[if !mso]><style>v\:* = {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style><![endif]--><style><!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif";} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} p {mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} tt {mso-style-priority:99; font-family:"Courier New";} span.EmailStyle19 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;} .MsoChpDefault {mso-style-type:export-only; font-family:"Calibri","sans-serif";} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1 {page:WordSection1;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue = vlink=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'>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?<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'><o:p> </o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'>Mike E-<o:p></o:p></span></p><p class=3DMsoNormal><span = style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497= D'><o:p> </o:p></span></p><p class=3DMsoNormal><b><span = style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span>= </b><span style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> = [email protected] [mailto:[email protected]] = <b>On Behalf Of </b>John Alvord<br><b>Sent:</b> Friday, October 18, 2013 = 10:46 AM<br><b>To:</b> Discussion list for Tivoli product and Tivoli = Ready products.<br><b>Subject:</b> Re: [TME10] TEMS Custom SQL = Query?<o:p></o:p></span></p><p class=3DMsoNormal><o:p> </o:p></p><p = class=3DMsoNormal><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'>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.</span> <br><br><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'>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.</span> <br><br><span = style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'>So Do = - Not - Even -Try - !!<br></span><br>Regards, = <br>______________________________________________ <o:p></o:p></p><table = class=3DMsoNormalTable border=3D0 cellspacing=3D0 cellpadding=3D0 = width=3D433 style=3D'width:324.75pt;border-collapse:collapse'><tr = style=3D'height:6.0pt'><td width=3D433 = style=3D'width:324.75pt;border:solid black 1.0pt;padding:0in 0in 0in = 0in;height:6.0pt'><p class=3DMsoNormal><o:p> </o:p></p><table = class=3DMsoNormalTable border=3D0 cellspacing=3D0 cellpadding=3D0 = width=3D433 style=3D'width:324.75pt;border-collapse:collapse'><tr = style=3D'height:6.0pt'><td width=3D221 = style=3D'width:165.75pt;border:solid black 1.0pt;padding:0in 0in 0in = 0in;height:6.0pt'><p class=3DMsoNormal = style=3D'mso-line-height-alt:6.0pt'><b><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'>John = Alvord</span></b><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'><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 <u><span style=3D'color:blue'><br></span></u></span><a = href=3D"mailto:jalvord-r/[email protected]"><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'>jalvord-X8U/[email protected]= .com</span></a><br><b><u><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:blue'><br= ></span></u></b><a href=3D"http://www.ibm.com/software/tivoli/"><b><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'>Cloud & = Smarter Infrastructure</span></b></a> <o:p></o:p></p></td><td = width=3D212 style=3D'width:159.0pt;border:solid black = 1.0pt;border-left:none;padding:0in 0in 0in 0in;height:6.0pt'><p = class=3DMsoNormal style=3D'mso-line-height-alt:6.0pt'><a = href=3D"https://www.ibm.com/support/"><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'>IBM Support = Portal</span></a><u><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:blue'><br= ></span></u><a = href=3D"http://www.ibm.com/support/entry/portal/Open_service_request/"><s= pan style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'>Open a = New Service Request</span></a><u><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:blue'><br= ></span></u><a = href=3D"https://www-304.ibm.com/jct05001c/de/support/ecurep/send_email.ht= ml#naming"><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'>Update your = PMR via Email</span></a><u><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:blue'><br= ></span></u><a = href=3D"http://www-304.ibm.com/support/customercare/sas/f/handbook/getsup= port.html#9"><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'>Escalate your = PMR</span></a><u><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:blue'><br= ></span></u><a = href=3D"https://www.ibm.com/developerworks/mydeveloperworks/blogs/jalvord= "><span style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'>My = Blog: Wonderful World of Situations</span></a><u><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:blue'><br= ></span></u><a href=3D"https://www.ecurep.ibm.com/app/upload"><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'>Secure upload = to ECUREP</span></a> <o:p></o:p></p></td></tr></table></td></tr><tr = style=3D'height:6.0pt'><td width=3D433 = style=3D'width:324.75pt;border:solid black = 1.0pt;border-top:none;padding:0in 0in 0in = 0in;height:6.0pt'></td></tr></table><p = class=3DMsoNormal><br><br><br><br><br><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F'>= From: </span><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'><<a = href=3D"mailto:[email protected]">[email protected]</a>></sp= an> <br><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F'>= To: </span><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'><<a = href=3D"mailto:[email protected]">[email protected]</a>>, = </span><br><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F'>= Date: </span><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'>10/18/2013 = 12:16 AM</span> <br><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F'>= Subject: </span><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'>[TME10] TEMS = Custom SQL Query?</span> <br><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F'>= Sent by: </span><span = style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"'><a = href=3D"mailto:[email protected]">tme10-bounces-33AaDErTWvDIeBYjj/[email protected]= .com</a></span> <o:p></o:p></p><div class=3DMsoNormal align=3Dcenter = style=3D'text-align:center'><hr size=3D2 width=3D"100%" noshade = style=3D'color:#A0A0A0' align=3Dcenter></div><p class=3DMsoNormal = style=3D'margin-bottom:12.0pt'><br><br><br><span = style=3D'font-size:10.0pt;font-family:"Calibri","sans-serif";color:#00408= 0'>Hi folks.</span> <br><span = style=3D'font-size:10.0pt;font-family:"Calibri","sans-serif";color:#00408= 0'> </span> <br><span = style=3D'font-size:10.0pt;font-family:"Calibri","sans-serif";color:#00408= 0'>I need some help in writing a custom query to get information on all = 32bit Windows OS agents installed on 64 bit hardware.</span> <br><span = style=3D'font-size:10.0pt;font-family:"Calibri","sans-serif";color:#00408= 0'>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.</span> <br><span = style=3D'font-size:10.0pt;font-family:"Calibri","sans-serif";color:#00408= 0'> </span> <br><span = style=3D'font-size:10.0pt;font-family:"Calibri","sans-serif";color:#00408= 0'>/Gus</span> <br><span = style=3D'font-size:10.0pt;font-family:"Calibri","sans-serif";color:#00408= 0'> </span> <br><span = style=3D'color:#004080'> </span><tt><span = style=3D'font-size:10.0pt'>______________________________________________= _</span></tt><span style=3D'font-size:10.0pt;font-family:"Courier = New"'><br><tt>TME10 mailing list</tt><br><tt><a = href=3D"mailto:[email protected]">[email protected]</a></tt><br= ><tt>Unsubscribe:[email protected]</tt></span><o:p></o:p></p><= /div></body></html> ------=_NextPart_000_0202_01CECBF0.B5E18B50-- --===============1818083222== 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] --===============1818083222==--