Really useful blog post on the SCSM Engineering Team's blog:
http://blogs.msdn.com/b/scplat/archive/2010/06/07/troubleshooting-the-data-warehouse-an-overview.aspx
Showing posts with label Troubleshoot. Show all posts
Showing posts with label Troubleshoot. Show all posts
Tuesday, 28 September 2010
Monday, 13 September 2010
Service Manager SQL Queries
I'm in the processes of trying to troubleshoot a problem with our Service Manager test installation that is causing the DataAccess service to not start which seems to have happened since a custom management pack was imported.
Here's some of the SQL queries Microsoft have been supplying to help with the troubleshooting.
List all Management Packs in the DB
select MPFriendlyName, MPLastModified, MPCreated, MPIsSealed from ManagementPack order by MPLastModified
List all Management Packs in the DB ordered by deployment time
select * from ManagementPackHistory order by DeploymentTime
Select a specific Management Pack
select mpname, ManagementPackId from managementpack where MPfriendlyname = 'managementpackname'
Display the XML used by the Management Pack in the DB
select MPName, CONVERT(xml,MPXML) from ManagementPack where ManagementPackId = 'managementpackfromthepreviousquery'
Here's some of the SQL queries Microsoft have been supplying to help with the troubleshooting.
List all Management Packs in the DB
select MPFriendlyName, MPLastModified, MPCreated, MPIsSealed from ManagementPack order by MPLastModified
List all Management Packs in the DB ordered by deployment time
select * from ManagementPackHistory order by DeploymentTime
Select a specific Management Pack
select mpname, ManagementPackId from managementpack where MPfriendlyname = 'managementpackname'
Display the XML used by the Management Pack in the DB
select MPName, CONVERT(xml,MPXML) from ManagementPack where ManagementPackId = 'managementpackfromthepreviousquery'
Subscribe to:
Posts (Atom)