Assuming I've got the right uniqueid location... try this (if it's not right, at least it's something to try)
select vui.ArticleID, vui.Title, vui.ci_uniqueID, p.Name, P.Description from dbo.vUpdatetoPkg as vutp join dbo.v_updateinfo as vui on vui.ci_id=vutp.ci_id join dbo.v_package as p on p.PackageID=vutp.PkgId where vui.CI_UniqueID = '627de01d-44d2-4cf8-8d37-050098ed94e4' On Wed, Sep 28, 2016 at 3:13 AM, Kehl Reto <[email protected]> wrote: > How can I get the Software Package for this ID? (SCCM 2012 R2 SP1) > > > > Download of the content "627de01d-44d2-4cf8-8d37-050098ed94e4" - "1" has > failed.. > > Possible cause: The content can not be found on the network, or the > content could not be accessed. > > Solution: Check to ensure this content has been made available on a > distribution point. Check to ensure the access control list allows this > program to be accessed. Check to make sure that the file system path for > the content, including the path to the cache directory, is not greater than > 255 characters. > > > > TIA > > > > Reto > > -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger, http://www.smguru.org
