Thanks but after a little research it looks like power BI will not use Express…so if I want to create a solution to solve all of my needs it will have to be the Full Sql version.
Any idea if it would be covered under the CM license? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Wendell Hutchison Sent: Friday, March 3, 2017 11:12 AM To: mssms@lists.myitforum.com Subject: RE: [mssms] RE: SQL Query question / best practice Use Express. It is free and if you are only storing/sharing data it will work for your purpose. From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Enley, Carl Sent: Friday, March 3, 2017 5:55 AM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: RE: [mssms] RE: SQL Query question / best practice Another question – If I stand up another SQL server to host a replica of the CM database would the SQL license be covered by CM or would I need to buy another SQL license? I would only host the replica copy of the CM database on this second SQL install. I can think of a few good reasons to have the replicated CM database but need to understand if there is a cost involved. My thought is I could use this extra CM database to allow others to query against it as suggested in this thread. I also thought I may be able to use it for the test DB upgrade routine before I update CM versions. The final thought I had was we were looking at the SCCM power BI templates and it appears to require a second SQL server either local or Azure to pull its data from. Thanks 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 1:25 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: RE: [mssms] RE: SQL Query question / best practice Thanks for all of the replies, I was thinking the same thing about not letting them in. Hopefully it is not an impossible fight to win with management. Assuming I go down the replica database route what would be the suggested way to set that up? Is there a specific replication task that can be setup from within configuration manager or is this a SQL task that needs to be created? I assume I will need another server running the same version of SQL that I currently run and I either need to automate the replication or manually / script the database files over on some type of schedule. Would this secondary SQL server be required to have the Config Mgr client installed Thanks From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Sherry Kissinger Sent: Wednesday, March 1, 2017 10:29 AM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: Re: [mssms] RE: SQL Query question / best practice I agree with Troy--setup a replica database. We have two "classes" of people that desperately feel they need access to our data. For 1 set, the replica is what they get, and it works perfectly for their needs. There's another set of people who, through mainly political maneuvering, convinced the powers-that-be that only direct read-only access to the CM database would be acceptable. And guess what... sure, MOST of those people with direct access know sql and can craft a query that doesn't bring CM to it's knees. But about once a quarter some doofus who isn't as awesome in querying as he or she thinks they are... manage to craft something that blocks SQL from doing things like, say... processing hinv, or ddrs, or colleval, or... until whatever-it-is gets manually killed by us. And then we have to spend a few emails and/or meetings explaining to those people why they can't do that. (and then what I've seen them do--I've SEEN IT--they instead wait until 1am and run their cr@p when they think no one will notice their cr@p). So... don't let them in. Do whatever you can to keep them out. A whole new server, with a replica database, is the best way to keep your production database doing what it's supposed to be doing--managing systems. On Wed, Mar 1, 2017 at 9:02 AM, Garth Jones <ga...@enhansoft.com<mailto:ga...@enhansoft.com>> wrote: 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<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. -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger, http://www.smguru.org<http://webdefence.global.blackspider.com/urlwrap/?q=AXicE3RmeLubgeHvZgaGopxKA5MMveKiMr3cxMyc5Py8kqL8HL3k_FyGMiNDt8jM1GwDAxMLY0OG5NS8nNRKh8SizLSc1NQSsJKMkpICK3398vJyveLc9NKiUr38onQGBgbXNQwMAPJvIec&Z>