Solved

microsoft excel query sccm database

Posted on 2012-12-28
1
2,290 Views
Last Modified: 2013-03-07
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
Comment
Question by:AnthonySmithMCP
1 Comment
 
LVL 9

Accepted Solution

by:
wasiftoor earned 500 total points
ID: 38732163
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

Too many email signature changes to deal with?

Are you constantly being asked to update your organization's email signatures? Do they take up too much of your time? Wouldn't you love to be able to manage all signatures from one central location, easily design them and deploy them quickly to users. Well, you can!

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now