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)