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.
