What exactly the requirement and what this script will do? With Regards, Chandru Unicenter Support Wipro Infotech TEL: +91-22-3075-3943/3944 Mail to: [email protected]
From: CATools Helpdesk <[email protected]> To: "spectrum" <[email protected]> Date: 10/29/2010 12:39 PM Subject: [spectrum] script executed at Spectrum Dear All, I have one requirement from customer, can any one help? Kindly get the below script executed at Spectrum tool and share the results SELECT A.alarm_id, B.Title,A.Set_Time,C.event_msg,D.Model_name,E.condition_name,E.criticality FROM alarminfo A INNER JOIN alarmtitle B ON a.cause=b.cause_id INNER JOIN event C ON A.orig_event_key=C.event_key INNER JOIN devicemodel d ON A.Model_h=d.Model_h INNER JOIN alarmcondition e ON a.condition_id=e.condition_id DESC LIMIT 10 Thanks & Regards, Subhash Please do not print this email unless it is absolutely necessary. Use less paper - Save Tree - make "IT" a "Greener" Tomorrow. --Disclaimer-- This email and any files transmitted with it are confidential and may be privileged or otherwise protected from disclosure and are intended solely for the use of the entity / individual to whom they are addressed. If you have received this email in error or If you are not the intended recipient, please notify the sender immediately by way of telephone or email and delete this message and any files transmitted from your system. Please note that any views presented in the email are solely those of the author and do not necessarily represent those of the organization. While all care has been taken to avoid viruses the recipient is advised to check this email and attachments for presence of viruses. The organization accepts no liability on this account. --To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
