Category / ConfigMgr (SCCM) / Power BI / SQL
-
Connect ConfigMgr to Power BI
I sometimes hear device management professionals saying something like, “I haven’t got around to using PowerShell yet” or “I haven’t had time to look into InTune and Azure yet”. Most people in the industry will agree that this is the future of device management, but getting started with a new technology takes some effort getting…
-
SQL query – computers where an app is NOT installed
SQL query which will return the computers, where a given application is NOT installed…
-
Unlock task sequence in SCCM after console crash
Open SQL Server Studio Management (SSMS), select the Config Manager db and create a new query: select * from SEDO_LockState where LockStateID <> 0 Execute the query and copy the ID from the output. Then create a new query: DELETE from SEDO_LockState where LockID = '<LockID of the record identified in the previous query>' Execute…