1 of 1 people found this helpful
LANDesk V 8.6.x and up use Active Reports from a company called Datadynamics. The "Canned Reports" are stored in the Reports.xml and the Reports Table in the Database. These "Standard Reports" were not really designed or intended to be customized I dont believe (although with some advanced information it can be done).The best way for us Novice types is to create a new custom Report and use the RPTQry from the Add Query List for the data and then use the Report Designer tool to customize the look and feel.
Thanks for the input. I think your "Novice types" suggestion implies developing the report from "scratch" albeit using the knowledge of what information is contained in the standard report.
You have peaked my curiosity and interest with the "advanced information it can be done" remark. As the second part of my question indicated I want to reference SLM compliance information that is software product related rather than the "Add Query" relationship of workstations only. If you or someone could provide the "advanced information" approach that may show me how the standard compliance report queries the database for compliance information that would be appreciated.
I am not at the client's site today to test the following thought but is another approach because I know the table name and fields with the compliance information, to update an existing query entry with the applicable table and field names to access that information? If that works how would I "trick" the query to specify which fields to display as I think I can only select fields not manually enter their names.
I am afraid you are well past my capability in Active Reports here. There is an HLD that should be available to you if you are an ESP. There is also advanced information on the vendor's site but that will take time to research... The queries are basically just SQL statements running against the Vulnerability table but the report is totally dependent on the query. The Query table holds the Predefined Queries for the canned reports (-RPTQRY) and I suppose these could be modified directly if someone knew SQL REAL WELL. I don't know the answer about fields to display but I believe the list presented is dependent on the columns that are present in the Data Query.