1- In reporter create a new report of type "Asset or User Report".
Rename it for example "Number SD deployment in the last 30 days".
In Fields tab, click on Add... button
Click on Software and choose "Software Packages" tab.
Expand Deployment/<All> and choose Completion Time and others fields requested.
2- Click on OK and go in Filter tab.
Put this filter :
Completion Time[All]
>
123456789
Then check the checkbox "Enable this filter for all new results"
3- Click on Default View and select "Custom HTML View"
Click on Settings... button
Click on Groups tab
add for example these 2 groups :
Deployment>SW Package Name
Deployment>SW Package Version
Click on OK and close the reporter.
4- Open Microsoft SQL Server Management Studio and execute following SQL request :
use mdb
UPDATE rpfilter
SET argspec='DataType=4;'+CHAR(13)+CHAR(10)+'SqlName=datediff(ss,convert(datetime,''19700101''),getutcdate())-30*24*60*60;'+CHAR(13)+CHAR(10)
WHERE tplid in (SELECT objid FROM rptpl WHERE objname='Number SD deployment in the last 30 days') and name='123456789' and resid=-1 and type=2
Remarks :
- 30*24*60*60 is 30 days exprimed in seconds (30 days * 24 hours * 60 minutes * 60 seconds).
5- Open the reporter and execute the report
Only SD jobs deployed during 30 last days should appear.
At top is indicated the number of SD Jobs (in status OK, Waiting or OK)