Avatar of janhoedt
janhoedt
 asked on

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

Hi,

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.

Thanks!

J.
PowershellSCCM

Avatar of undefined
Last Comment
Rich Weissler

8/22/2022 - Mon
Rich Weissler

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?)
ASKER CERTIFIED SOLUTION
Rich Weissler

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes