Avatar of Ryan Smith
Ryan Smith
Flag for United States of America asked on

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
Microsoft SQL ServerMicrosoft ExcelWindows Server 2008

Avatar of undefined
Last Comment
wasiftoor

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
wasiftoor

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes