Spectrum Reporting Schema

Loftware Spectrum® includes a reporting schema (LOFTREPORTS) that you can use to retrieve configuration and status details about objects in Spectrum. This allows you to write reports against a known interface that abstracts any underlying changes that could impact the reports.

• Sample Queries
• Reporting Schema Reference

Note: A user account named LOFTUSER (Oracle) or loftuser (PostgreSQL) exists in the Spectrum database (LoftStore). This user account has the permissions necessary to see views and run reports using the Spectrum Reporting Schema. If you are using Loftware Spectrum Cloud, Loftware Cloud Operations may have assigned a unique username for your reporting user account. Contact Loftware Cloud Operations for details.

Note: If you are using Loftware Spectrum Cloud, Loftware Cloud Operations may have assigned unique names for the reporting schema and the auditing schema for your Spectrum instance. Contact Loftware Cloud Operations for details.