• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 81
  • Last Modified:

powershell: get scep status from sccm 2012 (sql? )


I would like to query (via powershell)sccm or sql behind sccm the overall health of antivirus in a domain.
F.e.: 90 percent of clients have recent virus update (definition xyz), y number has definition older then a week,z pcs are infected etc.

The data is there in sccm and reportingserver but how can I retrieve this via Powershell?
Goal is to present this in a simple kpi dashboard, together with other figures.
Really prefer Powershell since it is most flexible vs Sql report of which my knowledge is basic.


  • 2
1 Solution
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Confirm -- you want to get the data from the "Antimalware overall status and history" report in SCCM?  (Or is it one of the other related reports?)
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Unfortunately I don't see a native SCCM Cmdlet to get what I think you want to display.

Since you said it was a SQL Report, the answer really doesn't change.  You can navigate thru the SQL Report server, and select the report you want to pull the data from.  If you don't wish to use the ReportServer front end for your dashboard, you can download the report definition... and even without the tool, the RDL file is just XML.  You can search for "CommandText", which will give you the various queries run from the database to generate the report.

Once you have those, you can invoke sql commands from powershell easily enough.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now