TEMS Custom SQL Query?
<[email protected]> Fri, 18 Oct 2013 07:15:02 +0000
| Newsgroups | gmane.comp.sysutils.tivoli.general |
|---|---|
| Message-ID | <EA5FD7F404DE694BB310D050B127649636B64D93__1646.84240376136$1382080563$gmane$org@WFS0138A.corp1.ad1.seb.net> |
--===============0323610847==
Content-Language: en-US
Content-Type: multipart/alternative;
boundary="_000_EA5FD7F404DE694BB310D050B127649636B64D93WFS0138Acorp1ad_"
--_000_EA5FD7F404DE694BB310D050B127649636B64D93WFS0138Acorp1ad_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
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 install=
ation info in the Agent Management log. But I need to combine them in one q=
uery.
/Gus
--_000_EA5FD7F404DE694BB310D050B127649636B64D93WFS0138Acorp1ad_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-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=3DWindows-1=
252">
<meta name=3D"Generator" content=3D"Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
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;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
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=3D"EN-US" link=3D"blue" vlink=3D"purple">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span lang=3D"SV" style=3D"font-size:11.0pt;font-fam=
ily:"Calibri","sans-serif";color:#1F497D">Hi folks.<o:p=
></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"SV" style=3D"font-size:11.0pt;font-fam=
ily:"Calibri","sans-serif";color:#1F497D"><o:p> </=
o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca=
libri","sans-serif";color:#1F497D">I need some help in writi=
ng a custom query to get information on all 32bit Windows OS agents install=
ed on 64 bit hardware.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca=
libri","sans-serif";color:#1F497D">I can get Host Info from =
one workspace and a lot of 32/64 bit agent installation info in the Agent M=
anagement log. But I need to combine them in one query.<o:p></o:p></span></=
p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca=
libri","sans-serif";color:#1F497D"><o:p> </o:p></span><=
/p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca=
libri","sans-serif";color:#1F497D">/Gus<o:p></o:p></span></p=
>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca=
libri","sans-serif";color:#1F497D"><o:p> </o:p></span><=
/p>
<p class=3D"MsoNormal"><span style=3D"color:#1F497D"><o:p> </o:p></spa=
n></p>
</div>
</body>
</html>
--_000_EA5FD7F404DE694BB310D050B127649636B64D93WFS0138Acorp1ad_--
--===============0323610847==
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]
--===============0323610847==--