query to see amount data of client schedule ?

almirf

ADSM.ORG Member
Joined
Jun 3, 2014
Messages
44
Reaction score
0
Points
0
PREDATAR Control23

Dear Friends

How im can do a query to see amount data of client schedule ?

Thanks
Almir
 
PREDATAR Control23

Hello,

It's not exactly what you ask but it helps you to identify how much data did each node back up the previous day:

Code:
 SELECT entity AS "Node name", -
  CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "MB xfer", -
  SUBSTR (CAST(min (start_time) AS char(29)),1,10) AS "start date", -
  SUBSTR (CAST(min (start_time) AS char(29)),12,8) AS "start time", -
  SUBSTR (CAST(max (end_time) AS char(29)),1,10) AS "end date", -
  SUBSTR (CAST(max (end_time) AS char(29)),12,8) AS "end time" -
FROM summary -
WHERE activity='BACKUP' AND start_time>=current_timestamp - 24 hours -
GROUP BY entity

Just you can find a very interesting selection of queries here:
http://www.lascon.co.uk/tsm-sql-queries.php
 
PREDATAR Control23

Dear Daduranp

Im want to see all amount data of Schedule that have a name Backup with all of your nodes
in your script im need to put a node name???

what fields im need to change in this script ??

obs : im want to see all amount data of schedule "Backup_Unity_E"

Thanks
almir
 
PREDATAR Control23

Well the script is from LasCon, it's not mine and you don't need to enter anything, just copy all the lines and paste them in the TSM admin command line. It will show you by node name how many data was transferred.

You can modify it if you want to see the data by schedule . Try something like this:


Code:
SELECT SCHEDULE_NAME AS "Schedule name", -
  CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "MB xfer", -
  SUBSTR (CAST(min (start_time) AS char(29)),1,10) AS "start date", -
  SUBSTR (CAST(min (start_time) AS char(29)),12,8) AS "start time", -
  SUBSTR (CAST(max (end_time) AS char(29)),1,10) AS "end date", -
  SUBSTR (CAST(max (end_time) AS char(29)),12,8) AS "end time" -
FROM summary -
WHERE activity='BACKUP' AND start_time>=current_timestamp - 24 hours -
GROUP BY SCHEDULE_NAME

And if you want to see the amount of data specifically for a node add expressions like "and node_name=<YOUR_NODE>" .
 
PREDATAR Control23

Dear Daduranp

is simple , im want to see all amount data that have in activity "Backup_Unit_E"...
obs : all mount data that have in this activity

Thanks
Almir
 
Top