Currently on build 1602 planning to go to 1610 in the next 30 days. We do use RBA and I have added the service account they are using to perform queries as a "Read Only Analyst".
SQL Server 2014 From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones Sent: Wednesday, March 1, 2017 10:02 AM To: mssms@lists.myitforum.com Subject: [mssms] RE: SQL Query question / best practice Before making any suggestions, I have several questions 1. What version of CM are you using? 2. Do you use RBA? Aka will queries need to be RBA compliant? 3. What version of SQL are you using? From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Enley, Carl Sent: Wednesday, March 1, 2017 9:45 AM To: mssms@lists.myitforum.com<mailto: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.