SYSTEM AND METHODS FOR QUERYING A REPORT DATABASE

A decision support system including a query generation tool provides a Graphical User Interface (GUI) for generating a query of a Storage Area Network (SAN) database using interactive screen displays identifying manageable entities in the SAN and queryable statistics thereof. Configurations herein provide a query mechanism, or interface, that generates an executable query via a GUI having intuitive mnemonic labels corresponding to the real-world (i.e. SAN manageable entities) represented in the query database, rather than the technical database table and attribute names which tend to be more cryptic, particularly to an uninitiated query operator. The GUI presents a sequence of screens for selecting SAN manageable entities, report fields, selection criteria, and output format. The query logic computes SQL syntax for identifying corresponding database tables and attributes, performing the required joins between the tables, and selecting the report set of records for output in the resulting SQL query.