SQLTeam.com | Weblogs | Forums

SSRS Server Inventory Report from SCCM 2012 Collection


#1

Hi, I am having an issue and was wondering if you could help. All I need is a way in SSRS in the query to have it look at an SCCM collection to get the computers for the report. I want to do this in SSRS as it can modify the output file in excel to email, remove headers etc…

Fields I want it to pull
Computer name
OS
IP
Model
Ram
Speed
Hard Disk
Free Disk

Can just grab someone else’s report from google, but cant figure out how to have it look at a specific SCCM collection…

Thanks