RE: [mssms] Hashes

2016-10-04 Thread Andreas Hammarskjöld
Ok, guess I will have to check then… wonder what the policy contains? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Todd Hemsell Sent: den 4 oktober 2016 15:39 To: mssms@lists.myitforum.com Subject: Re: [mssms] Hashes Jere is where it is in the CM12 DB

Re: [mssms] Hashes

2016-10-04 Thread Todd Hemsell
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

Re: [mssms] Hashes

2016-10-04 Thread Todd Hemsell
It uses several hashes, even within versions. SMS 2007 had an app you could get called "hashdir" and you would pass it the hash VERSION that you were using, and it could verify the hash. I have a copy and a script that more or less does what content validation in CM12 does... pulls a list of all pa

[mssms] Hashes

2016-10-04 Thread Andreas Hammarskjöld
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

Re: [mssms] RE: Report on VMware ESXI Servers in SCCM 2012?

2016-10-04 Thread Sherry Kissinger
I don't have an answer, but I have an "I wonder if..." direction for you to look at. Do you have full rights to the server which hosts your reporting site for SCCM? Particularly the SQL instance? Do you have (or can get) a service account with rights to the database which is the HP SIM data? (not

[mssms] RE: Report on VMware ESXI Servers in SCCM 2012?

2016-10-04 Thread Jason Sandys
Not without somehow sucking that data into ConfigMgr which would be a bad idea since ConfigMgr is not a CMDB. Why do you want to do this with ConfigMgr? As noted, it's not a CMDB. J From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Todd, Jason Sent: Tues

[mssms] Report on VMware ESXI Servers in SCCM 2012?

2016-10-04 Thread Todd, Jason
Hi All, Does anyone know if it's possible to perform hardware inventory of VMware ESXI Hypervisor servers (HP ProLiant) in SCCM 2012 R2 SP1? (without hacking the Hypervisor) Basically I pull hardware/software reports for various tasks (e.g. number of HP GEN 9 servers online in a certain site),