Jump to content


Lynx101

New Members
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Lynx101

  • Rank
    Newbie

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. 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
  2. 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
×
×
  • Create New...