| Newsgroups |
gmane.comp.sysutils.tivoli.general |
| Message-ID |
<CAMzJ2PrtizshG2WnD915=T6hA0O6Uc3BeQMwNRJr0BTrzzW+qQ__10030.661620158$1382151521$gmane$org@mail.gmail.com> |
--===============1468753947==
Content-Type: multipart/alternative; boundary=001a11c25f42c3cded04e90f3896
--001a11c25f42c3cded04e90f3896
Content-Type: text/plain; charset=ISO-8859-1
Gus: Just use kshsoap, which allows you to group your queries for the
various target objects (tables-->attributes) you need in the same passed-in
file. It will require some formatting in a separate (or a wrapper) script
but should get you what you want. I've written enough custom SQL for
direct invocation via kdstsns to corroborate John's point; the lack of
ability to use many now-common scalar or group functions is frustrating.
-Toben
On Oct 18, 2013 10:19 AM, "John Alvord" <jalvord-r/[email protected]> wrote:
> 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]* <jalvord-r/[email protected]>
> *
> **Cloud & Smarter Infrastructure* <http://www.ibm.com/software/tivoli/> *IBM
> Support Portal* <https://www.ibm.com/support/>*
> **Open a New Service Request*<http://www.ibm.com/support/entry/portal/Open_service_request/>
> *
> **Update your PMR via Email*<https://www-304.ibm.com/jct05001c/de/support/ecurep/send_email.html#naming>
> *
> **Escalate your PMR*<http://www-304.ibm.com/support/customercare/sas/f/handbook/getsupport.html#9>
> *
> **My Blog: Wonderful World of Situations*<https://www.ibm.com/developerworks/mydeveloperworks/blogs/jalvord>
> *
> **Secure upload to ECUREP* <https://www.ecurep.ibm.com/app/upload>
>
> <https://www.facebook.com/IBMTivolisupport><https://twitter.com/TivoliSupport><https://www.ibm.com/developerworks/servicemanagement/index.html>
>
> <http://www.ibm.com/software/tivoli//>
>
>
>
>
> 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] <[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]* <jalvord-r/[email protected]>*
> **
> **Cloud & Smarter Infrastructure* <http://www.ibm.com/software/tivoli/> *IBM
> Support Portal* <https://www.ibm.com/support/>*
> **Open a New Service Request*<http://www.ibm.com/support/entry/portal/Open_service_request/>
> *
> **Update your PMR via Email*<https://www-304.ibm.com/jct05001c/de/support/ecurep/send_email.html#naming>
> *
> **Escalate your PMR*<http://www-304.ibm.com/support/customercare/sas/f/handbook/getsupport.html#9>
> *
> **My Blog: Wonderful World of Situations*<https://www.ibm.com/developerworks/mydeveloperworks/blogs/jalvord>
> *
> **Secure upload to ECUREP* <https://www.ecurep.ibm.com/app/upload>
>
>
>
>
>
>
> From: <*[email protected]* <[email protected]>>
> To: <*[email protected]* <[email protected]>>,
> Date: 10/18/2013 12:16 AM
> Subject: [TME10] TEMS Custom SQL Query?
> Sent by: *[email protected]*<[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]* <[email protected]>
> Unsubscribe:[email protected]
> _______________________________________________
> TME10 mailing list
> [email protected]
> Unsubscribe:[email protected]
>
>
> _______________________________________________
> TME10 mailing list
> [email protected]
> Unsubscribe:[email protected]
>
>
--001a11c25f42c3cded04e90f3896
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<p dir=3D"ltr">Gus:=A0 Just use kshsoap, which allows you to group your que=
ries for the various target objects (tables-->attributes) you need in th=
e same passed-in file.=A0 It will require some formatting in a separate (or=
a=A0 wrapper) script but should get you what you want.=A0 I've written=
enough custom SQL for direct invocation via kdstsns to corroborate John=
9;s point; the lack of ability to use many now-common scalar or group funct=
ions is frustrating. </p>
<p dir=3D"ltr">-Toben</p>
<div class=3D"gmail_quote">On Oct 18, 2013 10:19 AM, "John Alvord"=
; <<a href=3D"mailto:jalvord-r/[email protected]">jalvord-r/[email protected]</a>> wrot=
e:<br type=3D"attribution"><blockquote class=3D"gmail_quote" style=3D"margi=
n:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<font face=3D"sans-serif">You can certainly add a </font>
<br>
<br><font face=3D"sans-serif">COUNT(column_name)</font>
<br>
<br><font face=3D"sans-serif">to an SQL.</font>
<br>
<br><font face=3D"sans-serif">Here is a technote that shows an example</fon=
t>
<br>
<br><font face=3D"sans-serif">Counting Number of ITM Agents and other
TEMS Objects</font>
<br><a href=3D"http://www.ibm.com/support/docview.wss?uid=3Dswg21444623" ta=
rget=3D"_blank"><font face=3D"sans-serif">http://www.ibm.com/support/docvie=
w.wss?uid=3Dswg21444623</font></a><font face=3D"sans-serif">
</font>
<br>
<br><font face=3D"sans-serif">The problem case is when you do a join
between two or more tables.<br>
</font><font size=3D"3"><br>
Regards, <br>
______________________________________________</font>
<table width=3D"433" style=3D"border-collapse:collapse">
<tr height=3D"8">
<td width=3D"433" style=3D"border-style:solid;border-color:#000000;border-w=
idth:0px 0px 0px 0px;padding:0px 0px"><font size=3D"1"><br>
</font>
<table width=3D"433" style=3D"border-collapse:collapse">
<tr height=3D"8">
<td width=3D"221" style=3D"border-style:solid;border-color:#000000;border-w=
idth:0px 0px 0px 0px;padding:0px 0px"><font size=3D"1" face=3D"Arial"><b>Jo=
hn
Alvord</b><br>
Advisory Engineer and ITM Historian<br>
IBM Tivoli Monitoring 6 Platform<b><br>
Customer Support </b><br>
Office: <a href=3D"tel:1-720-396-2788" value=3D"+17203962788" target=3D"_bl=
ank">1-720-396-2788</a> <br>
Mobile: none </font><font size=3D"1" color=3D"blue" face=3D"Arial"><u><br>
</u></font><a href=3D"mailto:jalvord-r/[email protected]" target=3D"_blank"><font si=
ze=3D"1" color=3D"blue" face=3D"Arial"><u>jalvord-r/[email protected]</u></font></a>=
<font size=3D"3"><br>
</font><font size=3D"1" color=3D"blue" face=3D"Arial"><b><u><br>
</u></b></font><a href=3D"http://www.ibm.com/software/tivoli/" target=3D"_b=
lank"><font size=3D"1" color=3D"blue" face=3D"Arial"><b><u>Cloud
& Smarter Infrastructure</u></b></font></a>
<td width=3D"212" style=3D"border-style:solid;border-color:#000000;border-w=
idth:0px 0px 0px 0px;padding:0px 0px"><a href=3D"https://www.ibm.com/suppor=
t/" target=3D"_blank"><font size=3D"1" color=3D"blue" face=3D"Arial"><u>IBM
Support Portal</u></font></a><font size=3D"1" color=3D"blue" face=3D"Arial"=
><u><br>
</u></font><a href=3D"http://www.ibm.com/support/entry/portal/Open_service_=
request/" target=3D"_blank"><font size=3D"1" color=3D"blue" face=3D"Arial">=
<u>Open
a New Service Request</u></font></a><font size=3D"1" color=3D"blue" face=3D=
"Arial"><u><br>
</u></font><a href=3D"https://www-304.ibm.com/jct05001c/de/support/ecurep/s=
end_email.html#naming" target=3D"_blank"><font size=3D"1" color=3D"blue" fa=
ce=3D"Arial"><u>Update
your PMR via Email</u></font></a><font size=3D"1" color=3D"blue" face=3D"Ar=
ial"><u><br>
</u></font><a href=3D"http://www-304.ibm.com/support/customercare/sas/f/han=
dbook/getsupport.html#9" target=3D"_blank"><font size=3D"1" color=3D"blue" =
face=3D"Arial"><u>Escalate
your PMR</u></font></a><font size=3D"1" color=3D"blue" face=3D"Arial"><u><b=
r>
</u></font><a href=3D"https://www.ibm.com/developerworks/mydeveloperworks/b=
logs/jalvord" target=3D"_blank"><font size=3D"1" color=3D"blue" face=3D"Ari=
al"><u>My
Blog: Wonderful World of Situations</u></font></a><font size=3D"1" color=3D=
"blue" face=3D"Arial"><u><br>
</u></font><a href=3D"https://www.ecurep.ibm.com/app/upload" target=3D"_bla=
nk"><font size=3D"1" color=3D"blue" face=3D"Arial"><u>Secure
upload to ECUREP</u></font></a>
<p><a href=3D"https://www.facebook.com/IBMTivolisupport" target=3D"_blank">=
</a><a href=3D"https://twitter.com/TivoliSupport" target=3D"_blank"></a><a =
href=3D"https://www.ibm.com/developerworks/servicemanagement/index.html" ta=
rget=3D"_blank"></a></p>
</td></td></tr></table>
<br>
<tr height=3D"8">
<td width=3D"433" style=3D"border-style:solid;border-color:#000000;border-w=
idth:0px 0px 0px 0px;padding:0px 0px"><a href=3D"http://www.ibm.com/softwar=
e/tivoli//" target=3D"_blank"></a></td></tr></td></tr></table>
<br>
<br>
<br>
<br>
<br><font size=3D"1" color=3D"#5f5f5f" face=3D"sans-serif">From: =A0 =A0 =
=A0
=A0</font><font size=3D"1" face=3D"sans-serif">"Mike Elleby 3.0"
<<a href=3D"mailto:[email protected]" target=3D"_blank">m_elleby@hotm=
ail.com</a>></font>
<br><font size=3D"1" color=3D"#5f5f5f" face=3D"sans-serif">To: =A0 =A0 =A0
=A0</font><font size=3D"1" face=3D"sans-serif">"'Discussion list
for Tivoli product and Tivoli Ready products.'" <<a href=3D"mai=
lto:[email protected]" target=3D"_blank">[email protected]</a>>=
;,
</font>
<br><font size=3D"1" color=3D"#5f5f5f" face=3D"sans-serif">Date: =A0 =A0 =
=A0
=A0</font><font size=3D"1" face=3D"sans-serif">10/18/2013 07:57 AM</font>
<br><font size=3D"1" color=3D"#5f5f5f" face=3D"sans-serif">Subject: =A0 =A0
=A0 =A0</font><font size=3D"1" face=3D"sans-serif">RE: [TME10]
TEMS Custom SQL Query?</font>
<br><font size=3D"1" color=3D"#5f5f5f" face=3D"sans-serif">Sent by: =A0 =A0
=A0 =A0</font><font size=3D"1" face=3D"sans-serif"><a href=3D"mailto:tme10-=
[email protected]" target=3D"_blank">[email protected]<=
/a></font>
<br>
<hr noshade>
<br>
<br>
<br><font color=3D"#004080" face=3D"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. =A0I was thinking about creating another
table view that took that query and added a 'count' to it to give m=
e the
total number of servers. =A0Now, I know I can add a count function to
the sql, but could I do this in this particular context?</font>
<br><font color=3D"#004080" face=3D"Calibri">=A0</font>
<br><font color=3D"#004080" face=3D"Calibri">Mike E-</font>
<br><font color=3D"#004080" face=3D"Calibri">=A0</font>
<br><font face=3D"Tahoma"><b>From:</b> <a href=3D"mailto:tme10-bounces@list=
s.ca.ibm.com" target=3D"_blank">[email protected]</a>
[</font><a href=3D"mailto:[email protected]" target=3D"_blank"=
><font face=3D"Tahoma">mailto:[email protected]</font></a><fon=
t face=3D"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=3D"3" face=3D"Times New Roman">=A0</font>
<br><font face=3D"Arial">Don't even try. The TEMS SQL is non-standard
[actually SQL '89 with major extensions] and the join is very very memo=
ry
expensive... can easily lead to a TEMS crash.</font><font size=3D"3" face=
=3D"Times New Roman">
<br>
</font><font face=3D"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 workst=
ation...
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=3D"3" face=3D"Times New Roman">=
<br>
</font><font face=3D"Arial"><br>
So =A0Do - Not - Even -Try - !!</font><font size=3D"3" face=3D"Times New Ro=
man"><br>
<br>
Regards, <br>
______________________________________________ </font>
<p>
<table width=3D"434" style=3D"border-collapse:collapse">
<tr height=3D"8">
<td width=3D"432" style=3D"border-style:solid;border-color:#000000;border-w=
idth:1px 1px 3px 1px;padding:0px 0px"><font size=3D"3" face=3D"Times New Ro=
man">=A0</font>
<p>
<br>
<table width=3D"434" style=3D"border-collapse:collapse">
<tr height=3D"8">
<td width=3D"220" style=3D"border-style:solid;border-color:#000000;border-w=
idth:1px 3px 1px 1px;padding:0px 0px"><font size=3D"1" face=3D"Arial"><b>Jo=
hn
Alvord</b><br>
Advisory Engineer and ITM Historian<br>
IBM Tivoli Monitoring 6 Platform<b><br>
Customer Support </b><br>
Office: <a href=3D"tel:1-720-396-2788" value=3D"+17203962788" target=3D"_bl=
ank">1-720-396-2788</a> <br>
Mobile: none </font><font size=3D"3" color=3D"blue" face=3D"Times New Roman=
"><u><br>
</u></font><a href=3D"mailto:jalvord-r/[email protected]" target=3D"_blank"><font si=
ze=3D"1" color=3D"blue" face=3D"Arial"><u>jalvord-r/[email protected]</u></font></a>=
<font size=3D"1" color=3D"blue" face=3D"Arial"><b><u><br>
</u></b></font><font size=3D"3" color=3D"blue" face=3D"Times New Roman"><u>=
<br>
</u></font><a href=3D"http://www.ibm.com/software/tivoli/" target=3D"_blank=
"><font size=3D"1" color=3D"blue" face=3D"Arial"><b><u>Cloud
& Smarter Infrastructure</u></b></font></a><font size=3D"3" face=3D"Tim=
es New Roman">
</font>
<td width=3D"209" style=3D"border-style:solid;border-color:#000000;border-w=
idth:1px 1px 1px 3px;padding:0px 0px"><a href=3D"https://www.ibm.com/suppor=
t/" target=3D"_blank"><font size=3D"1" color=3D"blue" face=3D"Arial"><u>IBM
Support Portal</u></font></a><font size=3D"3" color=3D"blue" face=3D"Times =
New Roman"><u><br>
</u></font><a href=3D"http://www.ibm.com/support/entry/portal/Open_service_=
request/" target=3D"_blank"><font size=3D"1" color=3D"blue" face=3D"Arial">=
<u>Open
a New Service Request</u></font></a><font size=3D"3" color=3D"blue" face=3D=
"Times New Roman"><u><br>
</u></font><a href=3D"https://www-304.ibm.com/jct05001c/de/support/ecurep/s=
end_email.html#naming" target=3D"_blank"><font size=3D"1" color=3D"blue" fa=
ce=3D"Arial"><u>Update
your PMR via Email</u></font></a><font size=3D"3" color=3D"blue" face=3D"Ti=
mes New Roman"><u><br>
</u></font><a href=3D"http://www-304.ibm.com/support/customercare/sas/f/han=
dbook/getsupport.html#9" target=3D"_blank"><font size=3D"1" color=3D"blue" =
face=3D"Arial"><u>Escalate
your PMR</u></font></a><font size=3D"3" color=3D"blue" face=3D"Times New Ro=
man"><u><br>
</u></font><a href=3D"https://www.ibm.com/developerworks/mydeveloperworks/b=
logs/jalvord" target=3D"_blank"><font size=3D"1" color=3D"blue" face=3D"Ari=
al"><u>My
Blog: Wonderful World of Situations</u></font></a><font size=3D"3" color=3D=
"blue" face=3D"Times New Roman"><u><br>
</u></font><a href=3D"https://www.ecurep.ibm.com/app/upload" target=3D"_bla=
nk"><font size=3D"1" color=3D"blue" face=3D"Arial"><u>Secure
upload to ECUREP</u></font></a><font size=3D"3" face=3D"Times New Roman"> <=
/font></td></td></tr></table>
<br>
<tr height=3D"8">
<td width=3D"432" style=3D"border-style:solid;border-color:#000000;border-w=
idth:3px 1px 1px 1px;padding:0px 0px"></td></tr></p></td></tr></table>
<br><font size=3D"3" face=3D"Times New Roman"><br>
<br>
<br>
<br>
</font><font size=3D"1" color=3D"#5f5f5f" face=3D"Arial"><br>
From: =A0 =A0 =A0 =A0</font><font size=3D"1" face=3D"Arial"><</font><a h=
ref=3D"mailto:[email protected]" target=3D"_blank"><font size=3D"1" co=
lor=3D"blue" face=3D"Arial"><u>[email protected]</u></font></a><font s=
ize=3D"1" face=3D"Arial">></font><font size=3D"3" face=3D"Times New Roma=
n">
</font><font size=3D"1" color=3D"#5f5f5f" face=3D"Arial"><br>
To: =A0 =A0 =A0 =A0</font><font size=3D"1" face=3D"Arial"><</font><a hre=
f=3D"mailto:[email protected]" target=3D"_blank"><font size=3D"1" colo=
r=3D"blue" face=3D"Arial"><u>[email protected]</u></font></a><font siz=
e=3D"1" face=3D"Arial">>,
</font><font size=3D"1" color=3D"#5f5f5f" face=3D"Arial"><br>
Date: =A0 =A0 =A0 =A0</font><font size=3D"1" face=3D"Arial">10/18/2013
12:16 AM</font><font size=3D"3" face=3D"Times New Roman"> </font><font size=
=3D"1" color=3D"#5f5f5f" face=3D"Arial"><br>
Subject: =A0 =A0 =A0 =A0</font><font size=3D"1" face=3D"Arial">[TME10]
TEMS Custom SQL Query?</font><font size=3D"3" face=3D"Times New Roman"> </f=
ont><font size=3D"1" color=3D"#5f5f5f" face=3D"Arial"><br>
Sent by: =A0 =A0 =A0 =A0</font><a href=3D"mailto:tme10-bounces-33AaDErTWvDIeBYjj/[email protected]=
.com" target=3D"_blank"><font size=3D"1" color=3D"blue" face=3D"Arial"><u>t=
[email protected]</u></font></a><font size=3D"3" face=3D"Times =
New Roman">
</font>
<div align=3D"center">
<hr noshade></div>
<br><font size=3D"3" face=3D"Times New Roman"><br>
<br>
</font><font color=3D"#004080" face=3D"Calibri"><br>
Hi folks.</font><font size=3D"3" face=3D"Times New Roman"> </font><font col=
or=3D"#004080" face=3D"Calibri"><br>
</font><font size=3D"3" face=3D"Times New Roman">=A0</font><font color=3D"=
#004080" face=3D"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=3D"3" face=
=3D"Times New Roman">
</font><font color=3D"#004080" face=3D"Calibri"><br>
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 query.<=
/font><font size=3D"3" face=3D"Times New Roman">
</font><font color=3D"#004080" face=3D"Calibri"><br>
</font><font size=3D"3" face=3D"Times New Roman">=A0</font><font color=3D"=
#004080" face=3D"Calibri"><br>
/Gus</font><font size=3D"3" face=3D"Times New Roman"> </font><font color=3D=
"#004080" face=3D"Calibri"><br>
</font><font size=3D"3" face=3D"Times New Roman">=A0</font><font size=3D"3=
" color=3D"#004080" face=3D"Times New Roman"><br>
</font><font face=3D"Courier New">________________________________________=
_______<br>
TME10 mailing list</font><font color=3D"blue" face=3D"Courier New"><u><br>
</u></font><a href=3D"mailto:[email protected]" target=3D"_blank"><fon=
t color=3D"blue" face=3D"Courier New"><u>[email protected]</u></font><=
/a><font face=3D"Courier New"><br>
<a href=3D"mailto:Unsubscribe%[email protected]" target=3D"_bl=
ank">Unsubscribe:[email protected]</a></font><tt><font>_________=
______________________________________<br>
TME10 mailing list<br>
<a href=3D"mailto:[email protected]" target=3D"_blank">[email protected]=
ibm.com</a><br>
<a href=3D"mailto:Unsubscribe%[email protected]" target=3D"_bl=
ank">Unsubscribe:[email protected]</a><br>
</font></tt>
<br></p><br>_______________________________________________<br>
TME10 mailing list<br>
<a href=3D"mailto:[email protected]">[email protected]</a><br>
<a href=3D"mailto:Unsubscribe%[email protected]">Unsubscribe:T=
[email protected]</a><br>
<br></blockquote></div>
--001a11c25f42c3cded04e90f3896--
--===============1468753947==
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]
--===============1468753947==--