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 your own personal ID, you want a dedicated service account) Can you make a sql 'linked server' to the HP SIM database using that service account on your SCCM Reporting site?
If so... now that you have a linked server to the SIM data, on the server which hosts your SSRS site.. you can create CUSTOM sql SSRS reports that combine data on your cm database and the SIM database by using the linked server. it's not SUPER fun... but it's possible. Usually you need a SQL dba to get everything right. You might even be better off having a completely SEPARATE sql server; where all it does is have linked server connections to those other databases, and a completely separate SSRS instance to run that 1 report linking data from both databases. Larger companies will do that kind of thing--link to multiple data sources and make complex reports--but usually there's some over-arching database team that does all that. On Tue, Oct 4, 2016 at 8:33 AM, Jason Sandys <[email protected]> wrote: > 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:* [email protected] [mailto:listsadmin@lists. > myitforum.com] *On Behalf Of *Todd, Jason > *Sent:* Tuesday, October 4, 2016 8:23 AM > *To:* '[email protected]' <[email protected]> > *Subject:* [mssms] Report on VMware ESXI Servers in SCCM 2012? > > > > 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), but currently I have to use > a mix of HP SIM and SCCM to pull some reports as SCCM isn’t aware of the > ESX servers, I’d like to be able to report on ESX servers using SCCM. > > > > Many thanks, > > Jason > > > > > This email, the information therein and any attached materials > (collectively the "Email") are intended only for the addressee(s) and may > contain confidential, proprietary, copyrighted and/or privileged material. > If you have received this Email in error please delete it and notify the > sender immediately. This Email remains the property of Brevan Howard, which > reserves the right to require its return (together with any copies or > extracts thereof) at any time upon request. Any unauthorised review, > retransmission, dissemination, forwarding, printing, copying or other use > of this Email is prohibited. Brevan Howard may be legally required to > review and retain outgoing and incoming email and produce it to regulatory > authorities and others with legal rights to the information. Internet > communications cannot be guaranteed to be secure or error free as > information could be intercepted, changed corrupted, lost, arrive late or > contain viruses. Brevan Howard accepts no liability for any errors or > omissions in this Email which arise as a result of internet transmission. > This Email is not an official confirmation of any transaction. Any comments > or statements made herein do not necessarily reflect the views of Brevan > Howard. > This Email is not an offer to sell or solicitation of an offer to buy any > security or investment. It does not constitute or contain any investment > advice and is being made without regard to the recipients investment > objectives, financial situation or means. Past Performance is not an > indicator of future results and Brevan Howard provides no assurance that > future results will be consistent with any information provided herein or > attached hereto. Brevan Howard and the sender make no warranties regarding > the accuracy or completeness of the information in this Email and it should > not be relied upon and is subject to change without notice. Brevan Howard > and its representatives, officers and employees accept no responsibility > for any losses suffered as a result of reliance on the information in this > Email or the reliability, accuracy, or completeness thereof. > In this Email, "Brevan Howard" means Brevan Howard Asset Management LLP > ("BHAM"), Brevan Howard Inc., Brevan Howard (Israel) Ltd and their > respective affiliates. BHAM is a limited liability partnership authorised > and regulated by the Financial Conduct Authority of the United Kingdom and > registered in England & Wales (reg. no. OC302636). > > > > -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger, http://www.smguru.org
