SOLVED SCCM reports to get all active deployments

[dj3094]

Hello experts,
We are trying to build a dashboard to get all active deployments. and drill through to collections when I click on deployment.
Is that possible?

Regards
DJ

 

[RJONA]

Do you want a SQL query? If so, you can use something like this and import into SSRS Report Builder and create dashboards from there.

Select Softwarename,CollectionName,Collectionid,ds.DeploymentTime,NumberSuccess,NumberInProgress,NumberErrors,NumberUnknown,NumberTotal
from v_DeploymentSummary DS
where softwarename <> ' '
group by SoftwareName, collectionname,DeploymentTime,NumberSuccess,NumberInProgress,NumberErrors,NumberUnknown,NumberTotal,Collectionid

 

[dj3094]

Thanks will try that

 

[dj3094]

But how to create dashboard

 

[RJONA]

you can watch this video on SSRS Report Builder.

 

[dj3094]

please close this thanks