Hi, I need to get the GUID for one of my servers. It is running win 2k8 r2 x64. How can i get this? Thanks!!

Hi, By GUID, are you talking about a GUID in an application such as System Center Operations Manager or the SID that is stored in Active Directory for a user's account? -- Mike Burr

Well i am busy moving db's to a new SQL server and this is for the OperationsManager db that im busy with: Update the dbo.MT_ManagementGroup table 1. On the Windows desktop, click Start , point to Programs , point to Microsoft SQL Server 2005 , and then click SQL Server Management Studio . 2. In the Connect to Server dialog box, in the Server Type list, select Database Engine ; in the Server Name list, select the server and instance for your new Operations Manager database (for example, computer\INSTANCE1 ); in the Authentication list, select Windows Authentication ; and then click Connect . 3. In the Object Explorer pane, expand Databases , expand OperationsManager , and then expand Tables . 4. Right-click dbo.MT_ManagementGroup , and then click Open Table . 5. In the results pane, scroll to the right to the column titled SQLServerName_<guid> . 6. In the first row, update the value to reflect the name of the new database server name, replacing the name of the old server. 7. Click File , and then click Exit .

When I look at that table on our installation, I only get one row, do you get multiple rows? I'm pretty sure that the GUID references the row for the system in the basemanagedentity table. -- Mike Burr

When I select the top thousand rows, the column that the procedure refers to is the 9th column for me, [SQLServerName_6B1D1BE8_EBB4_B425_08DC_2385C5930B04]. This matches the basemanagedentityid 6B1D1BE8-EBB4-B425-08DC-2385C5930B04 When I run this, select * from OperationsManager.dbo.BaseManagedEntity where BaseManagedEntityId = '6B1D1BE8-EBB4-B425-08DC-2385C5930B04' I get the managegement group (FullName = 6B1D1BE8-EBB4-B425-08DC-2385C5930B04 and DisplayName = Operations Manager Management Group) Here there is a column labeled TopLevelHostEntityId which refers to the same row in basemanagedentity, indicating that it is the top level for the hierarchy. Can you explain a little more about what you are looking for? -- Mike Burr

Well im looking for the GUID for a specific server... I am assuming that each server will have one?

Ok, found it.... get it in ADSI Edit under Default Naming context