Thanks James. Tried to find the table Alert.vAlert view in DW but unable to. Could please provide the complete query for me, I have poor knowledge in SQL. Thanks you.
________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of James Harper Sent: Wednesday, June 19, 2013 3:25 PM To: [email protected] Subject: [msmom] RE: SQL query for an alert repeat count and repeat count time in SCOM DW In the Data Warehouse, query the Alert.vAlert view. From: [email protected] [mailto:[email protected]] On Behalf Of Narendra Bathula Sent: Wednesday, June 19, 2013 1:57 PM To: [email protected] Subject: [msmom] SQL query for an alert repeat count and repeat count time in SCOM DW Hi All, I am running with SCOM 2007R2 and DW on SQL 2005 server. i have created a event id based rule to find the login failure in SQL. I can see all the alerts stored in the DW normally, but was unable to get the last repeat count Date and time from the operationsmanagerDW for the perticular alert. I used below queries for DB and DW: DB: select *from Alertview Where RepeatCount =893 i can see the last modified date from the above query. Where i was not able to find the same details from the DW. Could you please help to find last repeat count date and time and repeat count in the SCOMDW. please provide the Sql query. Thanks in advance. Naren ::DISCLAIMER:: ---------------------------------------------------------------------------------------------------------------------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects. ----------------------------------------------------------------------------------------------------------------------------------------------------
