Forum Discussion

sjanacek's avatar
sjanacek
New Member
4 years ago
Solved

Query for SCCM required updates

Hi all! I'm building in Power Bi reports for our SCCM (System Center Configuration Manager). It's already connected and I'm pulling all data from the SCCM SQL server. Now I want to have a table wh...
  • sjanacek's avatar
    sjanacek
    4 years ago

    Hi,

    I found a pbix-template for SCCM and got now another solution, where I'm using this at the beginning:

    = SQL.database ("servername", "databasename", [query=..........])

     

    With this I can work now 🙂

     

    Thanks and have a greate new year! 

amitchandak's avatar
amitchandak
Super User
4 years ago

sjanacek , you can bring these tables in power bi and join CI_ID

 

you can create a calculated column for this

if (V_UpdateComplianceStatus [Status]=2 , "Yes",blank())

sjanacek's avatar
sjanacek
New Member
4 years ago

Hi,

I found a pbix-template for SCCM and got now another solution, where I'm using this at the beginning:

= SQL.database ("servername", "databasename", [query=..........])

 

With this I can work now 🙂

 

Thanks and have a greate new year!