RCM Desktop - RCM software written by RCM facilitators for RCM facilitators
  • Home
    • 4 Steps to Improving Facilitator Productivity
    • Your Questions Answered >
      • What About Technical Support?
      • What is RCM Desktop?
      • Why Do I Need RCM Desktop?
      • What Does RCM Desktop Do?
      • Can I Try RCM Desktop?
      • How Much Does RCM Desktop Cost?
      • Will RCM Desktop Run On A Network?
      • Technical Information for IT Departments
  • Editions
  • Table of Features
    • By Time Saving Features >
      • ⭐⭐⭐⭐⭐Star >
        • ⭐⭐⭐⭐⭐Facilitate Tab
        • ⭐⭐⭐⭐⭐"As 1A1" Copying
        • ⭐⭐⭐⭐⭐Drag & Drop
        • ⭐⭐⭐⭐⭐Decision Logic: "Go to Target"
        • ⭐⭐⭐⭐⭐Live Spell Check & Auto Correction
        • ⭐⭐⭐⭐⭐Worth Doing Calculator
        • ⭐⭐⭐⭐⭐Audit Report
        • ⭐⭐⭐⭐⭐Decision Logic: Display
        • ⭐⭐⭐⭐⭐Decision Logic Validation
        • ⭐⭐⭐⭐⭐​​Links to Photos & Drawings
      • ⭐⭐⭐⭐Star >
        • ⭐⭐⭐⭐Supporting Comments
        • ⭐⭐⭐⭐Export Maintenance Tasks
        • ⭐⭐⭐⭐Analysis Renumbering
        • ⭐⭐⭐⭐User-Defined & Customised Reports
        • ⭐⭐⭐⭐Full SQL Access
        • ⭐⭐⭐⭐Data Grids
      • ⭐⭐⭐Star >
        • ⭐⭐⭐ User-definable Decision Logic
        • ⭐⭐⭐Functions and Failures
        • ⭐⭐⭐Maintenance Task Descriptions
        • ⭐⭐⭐Basic Reports
        • ⭐⭐⭐Backup & Restore
        • ⭐⭐⭐Copy Analysis
        • ⭐⭐⭐Fault-finding Guide
        • ⭐⭐⭐Spares Policy
        • ⭐⭐⭐Criticality Assessment
        • ⭐⭐⭐Search & Replace
        • ⭐⭐⭐Spell Check
        • ⭐⭐⭐Analysis Check-out / Check-in
        • ⭐⭐⭐​​Advanced Failure-finding Formulae
        • ⭐⭐⭐​​Links to External Documents & Drawings
      • ⭐⭐Star >
        • ⭐⭐Worksheet View
        • ⭐⭐Asset Hierarchy
        • ⭐⭐Basic Failure-finding Formulae
        • ⭐⭐​​Importing & Exporting
        • ⭐⭐Record Significant Findings
      • ⭐Star >
        • ⭐Analysis Properties
        • ⭐Analysis Diary
        • ⭐Analysis Status
        • ⭐Company Information
        • ⭐Record Documentation Errors
        • ⭐Record Queries & Actions
        • ⭐User Management
    • By Software Edition >
      • Ultimate & Advanced Editions
      • Intermediate & Basic Editions
  • Videos
    • Short Overview Video
    • Short 'How to...' Videos
    • Long Demonstration Video
  • Benefits
  • Brochure
  • Online Trial
  • White Papers
  • Contact
  • Support
  • Screenshots
  • Version History

SQL Access & Visual Query Builder

This feature is included in the Ultimate Edition
Time-saving rating....
Picture
RCM Desktop Ultimate Edition provides full SQL access to all the tables in the RCM database.

This is intended for expert users who require the ability to run complex queries in order to view and/or export any of their raw RCM data for whatever reason (such as exporting a list of failure modes to a CMMS).

Any standard SQL query can be executed provided it does not attempt to update any data or amend any data definitions.

