Share via

Script to export SCCM console query results?

Courtney Regan 71 Reputation points
2023-03-06T19:56:15.5433333+00:00

Hi All - I have a big query and when I run it in the SCCM console (on my PC or the SCCM server) it does populate all the expected data. However the console crashes (on PC or server) every time I try to export using CTRL+A & CTRL & CTRL-P Do any of you know of or have a script that will export it all into a CSV or Excel file?

Windows for business | Windows Server | User experience | PowerShell
Microsoft Security | Intune | Configuration Manager | Other

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Garth 881 Reputation points
    2023-03-06T20:58:40.2366667+00:00

    I would use SQL for this instead with PowerShell, this will cause a lot less overhead compared to methods. This article will give you the basic steps. https://askgarth.com/blog/how-to-use-powershell-to-query-sql-database/

    1 person found this answer helpful.
    0 comments
  2. Courtney Regan 71 Reputation points
    2023-03-28T15:15:29.4633333+00:00

    Hello - Sorry for the reply. No I didn't use Garths suggestion. I just removed a few attributes from the query and eventually I was able to get the data out and into excel.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.