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.


Reply via email to