A visual query builder is provided which permits building complex SQL queries via an intuitive visual query building interface.

To work with the Query Builder you need basic knowledge of SQL concepts. The Query Builder will help you to write correct SQL code, hiding technical details, but an understanding of SQL principles is still required to achieve the desired results.

SQL queries can be saved for re-use. Query output can be printed or exported to disk in XML, HTML, XLS and plain text formats.
SQL Access & Visual Query Builder
PRIVACY
© COPYRIGHT 2010-2022. ALL RIGHTS RESERVED.
  • Home
    • 4 Steps to Improving Facilitator Productivity
    • Your Questions Answered >
      • What About Technical Support?
      • What is RCM Desktop?
      • Why Do I Need RCM Desktop?
      • What Does RCM Desktop Do?
      • Can I Try RCM Desktop?
      • How Much Does RCM Desktop Cost?
      • Will RCM Desktop Run On A Network?
      • Technical Information for IT Departments
  • Editions
  • Table of Features
    • By Time Saving Features >
      • ⭐⭐⭐⭐⭐Star >
        • ⭐⭐⭐⭐⭐Facilitate Tab
        • ⭐⭐⭐⭐⭐"As 1A1" Copying
        • ⭐⭐⭐⭐⭐Drag & Drop
        • ⭐⭐⭐⭐⭐Decision Logic: "Go to Target"
        • ⭐⭐⭐⭐⭐Live Spell Check & Auto Correction
        • ⭐⭐⭐⭐⭐Worth Doing Calculator
        • ⭐⭐⭐⭐⭐Audit Report
        • ⭐⭐⭐⭐⭐Decision Logic: Display
        • ⭐⭐⭐⭐⭐Decision Logic Validation
        • ⭐⭐⭐⭐⭐​​Links to Photos & Drawings
      • ⭐⭐⭐⭐Star >
        • ⭐⭐⭐⭐Supporting Comments
        • ⭐⭐⭐⭐Export Maintenance Tasks
        • ⭐⭐⭐⭐Analysis Renumbering
        • ⭐⭐⭐⭐User-Defined & Customised Reports
        • ⭐⭐⭐⭐Full SQL Access
        • ⭐⭐⭐⭐Data Grids
      • ⭐⭐⭐Star >
        • ⭐⭐⭐ User-definable Decision Logic
        • ⭐⭐⭐Functions and Failures
        • ⭐⭐⭐Maintenance Task Descriptions
        • ⭐⭐⭐Basic Reports
        • ⭐⭐⭐Backup & Restore
        • ⭐⭐⭐Copy Analysis
        • ⭐⭐⭐Fault-finding Guide
        • ⭐⭐⭐Spares Policy
        • ⭐⭐⭐Criticality Assessment
        • ⭐⭐⭐Search & Replace
        • ⭐⭐⭐Spell Check
        • ⭐⭐⭐Analysis Check-out / Check-in
        • ⭐⭐⭐​​Advanced Failure-finding Formulae
        • ⭐⭐⭐​​Links to External Documents & Drawings
      • ⭐⭐Star >
        • ⭐⭐Worksheet View
        • ⭐⭐Asset Hierarchy
        • ⭐⭐Basic Failure-finding Formulae
        • ⭐⭐​​Importing & Exporting
        • ⭐⭐Record Significant Findings
      • ⭐Star >
        • ⭐Analysis Properties
        • ⭐Analysis Diary
        • ⭐Analysis Status
        • ⭐Company Information
        • ⭐Record Documentation Errors
        • ⭐Record Queries & Actions
        • ⭐User Management
    • By Software Edition >
      • Ultimate & Advanced Editions
      • Intermediate & Basic Editions
  • Videos
    • Short Overview Video
    • Short 'How to...' Videos
    • Long Demonstration Video
  • Benefits
  • Brochure
  • Online Trial
  • White Papers
  • Contact
  • Support
  • Screenshots
  • Version History