john.rickard Posted September 22, 2014 Report post Posted September 22, 2014 Good Morning All, I am no wizard with SQL or even SCCM reporting, I have dabbled but that's about it... I am looking for a report which will tell me which applications, and which programs do not have any deployments? Can anyone help? Thanks John Rickard Quote Share this post Link to post Share on other sites More sharing options...
Atomic12 Posted September 22, 2014 Report post Posted September 22, 2014 Hi, maybe this could help you: Cheers, Quote Share this post Link to post Share on other sites More sharing options...
john.rickard Posted September 25, 2014 Report post Posted September 25, 2014 Thanks Atomic12 Unfortunately the reports which deal with deployments etc seem to all need there to be a deployment present... I basically need a report which lists applications and packages where the deployment count = 0 - for someone with some SQL knowledge it probably wouldnt take long to write, but I wouldnt know where to start... THanks John Quote Share this post Link to post Share on other sites More sharing options...
Benoit Lecours Posted September 25, 2014 Report post Posted September 25, 2014 Here's a basic query that will list all applications that don't have any deployments : select DisplayName,NumberOfDeployments from fn_ListLatestApplicationCIs(1033) where NumberOfDeployments = 0 Benoit Blog : http://www.systemcenterdudes.com Quote Share this post Link to post Share on other sites More sharing options...
john.rickard Posted October 10, 2014 Report post Posted October 10, 2014 Thank you! Any chance of one for packages? Quote Share this post Link to post Share on other sites More sharing options...
