SQL Reporting Services

[bireland]

   I have an audit request to provide a patch report that contains the installation date of each patch. None of the default reports provide this information. I would like to edit the "Windows Patch Status by Template Details" report to include a field for "Installed Date". Can anyone provide instructions?

[Oulyanov]

Quick and dirty - assume that you have good expirience with SSRS/T-SQL

If patch is deployed via VCM then check the output of the following queries:

SELECT Distinct template_id as Value, object_name AS Label

FROM    dbo.ecm_sysview_sum_templates

Select * from dbo.ecmSUM_fn_template_assessment_t('template_id',0)

check value for deployement_date.

if this is what you're looking for - you're lucky) you should be able to pretty easy add this to mentioned report using Report builder - ensure to use version 2.0 for compatibility.

Regards, Oleg