How to create report on SD Jobs deployed during the last 30 days.

Document ID : KB000072169
Last Modified Date : 26/02/2018
Show Technical Document Details
Question:
How to create a report showing all SD jobs sent to the machines during the last 30 days ?
 
Answer:

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.

 
User-added image


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"
 
User-added image



3- Click on Default View and select "Custom HTML View"
 
User-added image

Click on Settings... button
Click on Groups tab
 
add for example these 2 groups :

 
Deployment>SW Package Name
Deployment>SW Package Version

 
User-added image

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).
 

User-added image

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)

 
User-added image