People, I have been playing aroung with some sql to extract for a particular platform, the total capacity /used per filespace for recently accessed clients. What I have below does this . I would also like to pull this out but summed per node instead of showing the individual filespaces and I cannot get it to work Suggestions gratefully received. SELECT NODES.NODE_NAME,FILESPACE_NAME,CAPACITY, - (CAPACITY*PCT_UTIL/100) AS "MB USED" - FROM NODES,FILESPACES - WHERE NODES.NODE_NAME=FILESPACES.NODE_NAME - AND PLATFORM_NAME LIKE'W%NT' - AND CAST(LASTACC_TIME AS DATE)>'07/01/2003'
John ********************************************************************** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **********************************************************************
