Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
gINT | Keynetix Wiki How many locations do I have in HoleBASE?
    • Sign In
    • -gINT | Keynetix Wiki
      • +gINT
      • +gINT Collector
      • +gINT Civil Tools
      • -Keynetix
        • +Installing or Upgrading to CONNECT Edition
        • +Archive Webinars
        • -HoleBASE
          • +Getting Started
          • +HoleBASE - Setup and Installation
          • HoleBASE Professional Release Notes
          • -HoleBASE: FAQs
            • +Background Mapping
            • +Components and Configuration Packs
            • -Data Management
              • 'Project Currently Locked' message when attempting an import
              • 'Unrecognised Column' warning when importing data
              • AGS Import Warning : [Field Name] will be ignored because the destination is a calculated field
              • AGS mapping isn't showing but the data exports correctly
              • How can a GPS file be prepared for import?
              • How CPT Data Works in the HBSI
              • How many locations do I have in HoleBASE?
              • How to do a basic Export of AGS data from HoleBASE SI
              • How to enter Pipe Records in HoleBASE SI
              • How To Enter Special Characters
              • How to Export multiple projects to AGS from HoleBASE 3.1 to import to HBSI
              • How To set up installation instrument drawing types
              • How To Template
              • How To Use a Case Sensitive Search to Create Geology Code 2 data automatically
              • Importing AGSv4 file and get a message saying TYPE table can't be found
              • Incorrect Display Format Error Message when importing Test Schedule
              • Is there a list of non-standard AGS 4 fields that have been added to HoleBASE SI?
              • ISPT - ISPT_NVAL will be ignored... message when importing data into HoleBASE SI
              • What is a CSV file?
              • What is the Data Journey?
              • Where should coring data be entered or edited
              • Why Can HoleBASE SI Not Handle High Precision Data?
            • +Depth Linking
            • +Logs
            • +Trigger Sets and Report Grids
            • +User Accounts
            • +Working with Projects
          • +How Tos
          • +Issues
        • +HoleBASE Civil Extension
        • +HoleBASE Data Entry
        • +HoleBASE Excel Extension
        • +HoleBASE Template Studio
        • +KeyAGS
        • +KeyLAB
        • +Keynetix Component Downloads
        • +Working from Home with Keynetix Products
        • Hardware Specifications and Recommendations
        • Supported Platforms

     
     Questions about this article, topic, or product? Click here. 

    How many locations do I have in HoleBASE?

    Follow the steps below to answer this question:-

    • Open SQL Management Studio and connect to the SQL Server that has HoleBASE on it. You will know when you have connected as there will be 4 databases that start with HBSI.
    • Select the HBSI database and click the New Query button on the ribbon (as shown below)

    • Copy and paste the following SQL statement into the SQL Query Window.

      Select count(project) as Number_of_Locations from COR_LocationDetails where sysaction != 'delete'
    • Make sure the HBSI database is selected from the drop down list as shown below and click the Execute button.
    • The results will be displayed in the Results Panel (50 as shown below)

     

    • Share
    • History
    • More
    • Cancel
    • Stephen Evason Created by Bentley Colleague Stephen Evason
    • When: Mon, Nov 22 2021 8:24 AM
    • Stephen Evason Last revision by Bentley Colleague Stephen Evason
    • When: Mon, Nov 22 2021 8:24 AM
    • Revisions: 2
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies