TSM SQL Help

[newtotivoli]

Hi, Can anyone let me know how to get max (backup_end) from below statement?

select o.node_name,date(o.lastacc_time),o.url,f.backup_end,m.type from filespaces as f,nodes as o,occupancy as m where o.node_name=f.node_name

Any help is appreciated.

 

[inthesun]

Hi, Can anyone let me know how to get max (backup_end) from below statement?

select o.node_name,date(o.lastacc_time),o.url,f.backup_end,m.type from filespaces as f,nodes as o,occupancy as m where o.node_name=f.node_name

Any help is appreciated.

Hi,

The following will give you the last start and end of the client backup from the Filespaces table for node RHEL65 (example):

select backup_start,backup_end from filespaces node_name=RHEL65

 

[inthesun]

Hi,

The following will give you the last start and end of the client backup from the Filespaces table for node RHEL65 (example):

select backup_start,backup_end from filespaces node_name=RHEL65

Sorry, need single quotes:

select backup_start,backup_end from filespaces node_name='RHEL65'