Enumeration

SQL (admin  admin@master)> SELECT name FROM master..sysdatabases
name        
---------   
master      

tempdb      

model       

msdb        

orcharddb   

SQL (admin  admin@master)> SELECT name FROM orcharddb..sysobjects WHERE xtype = 'U';
name                                                   
----------------------------------------------------   
blog_Orchard_Blogs_RecentBlogPostsPartRecord           

blog_Orchard_Blogs_BlogArchivesPartRecord              

blog_Orchard_Workflows_TransitionRecord                

blog_Orchard_Workflows_WorkflowRecord                  

blog_Orchard_Workflows_WorkflowDefinitionRecord        

blog_Orchard_Workflows_AwaitingActivityRecord          

blog_Orchard_Workflows_ActivityRecord                  

blog_Orchard_Tags_TagsPartRecord                       

blog_Orchard_Framework_DataMigrationRecord             

blog_Orchard_Tags_TagRecord                            

blog_Orchard_Tags_ContentTagRecord                     

blog_Settings_ContentFieldDefinitionRecord             

blog_Orchard_Framework_DistributedLockRecord           

blog_Settings_ContentPartDefinitionRecord              

blog_Settings_ContentPartFieldDefinitionRecord         

blog_Settings_ContentTypeDefinitionRecord              

blog_Settings_ContentTypePartDefinitionRecord          

blog_Settings_ShellDescriptorRecord                    

blog_Settings_ShellFeatureRecord                       

blog_Settings_ShellFeatureStateRecord                  

blog_Settings_ShellParameterRecord                     

blog_Settings_ShellStateRecord                         

blog_Orchard_Framework_ContentItemRecord               

blog_Orchard_Framework_ContentItemVersionRecord        

blog_Orchard_Framework_ContentTypeRecord               

blog_Orchard_Framework_CultureRecord                   

blog_Common_BodyPartRecord                             

blog_Common_CommonPartRecord                           

blog_Common_CommonPartVersionRecord                    

blog_Common_IdentityPartRecord                         

blog_Containers_ContainerPartRecord                    

blog_Containers_ContainerWidgetPartRecord              

blog_Containers_ContainablePartRecord                  

blog_Title_TitlePartRecord                             

blog_Navigation_MenuPartRecord                         

blog_Navigation_AdminMenuPartRecord                    

blog_Scheduling_ScheduledTaskRecord                    

blog_Orchard_ContentPicker_ContentMenuItemPartRecord   

blog_Orchard_Alias_AliasRecord                         

blog_Orchard_Alias_ActionRecord                        

blog_Orchard_Autoroute_AutoroutePartRecord             

blog_Orchard_Users_UserPartRecord                      

blog_Orchard_Roles_PermissionRecord                    

blog_Orchard_Roles_RoleRecord                          

blog_Orchard_Roles_RolesPermissionsRecord              

blog_Orchard_Roles_UserRolesPartRecord                 

blog_Orchard_Packaging_PackagingSource                 

blog_Orchard_Recipes_RecipeStepResultRecord            

blog_Orchard_OutputCache_CacheParameterRecord          

blog_Orchard_MediaProcessing_ImageProfilePartRecord    

blog_Orchard_MediaProcessing_FilterRecord              

blog_Orchard_MediaProcessing_FileNameRecord            

blog_Orchard_Widgets_LayerPartRecord                   

blog_Orchard_Widgets_WidgetPartRecord                  

blog_Orchard_Comments_CommentPartRecord                

blog_Orchard_Comments_CommentsPartRecord               

blog_Orchard_Taxonomies_TaxonomyPartRecord             

blog_Orchard_Taxonomies_TermPartRecord                 

blog_Orchard_Taxonomies_TermContentItem                

blog_Orchard_Taxonomies_TermsPartRecord                

blog_Orchard_MediaLibrary_MediaPartRecord              

blog_Orchard_Blogs_BlogPartArchiveRecord               

SQL (admin  admin@master)> SELECT * FROM orcharddb..blog_Orchard_Users_UserPartRecord
Id   UserName   Email             NormalizedUserName   Password                                                               PasswordFormat   HashAlgorithm   PasswordSalt               RegistrationStatus   EmailStatus   EmailChallengeToken   CreatedUtc            LastLoginUtc          LastLogoutUtc         
--   --------   ---------------   ------------------   --------------------------------------------------------------------   --------------   -------------   ------------------------   ------------------   -----------   -------------------   -------------------   -------------------   -------------------   
 2   admin                        admin                AL1337E2D6YHm0iIysVzG8LA76OozgMSlyOJk1Ov5WCGK+lgKY6vrQuswfWHKZn2+A==   Hashed           PBKDF2          UBwWF1CQCsaGc/P7jIR/kg==   Approved             Approved      NULL                  2017-09-01 13:44:01   2017-09-01 14:03:50   2017-09-01 14:06:31   

