Start a conversation

Articles

  • Purging Old FogBugz Data

    Overview At times, you may need to archive your old FogBugz data to save space. This article describes how to delete old cases from the database, including the instructions to delete cases only for a ...

  • Sanitizing Database for Testing

    Overview If you have a test instance of FogBugz with a separate database, you may want to be certain that it will not interfere with anything that your production instance is using. The sanitizing scr...

  • Removing Old Case or Email Attachments - FogBugz On-Premise

    Overview At times, you may need to delete old case attachments or email attachments from the database to save space. Deleting email or non-email attachments involves the same process and database quer...

  • Dealing with Rogue Cases - FogBugz On-Premise

    Overview FogBugz cases have a slight possibility of going rogue, meaning that the cases will be unreachable in FogBugz. This usually happens if you have deleted data directly from your database or imp...

  • Identifying the Size of FogBugz Database

    Overview Determining the size of a database is part of a system’s team operations to quantify and plan space management.     Information Environment FogBugz On-Premises/On-Site     Process The easiest...

  • User Inventory: Retrieving All Users through SQL Queries

    Objective This article provides SQL Query by which administrators can get a list of different types of users in FogBugz and also their counts. This will be very useful for the administrators in managi...

  • Access to FogBugz Source Code

    Overview If you are interested in FogBugz source code, for eg: what a given FogBugz API endpoint actually does, location in the FogBugz source code where the action is handled, and see which tables ar...

  • Checking Data Quality in FogBugz Databases

    Overview Despite our best efforts, data in On-Premise databases can become a bit glitchy at times due to issues in the customer environment, which can lead to data inconsistencies. Most of the time, S...

  • Database Schema of FogBugz

    Overview FogBugz uses an open and unlocked Microsoft SQL database to store its information. Using this guide, you should be able to navigate your database to find the information that you need. This a...