Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2750
  • Last Modified:

microsoft excel query sccm database

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
0
AnthonySmithMCP
Asked:
AnthonySmithMCP
1 Solution
 
wasiftoorCommented:
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.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now