Get answers from your peers along with millions of IT pros who visit Spiceworks.
Join Now

Hi all,

I have integrated Power BI with SCCM. I am now trying to create a device map.

Would anyone be able to assist with the SQL query needed to pull this data into Power BI table so i can use it.

Thanks in advance!


Learn DNS with this advanced Article
This is the 410th entry in the Spotlight on IT. Interested in writing a post? PM Lee to get started. Starting the second week of July 201...
TEST YOUR SMARTS
Which of the following retains the information it's storing when the system power is turned off?
  • GPU
  • RAM
  • CPU
  • ROM
88% of IT pros got this right.
Oops, something's wrong below.