SCCM 1806 Report Help - Deployments with Administrative Category

[Lynx101]

Hi all, I've tried and failed miserably! to work out how to do this using the Report Builder. Could anyone possibly help with creating an SQL query to create a deployment report which includes the Administrative Category? Example:

Application Name, Application Administrative Category, Target Collection, Success, In Progress, Fail, Requirements not met, Unknown.

Would really appreciate any assistance.

Thanks

Edited October 5, 2018 by Lynx101

[GarthMJ]

What do you have for you query already? What is not working with it? 

Here are a few reporting tips. Seven Tips for Writing SCCM dashboards

 

[Lynx101]

Many thanks for your post. What I have already is effectively two separate SQL queries. I am unable to work out how to join the two tables together so that the Administrative Category is displayed with the deployment summary information:

 

SELECT
  v_DeploymentSummary.SoftwareName
  ,v_DeploymentSummary.CollectionName
  ,v_DeploymentSummary.NumberSuccess
  ,v_DeploymentSummary.NumberInProgress
  ,v_DeploymentSummary.NumberUnknown
  ,v_DeploymentSummary.NumberErrors
  ,v_DeploymentSummary.NumberOther
  ,v_DeploymentSummary.NumberTotal
FROM
  v_DeploymentSummary

 

and

 

SELECT
  v_LocalizedCategories.CategoryInstanceName
FROM
  v_LocalizedCategories

 

Thanks in advance

[GarthMJ]

There is no directly link between those two SQL views. You will need to dig deeper to find a indirect link between them.