No announcements
Found 1816889 threads
-
0 VotesSQL query to extract Event description from OperationsManager DB (not DW)
I set the DB in trace mode and saw what the SCOM console is using to display the events.Unanswered | 4 Replies | 2327 Views | Created by MariusNY - Friday, August 7, 2020 2:32 PM | Last reply by Crystal Shen - Monday, August 24, 2020 6:09 AM
-
0 Votes
OperationsManager DB created manually
Database–you might find event 18054 errors in the SQL server application ...Answered | 1 Replies | 3140 Views | Created by Jan Matejka - Wednesday, June 1, 2011 9:23 AM | Last reply by Nicholas Li - Thursday, June 2, 2011 8:42 AM -
0 Votes
Inventory from SCOM OperationsManager DB BaseManagedEntity Table
Hi, I tried the below Query to get the System infor including the Name, DNS, IP, Processor, Memory, SID, AD OU, is Virtual, OS, SP, install Date, WindowsDirectory from our Dev SCOM.Answered | 16 Replies | 16859 Views | Created by manickama - Wednesday, November 9, 2011 6:19 PM | Last reply by manickama - Wednesday, November 16, 2011 11:17 PM -
0 Votes
Missing data in OpsMgr DB and OpsMgr DW DB
Querying the DB and DW showed no alerts that matched either.Answered | 3 Replies | 4078 Views | Created by vijakris - Wednesday, September 29, 2010 5:36 PM | Last reply by vijakris - Monday, October 4, 2010 5:48 PM -
0 Votes
Installing Ops DB and DW
Hi, You start your installation from the active node.Answered | 3 Replies | 2526 Views | Created by SaiVarshini - Sunday, August 21, 2011 4:33 PM | Last reply by SaiVarshini - Monday, August 22, 2011 7:18 AM -
0 Votes
Where is the Rule Collection Data in OperationsManager DB
Kevin has some useful queries that also cover performance data.Answered | 1 Replies | 3471 Views | Created by Sudhirshams - Wednesday, August 11, 2010 8:11 PM | Last reply by Åke Pettersson - Wednesday, August 11, 2010 9:48 PM -
2 Votes
OperationsManager DB ever increasing on SQL 2016
Hi Noel, if the transaction log of the SCOM DB is full you will need to back it up and it will get purged.Answered | 6 Replies | 824 Views | Created by Noel Fairclough - Tuesday, October 2, 2018 12:41 PM | Last reply by Stoyan Chalakov - Sunday, December 30, 2018 9:40 PM -
0 Votes
OperationsManager db log file growth settings
To see how much space is being used, you can run this simple query against your OperatonsManager database: select a.FILEID, ...Answered | 4 Replies | 3318 Views | Created by tpullins - Tuesday, October 18, 2011 6:04 PM | Last reply by Michael Pearson - Tuesday, October 18, 2011 9:22 PM -
0 Votes
Restoring OperationsManagerDW database (corrupted) but not OperationsManager database
If you can, and you said SCOM is in its initial stage, restore the Operations DB and DW from the same date and start from there.Answered | 4 Replies | 1587 Views | Created by dnaman - Tuesday, July 29, 2014 2:52 AM | Last reply by Jose Fehse (MVP) - Tuesday, July 29, 2014 1:45 PM -
0 Votes
Extracting a SQL Server DB to Access
Then design the data flows to populate the Access tables from the SQL Data, and can we assume that you can write a parameterized stored procedure(s) to extract the ...Answered | 2 Replies | 5066 Views | Created by Bulldog61 - Monday, March 21, 2011 12:09 AM | Last reply by Bulldog61 - Monday, March 21, 2011 12:26 PM -
0 Votes
SQL Azure DB vs Azure DW
Here is a list of differences: http://microsoft-bitools.blogspot.com/2017/07/azure-sql-database-vs-azure-sql-data.html Also see the Azure ...Answered | 4 Replies | 2583 Views | Created by jaredTexas - Tuesday, April 5, 2016 3:41 AM | Last reply by SSISJoost - Sunday, September 17, 2017 6:29 PM -
0 Votes
SCSM MS DBs and SCSM DW Dbs together?
Can I use only one SQL Server for all SCSM Dbs?Answered | 1 Replies | 3971 Views | Created by PDR2010 - Monday, March 21, 2011 9:33 PM | Last reply by Mark_Newton - Tuesday, March 22, 2011 7:54 AM -
0 Votes
SCOM OperationsManager database login error 34502 and 4513
Hi, It is recommended to analyze SQL bottle neck.Answered | 3 Replies | 3730 Views | Created by Mats Augustsson - Monday, December 15, 2014 1:31 PM | Last reply by Yan Li_ - Wednesday, December 24, 2014 1:50 AM -
0 Votes
SCSM Data warehouse Extract job not running.
Yeah - I have just been through the process of restarting those jobs again from scratch and it has loaded the data into the DW now.Answered | 4 Replies | 6877 Views | Created by TomWheeler - Thursday, September 1, 2011 9:03 AM | Last reply by Mr. Kirpal Singh - Friday, August 23, 2013 11:34 AM -
1 Votes
SQL: How to extract table names from a SQL query in a column
[uspGetBillOfMaterials] @StartProductID=500,@CheckDate=''20090203''') INSERT INTO dbo.TSQL_Commands VALUES (6,'dbo.vw_test','select * from ...Answered | 4 Replies | 15840 Views | Created by Suresh Channamraju - Tuesday, August 17, 2010 8:57 PM | Last reply by Adam Haines - Wednesday, August 18, 2010 1:35 PM -
0 Votes
Event ID 2115 after OperationsManager and OperationsManagerDW db's move in SQL cluster
Hello, You may use the following link to troubleshoot: How to capture a SCOM ETL ...Answered | 2 Replies | 1008 Views | Created by Aaron Hattan - Tuesday, April 19, 2016 1:47 PM | Last reply by Yan Li_ - Tuesday, April 26, 2016 9:54 AM -
1 Votes
DW not Updating MP Microsoft.SQLServer.Library 6.7.31.0
I suppose you could increase the retention in the standard SCSM DB to whatever your DW retention is, wait until you hit that (hopefully not having any problems in the meantime), and ...Answered | 9 Replies | 1763 Views | Created by J.Baldszun - Monday, August 21, 2017 1:23 PM | Last reply by Ma Se - Saturday, April 7, 2018 7:25 PM -
2 Votes
Logging the Error Description to SQL DB Table
I have tried using the logging option but i want a short description in the logging table but not the whole description.Answered | 3 Replies | 655 Views | Created by Balaji Prasad - Wednesday, January 13, 2016 8:33 AM | Last reply by Srinivasa Rao Gude - Wednesday, January 13, 2016 10:34 AM -
0 Votes
How to Reduce the IOPS on the SCOM 2012 DB & DB DW servers
I see, well then it's useful to look into IOPS issue from hypervisor view.Answered | 5 Replies | 2384 Views | Created by NarenSV - Monday, March 16, 2015 10:58 AM | Last reply by Xin Guo - Wednesday, March 18, 2015 2:31 AM -
0 Votes
SQL Server DW architecture question
For reporting catalog database you can use any of the DB servers(Sharepoint or DW) and SSRS web service you can host on separate dedicate ...Answered | 21 Replies | 1770 Views | Created by Pedro Samuel - Monday, January 19, 2015 6:59 PM | Last reply by Pedro Samuel - Friday, February 20, 2015 4:31 PM - Items 1 to 20 of 1816889 Next ›
No announcements
