Enumerating Users & Assigned MOM Console Scopes

Info from a group thread I was working on this week. Might come in handy for reporting on console scope assignments.   T-SQL   select [User].Name as UserName, Instance.KeyValue as ScopeName from [user] LEFT JOIN Instance ON [User].UserScope = Instance.InstanceID     WMI (credit to Craig)   dim objConsoles as Microsoft.EnterpriseManagement.Mom.ConsoleScopesCollection dim objConsole as Microsoft.EnterpriseManagement.Mom.ConsoleScope dim strUsers() as string dim strUser as string . . for each objConsole in objConsoles     console.writeline("Scope:" & objConsole.name     console.writeline("Users:" )     for each strUser in strUsers()         console.writeline ("   " & strUser)     next next