15   James      james@htb.local   james                J@m3s_P@ssW0rd!                                                        Plaintext        Plaintext       NA                         Approved             Approved      NULL                  2017-09-01 13:45:44   NULL                  NULL

PreviousFoothold Nextjames

Last updated 11 months ago

Was this helpful?

SQL (admin admin@master)> SELECT name FROM master..sysdatabases name --------- master tempdb model msdb orcharddb SQL (admin admin@master)> SELECT name FROM orcharddb..sysobjects WHERE xtype = 'U'; name ---------------------------------------------------- blog_Orchard_Blogs_RecentBlogPostsPartRecord blog_Orchard_Blogs_BlogArchivesPartRecord blog_Orchard_Workflows_TransitionRecord blog_Orchard_Workflows_WorkflowRecord blog_Orchard_Workflows_WorkflowDefinitionRecord blog_Orchard_Workflows_AwaitingActivityRecord blog_Orchard_Workflows_ActivityRecord blog_Orchard_Tags_TagsPartRecord blog_Orchard_Framework_DataMigrationRecord blog_Orchard_Tags_TagRecord blog_Orchard_Tags_ContentTagRecord blog_Settings_ContentFieldDefinitionRecord blog_Orchard_Framework_DistributedLockRecord blog_Settings_ContentPartDefinitionRecord blog_Settings_ContentPartFieldDefinitionRecord blog_Settings_ContentTypeDefinitionRecord blog_Settings_ContentTypePartDefinitionRecord blog_Settings_ShellDescriptorRecord blog_Settings_ShellFeatureRecord blog_Settings_ShellFeatureStateRecord blog_Settings_ShellParameterRecord blog_Settings_ShellStateRecord blog_Orchard_Framework_ContentItemRecord blog_Orchard_Framework_ContentItemVersionRecord blog_Orchard_Framework_ContentTypeRecord blog_Orchard_Framework_CultureRecord blog_Common_BodyPartRecord blog_Common_CommonPartRecord blog_Common_CommonPartVersionRecord blog_Common_IdentityPartRecord blog_Containers_ContainerPartRecord blog_Containers_ContainerWidgetPartRecord blog_Containers_ContainablePartRecord blog_Title_TitlePartRecord blog_Navigation_MenuPartRecord blog_Navigation_AdminMenuPartRecord blog_Scheduling_ScheduledTaskRecord blog_Orchard_ContentPicker_ContentMenuItemPartRecord blog_Orchard_Alias_AliasRecord blog_Orchard_Alias_ActionRecord blog_Orchard_Autoroute_AutoroutePartRecord blog_Orchard_Users_UserPartRecord blog_Orchard_Roles_PermissionRecord blog_Orchard_Roles_RoleRecord blog_Orchard_Roles_RolesPermissionsRecord blog_Orchard_Roles_UserRolesPartRecord blog_Orchard_Packaging_PackagingSource blog_Orchard_Recipes_RecipeStepResultRecord blog_Orchard_OutputCache_CacheParameterRecord blog_Orchard_MediaProcessing_ImageProfilePartRecord blog_Orchard_MediaProcessing_FilterRecord blog_Orchard_MediaProcessing_FileNameRecord blog_Orchard_Widgets_LayerPartRecord blog_Orchard_Widgets_WidgetPartRecord blog_Orchard_Comments_CommentPartRecord blog_Orchard_Comments_CommentsPartRecord blog_Orchard_Taxonomies_TaxonomyPartRecord blog_Orchard_Taxonomies_TermPartRecord blog_Orchard_Taxonomies_TermContentItem blog_Orchard_Taxonomies_TermsPartRecord blog_Orchard_MediaLibrary_MediaPartRecord blog_Orchard_Blogs_BlogPartArchiveRecord SQL (admin admin@master)> SELECT * FROM orcharddb..blog_Orchard_Users_UserPartRecord Id UserName Email NormalizedUserName Password PasswordFormat HashAlgorithm PasswordSalt RegistrationStatus EmailStatus EmailChallengeToken CreatedUtc LastLoginUtc LastLogoutUtc -- -------- --------------- ------------------ -------------------------------------------------------------------- -------------- ------------- ------------------------ ------------------ ----------- ------------------- ------------------- ------------------- ------------------- 2 admin admin AL1337E2D6YHm0iIysVzG8LA76OozgMSlyOJk1Ov5WCGK+lgKY6vrQuswfWHKZn2+A== Hashed PBKDF2 UBwWF1CQCsaGc/P7jIR/kg== Approved Approved NULL 2017-09-01 13:44:01 2017-09-01 14:03:50 2017-09-01 14:06:31 15 James james@htb.local james J@m3s_P@ssW0rd! Plaintext Plaintext NA Approved Approved NULL 2017-09-01 13:45:44 NULL NULL