We do a good amount of this, feeding to and from lots of different tools, JAMF, CA SAM, CA APM, and a few others.
Most of these tools use a single query to gather data, there really isn't much ad-hoc reporting. We vet the query and ensure it is properly written and performs well. Our SQL server has 64GB RAM and 16 vCPUs for roughly 63k clients. No issues on performance. Daniel Ratliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Enley, Carl Sent: Wednesday, March 01, 2017 9:45 AM To: mssms@lists.myitforum.com Subject: [mssms] SQL Query question / best practice I am curious is anyone has any thoughts / suggestions surrounding 3rd party applications / tools running queries directly against the SCCM SQL database. In my organization depending upon the company we have a few different asset management systems some are home brewed and others are 3rd party (manage engine) vendors. One of our biggest challenges is keeping all of our inventory / asset management systems in "sync" so to speak. I have been approached by a few different departments / companies that would like to run queries directly against the SCCM SQL instance rather than use any type of built in reports / queries. They would like to automate the export of client information in their home grown tool without changing their process to include running canned reports out of the console or website. I offered to provide subscriptions to those reports they feel would be valuable but was told it would require a change to their current process they were not prepared to make. So my thought is it should be no problem to provide them read only access to the database but my real concern is surrounding performance. I don't want someone running a poorly written SQL query against the database and possibly slowing down the system speed. When I suggested this could possibly happen I was assured by the developers that they are very experienced in writing SQL queries and this would not happen....yadda, yadda, yadda. Thanks for any suggestions. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.