Hi I want to findout the ClassId for the class name in SCOM database. Not sure in which table it stores. Help me on this. EX: I want to find out class id for ExBPA Component class. Regards Donald D'souza

Hello Donald, SCOM classes (types) are stored in the ManagedType table, which contains a ManagedTypeId as one of its fields. Regards. This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm

Hi Donald You might be able to do this using PowerShell: get-monitoringclass –name <Class Name> You could pipe the output to a text file or format on screen. If you are not sure of the class name then you can dump all classes to a csv file Get-monitoringclass > c:\classlist.csv Cheers Graham New SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/ View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Hi, I think that you can use Some SQL queries to find the ClassId for the class name ,and to do this you can use this link: http://www.braindumpblog.co.uk/?p=61Oussama Oueslati | System Engineer | vNext Consulting

Hi Donald You should be able to do this using PowerShell: get-monitoringclass –name <Class Name> If you are not sure of the class name then you can dump all classes to a csv file Get-monitoringclass | export-csv c:\classlist.csv Cheers Graham New SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/ View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Hi Donald You should be able to do this using PowerShell: get-monitoringclass –name <Class Name> If you are not sure of the class name then you can dump all classes to a csv file Get-monitoringclass | export-csv c:\classlist.csv Cheers Graham New SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/ View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Personally, I would recommend that PowerShell is the preferred method here. The database schema has undergone some changes from SCOM 2007 R2 to SCOM 2012 beta so to future protect your scripts you might be better off with Powershell. Having said that there are a new set of PowerShell scripts for SCOM 2012 though thankfully the SCOM 2007 R2 PowerShell scripts still work. For anyone that wants to test it on SCOM 2012 with the new PowerShell cmdlets then try the following: Get-SCOMClass | Select ManagementPackName, DisplayName, Name, ID | sort -Property ManagementPackName | export-csv c:\listclasses.csv New SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/ View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Personally, I would recommend that PowerShell is the preferred method here. The database schema has undergone some changes from SCOM 2007 R2 to SCOM 2012 beta so to future protect your scripts you might be better off with Powershell. Having said that there are a new set of PowerShell scripts for SCOM 2012 though thankfully the SCOM 2007 R2 PowerShell scripts still work. For anyone that wants to test it on SCOM 2012 with the new PowerShell cmdlets then try the following: Get-SCOMClass | Select ManagementPackName, DisplayName, Name, ID | sort -Property ManagementPackName | export-csv c:\listclasses.csv New SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/ View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Hi, Regarding the cmdlet “Get-MonitoringClass”, I would like to share the following articles: Get-MonitoringClass http://technet.microsoft.com/en-us/library/gg132262.aspx Get-MonitoringClass http://blogs.technet.com/b/jonathanalmquist/archive/2008/11/01/get-monitoringclass.aspx Hope this helps. Thanks. Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.