microsoft excel query sccm database

AnthonySmithMCP
AnthonySmithMCP used Ask the Experts™
on
Background:
I needed to create an Excel spreadsheet that will show reporting data (specifically Add and Remove Programs). I edited the SCCM report “93” to exclude things like Windows and Office patches. After I ran the report I copied and paste the link next to the computer name within excel. So basically if the user who’s viewing the spreadsheet has read access to the SCCM database they can open the link and see the data. The link opens up the report in IE.

 What I need:
I want to somehow create a query in excel that will connect to the SCCM database and run my query then import the data into a column in Excel
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can Query directly from the SQLServer instance hosting the SCCM database in Excel by Going to Data > From Other Sources > From SQL Server.

Hope this helps.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial