Bentley Communities
Site
Search
User
Site
Search
User
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
Created by
Stephen Evason
When:
Mon, Nov 22 2021 8:24 AM
Last revision by
Stephen Evason
When:
Mon, Nov 22 2021 8:24 AM
Revisions:
2
Comments:
0
Recommended
Related