N.COM> cc:
Sent by: "ADSM: Subject: Re: [ADSM-L] Select
statement question
Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
"Thought I had it
How would I need to adjust the macro to include information between two
dates?"
Try this...
select
nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024
as decimal(6,2)))
as GB from nodes, summary where (end_time between current_timestamp - $1
hours and
_name asc
Thanks!
DaveZ
Curtis Stewart
<[EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU
AWSON.COM> cc:
Sent by: "ADSM: Subject: Re: [ADSM-L] Select
sta
: "ADSM: Dist Stor Manager"
05/04/2005 07:26 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Select statement question
Folks,
I have a select statement that I use to determine the amount of MB backed
up during a specific time period:
(e
6 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Select statement question
Folks,
I have a select statement that I use to determine the amount of MB backed
up during a specific time period:
(e.g.)
SELECT entity AS "Node name",CAST(sum(b
Folks,
I have a select statement that I use to determine the amount of MB backed
up during a specific time period:
(e.g.)
SELECT entity AS "Node name",CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS
"MB xfer" FROM summary WHERE activity='BACKUP' AND start_time>= '2005-04-01
06:00' AND
end_time<= '
On Feb 11, 2005, at 9:19 AM, Joni Moyer wrote:
I have this finally working, but I was wondering if there is a way to
shorten the width of the columns so that they can all fit on one
line?...
Joni -
The following SQL function is most commonly used to limit the width
of a column:
CHAR
Hello All!
I have this finally working, but I was wondering if there is a way to
shorten the width of the columns so that they can all fit on one line? And
also, the customer has requested that the successful column be changed to
completed, missed or failed. I didn't think this was possible unle
Hi Calvin,
Yes, it doesn't surprise me that activity log rows numbering in the
millions will take several minutes to process (though 20 minutes does seem
like a long time, but that can also depend on other server activity).
Without knowing more about your intentions and time constraints, I'm not
c
nal Message-
From: Andrew Raibeck [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 11, 2004 8:55 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL Select Statement Question Please HELP!
If you are getting actual results (and better yet, correct results) then
there is nothing "wrong" per se wit
If you are getting actual results (and better yet, correct results) then
there is nothing "wrong" per se with your syntax.
The tables presented by the SELECT statement do not really exist as such
in the TSM server database. Rather, these tables are constructed "on the
fly" during SELECT processing
Hello Everyone,
I have a quick question in reference to using select statements to query the activity
log. For some reason the regular select statement would take forever to run a simple
query? How does TSM query the activity log? I'm still quite a novice at selects
statements so maybe I'm issu
Thanks, I got the answer. Paul hit it on the head. My summary of clients
is given by the SQL query:
select platform_name as OS, -
client_os_level as OS_VER, -
cast( cast(client_version as char(2)) || '.' -
|| cast(client_release as char(2)) || '.' -
|| cast(client_level as char(2)) || '.
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:Select statement question...
The first of these queries works. What is wrong with the second one? I've
been scratching my balding head and getting nothing but an itching s
On Wednesday, Feb 26, 2003, at 10:03 Australia/Sydney, Coats, Jack
wrote:
The first of these queries works. What is wrong with the second one?
I've
been scratching my balding head and getting nothing but an itching
scalp.
Thanks for you help! ... Jack
select platform_name as OS, -
client_os_level
The first of these queries works. What is wrong with the second one? I've
been scratching my balding head and getting nothing but an itching scalp.
Thanks for you help! ... Jack
select platform_name as OS, -
client_os_level as OS_VER, -
node_name as Node, -
cast(cast(client_version as char(2)) |
se "select
cast(sum(bytes)/1024/1024/1024 as decimal)".
Zlatko Krastev
IT Consultant
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject:
Wayne,
> Can anyone help me with a select query that will tell me how much data I've
> backed up in the last 24 hours?
select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB Backup" -
from summary where start_time>=current_timestamp - 1 day and activity='BACKUP'
Cheers,
Henk ten Have
18 matches
Mail list logo
