Jere is where it is in the CM12 DB.
Select * From CI_ContentFiles -- has per file hash Select Content_ID, SourceSize, ContentHash, ContentHashVersion From CI_Contents -- has the hash for content using hash version 0 Select * From PackageContentInfoHash -- unused? Select * From SMSContentHash -- Contains the hash for all content using Hash Version 4 Select PkgID, PackageType, SourceSize, HASH, HashVersion, NewHash From SMSPackages Where LEN(NewHash) > 10 -- PackageType 0, 3, 257, 258, and 259 have a hash On Tue, Oct 4, 2016 at 11:27 AM, Andreas Hammarskjöld < [email protected]> wrote: > What kind of hash does ConfigMgr keep for the content in the DB/Client? > SHA-256? > > > > Reading here it seems that its SHA-256, has that always been the case? > https://technet.microsoft.com/en-us/library/hh427327.aspx > > > > //A > > > > Regards, > > > > Andreas Hammarskjöld > > Co-Founder & Dev Guy > 2Pint Software <https://2pintsoftware.com/> > > Mobile: +46 727 253995 > > [email protected] > > https://twitter.com/AndHammarskjold > > > > > >
