Difference between revisions of "SUSE Manager/Own Spacewalk Reports"

From MicroFocusInternationalWiki
Jump to: navigation, search
(Unsupportability warning made more explicit)
 
Line 2: Line 2:
 
= Creating own Reports for spacewalk-report =
 
= Creating own Reports for spacewalk-report =
  
The report definition files are placed in '''/usr/share/spacewalk/reports/data/'''.
+
'''WARNING''': creating ad-hoc SQL based reports:
 +
* '''is totally not supported'''
 +
* needs an understanding of the database schema, which is not explicitly documented
 +
* might break anytime, as the schema will change and we do not document these changes
  
''''NOTE'''': you need to understand the Database schema, to write useful reports.
+
The recommended way to extract custom information from SUSE Manager is through the XMLRPC API, which is guaranteed to be stable, supported and documented. Proceed at your own risk.
  
'''WARNING''': The prefered way to generate own reports is to use the XMLRPC API. The database schema will change and we do not document these changes.
+
The report definition files are placed in '''/usr/share/spacewalk/reports/data/'''.
  
  

Latest revision as of 06:20, 21 October 2016

SUSE Manager Main Page

Creating own Reports for spacewalk-report

WARNING: creating ad-hoc SQL based reports:

  • is totally not supported
  • needs an understanding of the database schema, which is not explicitly documented
  • might break anytime, as the schema will change and we do not document these changes

The recommended way to extract custom information from SUSE Manager is through the XMLRPC API, which is guaranteed to be stable, supported and documented. Proceed at your own risk.

The report definition files are placed in /usr/share/spacewalk/reports/data/.


Report definition format

 synopsis:
 
         <A short description>
 
 description:
 
         <a multiline
          description>
 
 columns:
 
         <column name 1>           <column description>
         <column name 2>           <column description>
         <column name 3>           <column description>
         <column name 4>           <column description>
 
 sql:
 
         <SQL SELECT statement 
          which result in one or multiple lines with the
          exact number of columns specified above>