Hello Folks I'm getting up to date alert data in the OpsDb and in the following tables on the warhouse, see the first query below. I'm not getting alert data in the alerthistory table on the warehouse, see the second query.
This is as a result of a bad upgrade from 2012 SP! To 2012 R2, resulting in a need to restore the OpsDB and Warehouse. Kevin Holmen, helped me previously with a synchronisation issue which is now sorted, this seems to be the last issue I need to fix. I'm trying to find out what does the insert into the AlertHistory table, to figure what I need to fix. select top 10 * from [Alert].[vAlertResolutionState] where AlertGuid = 'B5D37E64-3F44-4845-A29C-27ACCA0EDAF8' order by DWCreatedDateTime desc select top 10 * from [Alert].[vAlertDetail] where AlertGuid = 'B5D37E64-3F44-4845-A29C-27ACCA0EDAF8' order by DWCreatedDateTime desc select top 10 * from [Alert].[vAlert] where AlertGuid = 'B5D37E64-3F44-4845-A29C-27ACCA0EDAF8' order by RaisedDateTime desc [cid:[email protected]] select top 10 AlertHistoryId, AlertId, ResolutionState, Comments, TimeModified, TimeModifiedOffset, TimeResolutionStateLastModified, TimeResolutionStateLastModifiedOffset, ModifiedBy from AlertHistory order by TimeAdded desc [cid:[email protected]] Thanks [ITServiceAssurance_Logo (2)] Gareth Miles System Center Technical Lead Phone: +27 31 580 1582 Mobile: +27 83 648 8559 ############################################################################################# The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Furthermore, the information contained in this message, and any attachments thereto, is for information purposes only and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of the company. #############################################################################################
