Just let me know when and where :)=20
-----Original Message-----
From: Peter A. Sang [SMTP:pesa@sang.de]
Sent: Monday, March 24, 1997 12:39 PM
To: 'emerald@emerald.iea.com'
Subject: AW: start and stop records
Josh, looks like you really want to book a small SQL seminar with me :)
You're correct, all you need are the 'Type 2' records that contain your
accounting information. You might have others (e.g. type 3 from
Cisco-NAS), you can delete them as well.=20
('delete from calls where acctstatustype !=3D 2' will do the job in this
case, too)
You may want to check which types you have by executing 'select * from
calls where acctstatustype !=3D 2' before using the delete command.
cu, Peter
This is from a Mail I sent to the list on January 12th:
Mark,=20
the SQL command
'delete from calls where acctstatustype =3D 1'
(executed from SQL Enterprise manager or the Query Tool) will delete all
data records meeting the condition 'acctstatustype =3D 1' from the Calls
table in the Emerald db.
Since they are not used, this will help you to save database space.(If
you don't feel save with issuing direct SQL commands, just leave it
alone if you have enough space left.)
I do this deletions for type 1 and 3 about once a month, i assume Dale
will include it as an (automatic?) 'trim Calls table' command in a
future version of Emerald.
-
Peter A. Sang
SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
T: +49-201-82020-0 * F:-40 * http://www.sang.net * mailto:pesa@sang.net
>----------
>Von: Josh Hillman[SMTP:admin-maillist@talstar.com]
>Gesendet: Montag, 24. M=E4rz 1997 18:01
>An: emerald@emerald.iea.com
>Betreff: start and stop records
>
>I've got over 36,400 start records in my Calls table (SQL) dating back =
to
>Oct 28, 1996. Do the start records serve any purpose after the stop =
record
>has been obtained for the same call? The stop records are pretty =
useful,
>but I don't think I've ever used the start records for anything AFTER =
the
>stop record has been obtained.
>
>How can these start records be removed (if it's safe to do so)? I =
don't
>want to kill any of the stop records yet.
>
>Emerald 2.1.5
>SQL 6.5 on NT 4.0
>Ascend Max 4004 5.0A
>
>Thanks,
>
>Josh Hillman
>hillman@talstar.com
>
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>
----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com
------ =_NextPart_000_01BC3852.B3444200
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IjMUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAwAEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAGVtZXJhbGRAZW1lcmFs
ZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAAHgACMAEAAAAFAAAAU01U
UAAAAAAeAAMwAQAAABgAAABlbWVyYWxkQGVtZXJhbGQuaWVhLmNvbQADABUMAQAAAAMA/g8GAAAA
HgABMAEAAAAaAAAAJ2VtZXJhbGRAZW1lcmFsZC5pZWEuY29tJwAAAAIBCzABAAAAHQAAAFNNVFA6
RU1FUkFMREBFTUVSQUxELklFQS5DT00AAAAAAwAAOQAAAAALAEA6AQAAAB4A9l8BAAAAGAAAAGVt
ZXJhbGRAZW1lcmFsZC5pZWEuY29tAAIB918BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAA
AGVtZXJhbGRAZW1lcmFsZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAA
AwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAALpXwEEgAEAGwAAAFJFOiBzdGFydCBhbmQg
c3RvcCByZWNvcmRzAGoJAQWAAwAOAAAAzQcDABgADAA3ACoAAQBdAQEggAMADgAAAM0HAwAYAAwA
NwALAAEAPgEBCYABACEAAABCNkZFNTI1NzQ1QTREMDExQTI4QjYwOTUwMkMxMDYyNwDwBgEDkAYA
KA4AACEAAAALAAIAAQAAAAsAIwAAAAAAAwAmAAAAAAALACkAAAAAAAMALgAAAAAAAwA2AAAAAABA
ADkAAMVlvJU4vAEeAHAAAQAAABsAAABSRTogc3RhcnQgYW5kIHN0b3AgcmVjb3JkcwAAAgFxAAEA
AAAWAAAAAbw4lbwIV1L+t6RFEdCii2CVAsEGJwAAHgAeDAEAAAAFAAAAU01UUAAAAAAeAB8MAQAA
ABIAAABqb3NocEBuZXRjbmN0Lm5ldAAAAAMABhCnKbVQAwAHEJUHAAAeAAgQAQAAAGUAAABKVVNU
TEVUTUVLTk9XV0hFTkFORFdIRVJFOiktLS0tLU9SSUdJTkFMTUVTU0FHRS0tLS0tRlJPTTpQRVRF
UkFTQU5HU01UUDpQRVNBQFNBTkdERVNFTlQ6TU9OREFZLE1BUkNIAAAAAAIBCRABAAAACQsAAAUL
AAAEGQAATFpGdUXfv/4DAAoAcmNwZzEyNXIyDGBjMQMwAQcLYG6RDhAwMzMPFmZlD5JPAfcCpANj
AgBjaArAc4RldALRcHJxMgAAkioKoW5vElAgMAHQhQHQNg+gMDUwNBQh8wHQFBA0fQdtAoMAUAPU
+xH/EwtiE+EUUBOyGPQU0K8HEwKAApEI5jsJbzAa3/plDjA1HAodIRzfHekb9P8eEhx/IE8gDR+P
Hb8cDxBg/DI4Jdom8SavJ7kb9CfivyZPKh8p3SlfJ48rVDkOUB8upDABKCMwAAKCc3R56mwHkGgJ
4HQAABNQA/BQZGN0bAqxXDJYYZhkanUxcAUQZ2gFQjsWMgwBYwnAMmADMHNufGV4FzAHsAWwAMAC
c3OxAFBzYjIUUDFgYRPw9FxrCeBwC5AyPzKjCGDrMpALgGUxoHY5YAFAM5u/DDA0ZCgAN0AEoAuA
Zyfx6TTmYmEXEGQCIDWgNUbnMdAzkDuRIDExMw5QNp//N684vwBROfwAoDRuPH89hv8xJA/APo8/
n0CvDlA570MP20QfPbMzAoITEGM2YEuhkzOQPbB0aTmQIEQBEKhhdWwFQFAKwGEJwOBhcGggRgIh
NiQlQOhmaS0PkDgBQDkwUDPrRw8yo2ILIHIJUFJSFqDZUlJ3NCVBFwBwAdBNcn8zv0qfS6ZP0E6Q
BRACMC1DTzADYTogVG9XsFModWJqBZB0V7BEYeh0ZTo2JDZP/1EPUh//Uy9UOTHAPaMOIUuhOrYO
UJtVb1Z+UjmBFwEgSD2R+wSQNiQ3WW9af1uPXJ05Dy9dvw+QaXAI0GIKsHQ4/0n6D1RGEF+/YMZq
AGHQC1C8eS9PQFywCxFiRXM2JP8oAGM/ZE9lX1yvVE9rX2xv7211V9JXdFipOW+/Mz8DMB1pszlz
n3SveqBEb2P+dQeAAjAF0E8AGgF40ngw93hwcVEBgG5YMABgCfBNoO99AAIBNeBeUmUA8H0AMYCS
cB6AXHYIkHdrC4D+ZGtAgKIE8AdAEGEBQA4A73EiPYKCBQIQbwVCFyES8g1YwG0LUVjAIEc6XAJc
BeBPRkZJQ0WdhLBPASAN4H/wXEUAwPUDEC5LcHR90BcQeHA1Ie1ncngBQH8BbjHQGvCGlD1ONGMD
IBLzAIAFkGx2/0GhRtAOcDXgiSIBkAAgibL/gPF9QQHBiSEW4A9wAABG0PMM0AGQIC4aEokYDlCJ
0v9OcHjAik+LX4xvD8BG0AWBt44Pjx+QL2xrQEbQbI3P+5KPk5UpjJwlQJFvlk+ThPhiICgCkZdv
iWNZUJUf/5nfmu+b/4mQYxCdQoofnq//n7+MnCgAnU+iz6PfpO+JkP94AKHPp1+ob6l0CvkDMHgv
03k/es17SrChIDGgBUDJB4Aga68RIHcx0AOgbwBwNSCzQRrwIAKRatYg/DoptCEKhQqFrjSG8qwy
P68fsC8IwTTyNaAS8mJr5G1rq0MgX32AAxBYoehhfS27Mk+w0QuAB0DnBdAHkEZQZ2W7M7W7rpb/
Yv1vILbvcL9xz2c/aE9pX/9qb7HUuTZXcwyCTpAXIASQGCBBLgYCPeBbU03YVFA6gGBGUEBGUA9w
+YZAZV28373kbru/H8Av/8E/cr+xXAwhuUUGYAIwx8QLGiK5VE0CIGRheSxtfXFyFtBFYDTT0C/w
OSI3PfAyOjN6oFBN77W20YlX0dKNJ4QQBJAHQJRkQNfFLgiQYS4FoDxtJ9Vv0hFYJdKNQVePV7C6
NLOSMXBvcCAa8PkFoWRzyj+u0ravt7/QP1+x47W/3v/gD7jjShNgaFvT0AkAb7ogsnBpRqAg/nkI
YN0BB0BtMLMwAHAFQP3c0CAG4OZQs4DcEDXxAyD4U1FM3BCEELvBBcAD8F50TyCywbTwtUxZCGAn
97QBBaHdEXTT0Oii5uI1YJ8JgLOAtAHpwBOAJ1SAUf1FYCfdBu0hWLDrgQIwrsLd5uFyCoUA0AWg
dQIwPcL3C4B/cliwaQIgyJDrIbKwP+EDFuBN8YNAh8EEIChlzi7J4OfQ7ZIzIANSCoUGQwQABaAt
TkFTKX/T0ObigZADoAEAsoHtE207s4AEIHfC0IYwtaYoJ3/1pQNS9VHnUPZxs+PwAXTNq0F04MHt
kiE97cID8OfosUtw7SNqb6jQrtHpwL8EAAqFgZAXENPQ3NBv6jb/8YPTsOeHFtAFkOhAs0AN4N9P
IIBCBCDm4vIjYudwNXB3BZDCgD3CJxcQMaDj8CDuKvOq+E/5XmIPMAWwE4D/4MA9wu0y94XZARWx
2KC1TO99ENPQyCO1TFT7kfCg5nDn9/OT4LqiIEnpEee07TKnwqCyURDgIEoNsHXv0LfncA4g6cA6
tUzT8WvT0P/vle0y6OIFpeJf42/kf7jj/w6PD58Qr7jj938CX/mU+gB+Mdk29vYAJOzBFgPo4kX7
rbA7YHBJoGIhDkG8Uf0gO91A7SNRLeALYXawb2z/tQD6VPW050HvldOgk9HuBr/p8IOQBLbu0U2y
CuEnFx/3GCAV9O0yQxZiDSbH8DGgX/tE7bCF8Nfj9ZBiBh1T/96QhbDtIgtw7PKzAAEgBJD/KMD8
cQiC+lMx0BRg5tPn4X9GUE3xHhJLMtwQ78CFsC64KElm75X1IktxJwEgn4OAwxAoJOmjCqBzdT3C
9z2w68INynPT0OCysnHyMt9NwO+W5jA1YPCgZv9YfwDfwnBJwCkEsnF+kC7qPQmwf/qjCJEFM/Ex
CNEbgu2SMX+zg/OQx/DCcQrRJXGT4G37T1HmAWn2USvA6fG64LKA5++V+lMlUWx1BTAuEfZSnfVx
KE5Q3NDxAmM/tQD/KoBJoPZAIiMi1O3gBaX7Qvph75VmwoDvcO2wYfIgAn5vLyAjtQYdvMbIKyTW
QWxOR/RQDiBwGXHPYHlHA2DXwYSAbWJIATFLMHJ1cHDg0ciQODLvbvHXkAFAzyAxzyAaQLww27Nh
AUBHGoAOQXkIBlewkCs0OS17IDEtQeAJtLAwLUIyRjotNANCMuEgdHA6Ly93/UZwLsmzS+ABIAEx
hgLc0G/JWUcBtUy1TD67M7yKPv5WYJBXsMfT5dJiQPphDkG3yQTgkOlBLYYCCpJA7wDvIlCrUdjy
yiY+Q1AJ0QUw71hxx9PTce8AZ9PQazDIkJBN5HJ61IU4OkSwvUoGQUvG18/Y1EoGQoOQX4fghYBL
1dwv3To+SgZJaif/wWeDQW9h8TQANr4sRbDXkLo07gbekW0LcP85Sajg6OG1AB4RK+JgQP5xn1bA
Eg8THxQvuOM+TwER9DI41HM2yJB84e0jWcztGtBy/8FDkSBAABqQ5eD/FvF+kMhRYbRW110PXh9f
L/9gNO6Q5nAEILNh+yDvAhmS7xuFyYDp8RZSP0cwCHBke383wbQBGqCDkANwJmI7QGx6LEoGYjRh
MeIqcvuBbv/oQFhzwvH9ICZyYa8zBEORg26iyOBBRlRFUu0iv0oGVrnyEWj9BhZX50izEf/1Yu0x
KOJZ2wQg3QE1AMMA/ezQKC8R6bAAwCghg4Dn0v36oXP8sGsBbiVKBueWgOD/6LFjMjwxZF3/QYOQ
dM8jtuAyLjEuNUoG6OJhQJNCsArhTlRCYC4wUjd39IBPwdPheEJgxKC00DX9gKBBV34IcOeguiBt
V0oG/0xKSgb7kEyzTkpXfld+PbB/iX+Kj4ufSswjp7qiK+JM7wqijukKkmLTclO/h/8MCv+Jb5Qv
lT9KrY2fjq+Pv9i2n7QwubaBcrqYZUZ9AJ0AAZ0wAAAAAwAQEAAAAAADABEQAAAAAAMAgBD/////
QAAHMIAqEKqVOLwBQAAIMIAqEKqVOLwBCwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAAD
AAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMABYAIIAYAAAAAAMAAAAAAAABGAAAAAFKF
AAC3DQAAHgAlgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC4wAAMAJoAIIAYAAAAA
AMAAAAAAAABGAAAAAAGFAAAAAAAACwAvgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADCA
CCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAMoAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAA
AAAAHgBBgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4AQoAIIAYAAAAAAMAA
AAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAEOACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAA
AAEAAAAAAAAAHgA9AAEAAAAFAAAAUkU6IAAAAAADAA00/TcAAEo+
------ =_NextPart_000_01BC3852.B3444200--